Parallel Job not terminating
Posted: Thu Feb 14, 2013 12:59 am
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 ??
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 ??