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
Connecting to Remote DB2 V9
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.