Page 1 of 1
Idea to resolve database table lock after job abort?
Posted: Thu Feb 25, 2010 12:21 am
by MT
Hi,
I have a DS job upserting into a DB2 table. When the job aborts the table is locked by DS. Any idea how I could solve it WITHIN DS and WITHOUT having the dba forcing the connection?
Thanks in advance
globomike
Posted: Thu Feb 25, 2010 1:02 am
by ray.wurlod
Transaction size = 1.
Posted: Fri Feb 26, 2010 3:34 am
by MT
Hi Ray
ray.wurlod wrote:Transaction size = 1.
well this is a good idea but this has a performance impact on every run.
Any additional ideas to kind of reset it via DataStage which I could do only when a error had happened (hopefully rarely)
Thanks
globomike
Posted: Fri Feb 26, 2010 5:25 am
by ray.wurlod
If you're running the job from a sequence, use "reset if required, then run".
Posted: Fri Feb 26, 2010 5:35 am
by MT
Hi Ray
ray.wurlod wrote:If you're running the job from a sequence, use "reset if required, then run".
well I tried to see if a job reset can release the table lock after the job was aborted but it did not work.
I think this would be the same from within a sequence, wouldn't it?
regards
globomike
Posted: Fri Feb 26, 2010 5:38 am
by ray.wurlod
I assumed you'd released the lock from within the database. DataStage doesn't have any way natively to do this, but you could issue the relevant DDL statement in a Before SQL command of a stage in a job that does nothing else.