MVSFORUMS.com

MarriedVirtuallySingle · Beginner Joined: 26 Oct 2005 Posts: 2 Topics: 1

Here's the scenario:

I need to create four (4) jobs that would read and update the same DB2 table to run concurrently. It is originally just one job, but due to time-constraints, we need to do the processing in limited time, thus, the jobs was split into 4 same jobs. We created corresponding rows for each jobs in GEN table for both tables, with the assumption that this job will not content as they will be accessing their own row in GEN table.

But still we ended with contention errors - DEADLOCK!!

How could we tackle this scenario? We already brought this up to our DBAs but all they've said is run the jobs sequentially.

Do we need to modify LOCKSIZE? or use is there any options we could use to make this feasible? Or we are hopeless...

Pls help.

kolusu · Posted: Wed Oct 26, 2005 4:10 am Post subject:

MarriedVirtuallySingle,

First of all let me remind you that you are not on a online dating website. Remember that this is a professional website. Your ID/Nick is no good on this website. Plese register with a different nick.

Secondly do not use "thanks in advance" in the post. Here also you took it to the extreme of putting it in the title which instantly puts off any one trying to help you.

You will not get an answer if you do such things on this site.

Thanks

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

MarriedVirtuallySingle · Beginner Joined: 26 Oct 2005 Posts: 2 Topics: 1

kolusu,

I know very well that this ain't a dating service. Though my chosen nick ain't suitable to your taste, MarriedVirtuallySingle is from a joke for what MVS stands for.

For what it's worth, do accept my apologies. I have registered a new nick.

regards,
MVS.