I'm getting the following when trying to create a new database using the Data Studio 18.104.22.168 administration client in a local DB2 instance:
"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 database server instance."
This is under 64-bit RHEL 6.3, running from the Gnome desktop. I would have thought this was a problem with LD_LIBRARY_PATH, but my .bashrc is running /home/db2inst/sqllib/db2profile, and LD_LIBRARY_PATH looks like this:
All 3 of the following are in my PATH: /home/db2inst1/slqllib/bin, /home/db2inst1/sqllib/adm and /home/db2inst1/sqllib/misc
I've seen messages from others with the same problem under Windows that resolved it by including sqllib\bin in the PATH, but it looks like I've already got that covered.
Can anyone provide any guidance?
Thanks in advance for any help.
This topic has been locked.
6 replies Latest Post - 2013-02-23T01:55:03Z by firstname.lastname@example.org
Pinned topic Can't Create Database - Connectivity Libraries Not Found
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-23T01:55:03Z at 2013-02-23T01:55:03Z by email@example.com
SystemAdmin 110000D4XK1632 Posts
Re: Can't Create Database - Connectivity Libraries Not Found2013-02-13T23:30:21Z in response to SystemAdminHi Dale,
I can try to help you solve your problem although, admittedly, I am a little surprised by the error message because the error is generally associated with a Windows setup. But let's give it a try.
Sometimes this problem happens when there is a 32-bit/64-bit mismatch.
Can you please confirm your setup?
You said it was Data Studio 3.1.1 admin client and 64-bit DB2 both on the same machine running RHEL? Is this correct?
I am curious about the LD_LIBRARY_PATH. What was the reason for setting it this way? Do you get the same error message if you don't set it?
Is your set up the same as Dale's? If different, can you please describe it too?
I am especially curious to learn if Data Studio and DB2 are on the same machine, their versions, and if they are both installed either as 32-bit or 64-bit.
DaleMorgan 110000D9WW2 PostsACCEPTED ANSWER
Re: Can't Create Database - Connectivity Libraries Not Found2013-02-14T00:57:08Z in response to firstname.lastname@example.orgHi Sal, I gave up and installed under Windows and everything's working fine there. But yes, it was 3.1.1 admin client and 64-bit DB2 on the same machine running RHEL.
I don't remember why LD_LIBRARY_PATH was set the way it was. I think I tried several variations without success, and I got the same error every time. How should it be set?
SystemAdmin 110000D4XK1632 PostsACCEPTED ANSWER
Re: Can't Create Database - Connectivity Libraries Not Found2013-02-14T15:28:48Z in response to email@example.comHi Sal,
yes - I've exactly the same environment than Dale (RHEL x86 64Bit, Data Studio 3.1.1 admin client, db2 V10.1 x86 64Bit).
Just let me add two additional things:
.) I can start/stop/create/delete DB2-instances and databases from the db2-console without any problem and ...
.) If I've started the db2-instance from the db2-console it's possible to connect/disconnect databases by the DataStudios 'Administration-Explorer'-perspective also. But it's NOT possible to start/stop the instance or to create/remove a new database. This results in the error-message described above ("The connectivity libraries that are needed for local or remote ... snip ")
Re: Can't Create Database - Connectivity Libraries Not Found2013-02-14T20:17:14Z in response to SystemAdminHi, thank you both for your response and for trying Data Studio.
I don't believe setting the LD_LIBRARY_PATH is needed since it is usually used to substitute a different or non-standard library. I have reached out to colleagues to verify this and if I hear anything different I will post it here.
I'd like to request some more environmental info from your system and I have several options that you can try. Do you mind emailing me at ledezma at us dot ibm dot com to work through this?
This way we can work through the problem and once solved I will post the solution here so that others may benefit.
If this is ok, let's start with the following:
Can you please send me the DB2 fix pack level you are on? You can do this by issuing the command "db2level" on the CLP.
Also, are you using a standard port for SSH on your Linux machine?
Re: Can't Create Database - Connectivity Libraries Not Found2013-02-23T01:55:03Z in response to firstname.lastname@example.orgHi,
I wanted to come back to this topic to provide some results.
After discussing more with Andreas offline, he was able to determine that ssh was not running on his system. The admin client attempts to communicate with DB2 using ssh when executing non-JDBC commands. Since it was not enabled, these commands were failing.
Once the ssh-daemon was enabled, Andreas was able to execute the commands successfully.
The error message is a little confusing, so I will open a defect in our internal bug tracking system to improve the message for these type of communication failures.
Regarding the LD_LIBRARY_PATH, it looks like DB2 sets this during the DB2 install. Data Studio users should not have to modify this.