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