-911 Contention problem with DB2 batch jobs on trying to get the next 'Sale ref number'

Richard Atkins

-911 Contention problem with DB2 batch jobs on trying to get the next 'Sale ref number'
Dear listers,

I am sure this problem must have been discussed at some point. I am at my wits end trying to figure out a solution. Any pointers will be graciously accepted.

We have a table that stores the Sale reference number. It is a unique number that gets tagged to every sale we have. (We add 1 to the number everytime). This table gets updated by Online and Batch jobs.

We have batch jobs (1-5 partition) that keep abending with -911. I have looked at the commit frequency and it is low and the contention is between the partition jobs.



Look forward to hearing from you.

Cheers,



Richard





---------------------------------
Yahoo! Shopping
Find Great Deals on Holiday Gifts at Yahoo! Shopping

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm