UDB API stage deadlock or timeout Reason code SQLSTATE=57033
Posted: Mon Mar 02, 2009 11:52 pm
Hi All....
I have one multi instance parallel job which uses DB2 UDB API stage to insert in to one table. This job is having a before sql to delete the records based on the where clause.
This job is run with parameter values so that for one run it will delete a specified set of records and insert the new records for that category.
this job is ran with two set of parameters for mulually exclussive categories of records. If we run the job with each of this parameters , sequentially the job goes fine(means one job at a time).But we are getting deadlock or timeout issue if we run this job for both of the cateories of records at the same time.
We tried with the execution mode for the API stage as parallel and sequential . Both the time we got the same issue. This issue we can solve by scheduling so that one set of job should run only after the other. But is there any other way from Datastage to solve this issue?
Thanks in Advance.
I have one multi instance parallel job which uses DB2 UDB API stage to insert in to one table. This job is having a before sql to delete the records based on the where clause.
This job is run with parameter values so that for one run it will delete a specified set of records and insert the new records for that category.
this job is ran with two set of parameters for mulually exclussive categories of records. If we run the job with each of this parameters , sequentially the job goes fine(means one job at a time).But we are getting deadlock or timeout issue if we run this job for both of the cateories of records at the same time.
We tried with the execution mode for the API stage as parallel and sequential . Both the time we got the same issue. This issue we can solve by scheduling so that one set of job should run only after the other. But is there any other way from Datastage to solve this issue?
Thanks in Advance.