Communication error between DataStage Server and Client

[yaminids]

Hello friends,

We are having issues with a job which selects data from 10 source tables and populates 10 staging tables. There are two other jobs, executed sequentially, which populate the same staging tables

The design of the job is simple
ODBC ==>TRANSFORMER==>ODBC
which is repeated 10 times

Once in a while the job runs for hours without ever returning a completion code. When I login into Designer all the stages are done extracting the data (all the links turn green) but its status show as running in Director.

The following are the processes on the server during this situation

dstage 14638 29128 0 Oct07 ? 00:00:00 /opt/ESPSystemAgent/cybspawn.bin 6 /opt/ESPSystemAgent 20081007
dstage 14639 14638 0 Oct07 ? 00:00:00 /bin/ksh /usr/Ascential/DataStage/Projects/CUSTREL/shellscripts/CUSTPREFER.sh daily 2
dstage 14707 14639 0 Oct07 ? 00:00:00 /usr/Ascential/DataStage/DSEngine/bin/dsjob -server localhost -user dstage -password xxxxxx -run -wait -war
n 10 -jobstatus -param pRunId 2 CUSTREL CUSTPREFERSeq
dstage 14708 480 0 Oct07 ? 00:00:00 dscs 4 0 0
dstage 14709 14708 0 Oct07 ? 00:00:01 dsapi_slave 8 7 0
dstage 14710 14709 0 Oct07 ? 00:00:02 phantom DSD.RUN CUSTPREFERSeq. 0/10/0/0/0
dstage 14715 14710 98 Oct07 ? 06:27:59 phantom DSD.RUN CUSTDEF_DAILY_On. 0/10/1/0/0
dstage 14721 14715 0 Oct07 ? 00:00:00 [uvsh <defunct>]
dstage 14722 14715 0 Oct07 ? 00:00:00 [uvsh <defunct>]
dstage 14723 14715 0 Oct07 ? 00:00:00 [uvsh <defunct>]
dstage 14724 14715 0 Oct07 ? 00:00:00 [uvsh <defunct>]
dstage 14726 14715 0 Oct07 ? 00:00:00 [uvsh <defunct>]
dstage 14738 14715 0 Oct07 ? 00:00:00 [uvsh <defunct>]

Did anyone face this issue before?

Thanks a bunch in advance
Yamini

[ray.wurlod]

Did you Search?