DSXchange

The Database (DB2) we are trying to access is not local or catalogued, it is a remote database.
We are trying to connect through Data Direct drivers using the ODBC Stage.
When I am doing the debugging using example I get this error message.

SQLSTATE = S1000
NATIVE ERROR = -552
MSG = DataDirectODBC DB2 Wire Protocol driver DB2 KEATON1 DOES NOT HAVE PRIVILEGE TO PERFORM OPERATION BIND

We are trying to connect to 64 bit DB2 Database (V9), but DataStage is 32 bit Application.

How can this be acheived.

Thanks

First thing first, you must do the tcp, db catalog, and bind. Even after you have done that, I am not sure that you can communicate with 64-bit DB2 DB from DS. Check with IBM support.

As long as you have 32-bit drivers/client you should be fine.

chulett wrote:As long as you have 32-bit drivers/client you should be fine. ...

Thanks for the reply guys. Just wondering how can we know which driver is 32 bit and which is 64 bit.

Is there a command for it?

These days the 32-bit drivers tend to be in a directory called lib32 while the 64-bit drivers tend to be in the lib directory. Make sure that lib32 occurs before lib in your shared library search list, at least for DataStage processes.

We have asked the DBA to to run a bind20 and newly created plan be granted public.