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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top


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



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
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

Your Answer


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.