Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

UPDATE

I am getting the following error when I try to create a new database in IBM Data Studio v3.1.1.0.

The connectivity libraries that are needed for local or remote non-JDBC operations were not found. To provide these libraries, you can install IBM data server client or a local DB2 server instance.

I have already started the instance using

db2start

command.

After searching exhaustively, I am not able to find any help on the internet regarding this error.

share|improve this question
    
Can you provide any SQL codes or reasons from the error? Also I am wondering where are you trying to create this on? Did you specify the node (local or remote)? to create the database on? –  Chris Aldrich Jan 7 '13 at 14:41
    
Do you have the DB2 server and Data Studio installed on the same machine? If not, you should follow the advice in the error message and install the DB2 client software. If yes, make sure that for the user that runs Data Studio the environment is set up correctly, so that the DB2 CLI libraries can be found. –  mustaccio Jun 11 '13 at 0:34
add comment

1 Answer

up vote 0 down vote accepted

You may need to point IBM Data Studio to the database drivers. They are usually installed with DB2 under /myDB2_InstallationDirectory/SQLLIB/java.

The drivers themselves tend to be

  • db2jcc.jar
  • db2jcc_license_cu.jar

There are other drivers in that folder as well, but these two tend to be the main ones for Java (which IBM Data Studio is based on).

share|improve this answer
    
thanks. it worked :) –  Srivathsa Jun 12 '13 at 5:44
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.