Page 1 of 1

DB2 EE stage Error

Posted: Mon Jun 18, 2007 3:37 pm
by DSkkk
Hi ..

We recently upgraded the Datastage from 7.1 to 7.5.2

We r working on verifying whether the DB2 EE stage functioning properly or not.. When i run a Job to Either read from a Table or Update a Table i get the following errors:

##W TFPA 000015 16:21:41(000) <node_ccsidbu1> Warning: unable to chdir(/opt/etl/Ascential/DataStage/Projects/Inbound): No such file or directory
>##F TFPM 000303 16:21:41(000) <node_ccsidbu1> Fatal Error: broadcastStepIR: score load from /tmp/APTps1241122a88ac5c1 on node ccsidbu1 failed; exit status 65,280
>##E TFPM 000330 16:33:52(000) <main_program> The Section Leader on node ccsidbu1 has terminated unexpectedly.
>##F TFPM 000114 16:36:28(000) <APT_CombinedOperatorController,0> Fatal Error: Unable to start ORCHESTRATE network connection on node node1 (edmas1t): APT_PMConnectionSetup:: operator 1(sequential APT_CombinedOperatorController)timed out with 1 incomplete incoming connections.
>##E TFPM 000192 16:36:28(000) <node_node1> Player 1 terminated unexpectedly.
>##E TFPM 000338 16:36:28(000) <main_program> Unexpected exit status 1
##W TFPM 000091 16:36:33(000) <main_program> APT_PMpollUntilZero: WARNING: called with counter = 0
>##E TFSR 000011 16:36:38(000) <main_program> Step execution finished with status = FAILED.
##I TCOS 000026 16:36:38(001) <main_program> Startup time, 2:49; production run time, 0:00.



I verified that the rsh connections between the DB server and the DS Application server are up and running.
The Directory /opt/etl/Ascential/DataStage/Projects/Inbound actually exists as a non DB2 Stage job works fine.

Please guide me thru this if any one has encountered similar issue.

Thanks.
Kalyan

Posted: Mon Jun 18, 2007 7:18 pm
by ray.wurlod
You might also try searching for, or asking support about, exit status 256 (which is 65536 - 65280).

Set APT_STARTUP_STATUS environment variable so that you can watch distribution of the score. It is this procedure that is failing to complete successfully.