Thursday, October 27, 2011

Reason code "2". SQLSTATE=40001

SQL0911N The current transaction has been rolled back because of a deadlock or timeout

Main reason for this error will be deadlock time out properties. To view this property value issue the following command:

Display Database Manager Configuration Settings:
db2 get dbm cfg

Display Database level Configuration Settings
db2 get db cfg for <DatabaseName>

If dead lock time out value is -1 then change to either 60 or 120 sec based on your DB transaction.

update db cfg for <Databasename> using LOCKTIMEOUT n

n - number of sec.

No comments:

Post a Comment