Connecting to DB2(v 9.1) database server from Datastage

[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.

[ray.wurlod]

The solution is to prevent it (the error), by not providing an invalid argument (property) value for connecting to DB2.

[sarat.srinivas@tcs.com]

Hi,
The Server name ,Username and Password have been passed correctly. Is there any other property of this stage which has to be considered so as to avoid this error ?

[ray.wurlod]

Remote Server ?