Deadlock because of 2 DB2 stages
Posted: Mon May 12, 2008 1:03 pm
Hi,
In one of our job we have two DB2 stages as target. Both these DB2 stages have SQL statement on the same table. On certain occasion when we run the job, the job gets aborted giving a deadlock error. And on most occasions when we re-run it, it completes successfully.
The error message that we get is,
Fatal Error: Fatal: [IBM][CLI Driver][DB2] SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason code "00C9008E". SQLSTATE=57033
Is there a way to avoid this deadlock? Can we make it so that the first output link from the transformer completes fully and then the processing takes place for second output link?
Thanks.
In one of our job we have two DB2 stages as target. Both these DB2 stages have SQL statement on the same table. On certain occasion when we run the job, the job gets aborted giving a deadlock error. And on most occasions when we re-run it, it completes successfully.
The error message that we get is,
Fatal Error: Fatal: [IBM][CLI Driver][DB2] SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason code "00C9008E". SQLSTATE=57033
Is there a way to avoid this deadlock? Can we make it so that the first output link from the transformer completes fully and then the processing takes place for second output link?
Thanks.