Parallel Job not terminating

[JaisonJ]

JOB Details

This job reads table A using DB2 connector,with the rows read (2000 rows) it lookup another tableb B to fetch the key value from table B and then these rows along with the keys are appended to another table C using db2 connector.

From the log of the job, it was found that around 900 rows are appended to the table C from node 0 and there were no rejects and keeps on running to append next 1100 rows from node 1.

We are using 2 nodes for processing.

No other error is detected from the log.

This jobs is in production and was successfully (Finshed OK) running yesterday since it was put into production on Dec 20, 2012. Today only this issue happend

Could you please let me know what would be reason ??

[ray.wurlod]

Welcome aboard.

Have your DBA look at the DB2 logs, etc., to try to figure out what the delay might be.