-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'
Hello Walter,

Thanks for replying.The commit frequency is 10 records. We commit after every 10 record and we are on DB2 Ver 7.x.

The table has a row that stores a max. value (e.g 45678234) that has to be read by each partition job and updated to by adding + 1 (e.g. 45678235).

This row has Row level locking defined on table. I am not sure about IDENTITY column
How can an IDENTITY column resolve -911

Cheers
Richard

Walter Janißen <[login to unmask email]> wrote:
What do you mean with 'low'? I think in your case, the commit frequency
must be 1 to avoid deadlocks or timeouts.

Which DB2-version are you running? Since V6 there is the option of IDENTITY-
columns, where -911 does not occur or if you are at V8 then you could use
SEQUENCE. In this case, you need not alter your table definition, but you
have to change your program logic (same holds for IDENTITY).

---------------------------------------------------------------------------------
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




---------------------------------
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