DB2 EE stage Error

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
DSkkk
Charter Member
Charter Member
Posts: 70
Joined: Fri Nov 05, 2004 1:10 pm

DB2 EE stage Error

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

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