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

Walter Janißen

-911 Contention problem with DB2 batch jobs on trying to get the next 'Sale ref number'
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