Connecting to Remote DB2 V9

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
attu
Participant
Posts: 225
Joined: Sat Oct 23, 2004 8:45 pm
Location: Texas

Connecting to Remote DB2 V9

Post by attu »

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
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
attu
Participant
Posts: 225
Joined: Sat Oct 23, 2004 8:45 pm
Location: Texas

Post by attu »

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?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
attu
Participant
Posts: 225
Joined: Sat Oct 23, 2004 8:45 pm
Location: Texas

Post by attu »

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