Connecting to DB2(v 9.1) database server from Datastage

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
sarat.srinivas@tcs.com
Participant
Posts: 26
Joined: Fri Jul 13, 2007 6:33 am

Connecting to DB2(v 9.1) database server from Datastage

Post by sarat.srinivas@tcs.com »

Hello,
We are trying to connect to the DB2(v 9.1) database which is on a Windows xpProfessional system, from Datastage(7.5.x2) which is on another system which is a windows 2003 Server, using a parallel job.In the job we are we are giving a simple .csv input file with a couple of columns as the input to seq.file, where the data is passed to a trasformer and then to the DB2/UDB API stage.
We are observing the following errors for the above mentioed job:

>>Event type:Fatal
Message:
APT_CombinedOperatorController,0: Failure during execution of operator logic.
>>Event type:Fatal
Message:
APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009
Unable to connect to DB2 server '172.19.52.161'.
>>Event type:Fatal
Message:
node_node1: Player 1 terminated unexpectedly.
>>Event type:Fatal
Message:
main_program: Unexpected exit status 1
>>Event type:Fatal
Message:
main_program: Step execution finished with status = FAILED.

Pls provide us solution for this problem.
V.Sarat Srinivas
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Personal Note
I do not even consider answering questions posted in the incorrect forum by experienced posters (in which I include employees of consulting firms).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply