I tried to execute my script via command line process run method on data studio because I need to manage my transaction by myself.
But I face the error "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."
I already install DB2 database server on my machine.The DB2 Administration Server is already active too.
PS. I can use db2clp normally.
How can I solve this issue
This topic has been locked.
1 reply Latest Post - 2013-02-13T21:29:38Z by email@example.com
Pinned topic Problem about command line processor run method
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-13T21:29:38Z at 2013-02-13T21:29:38Z by firstname.lastname@example.org
email@example.com 0600001C2E23 PostsACCEPTED ANSWER
Re: Problem about command line processor run method2013-02-13T21:29:38Z in response to SystemAdminHi,
In case you are still looking for an answer to this, sometimes this problem happens when there is a 32-bit/64-bit mismatch.
Can you please describe your setup?
What is the operating system where Data Studio is installed?
What version of Data Studio did you install? If it is v3.2, did you install the 32-bit or 64-bit version?
For the database that you are trying to execute a script against, what operating system is it installed on?
Is it on the same machine as your Data Studio install? Based on your description, this looks to be the case, but I would like to confirm.
Is DB2 installed as 32-bit or 64-bit?
This is probably a good starting point. I can try to help you solve your problem based on your configuration.
In general, as Loic has pointed out in a different post (http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14936352), Data Studio supports the following when DB2 is installed on the same machine and the operating system is Windows:
(1) 32-bit Data Studio --> we leverage DAS (db2admin start) --> 32 bit DB2: Working configuration
(2) 32-bit Data Studio --> we leverage DAS (db2admin start) --> 64 bit DB2: Working configuration
(3) 64-bit Data Studio --> we leverage DAS (db2admin start) --> 64-bit DB2: Working configuration
(4) 64-bit Data Studio --> we leverage DAS (db2admin start) --> 32-bit DB2: Not a working configuration since DB2 will not have the corresponding 64-bit libraries.
Usually, it is case (4) that issues the error message you saw:
"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.".