Hi,

I have a java program which spawn n threads inserting rows into the same table. I got the following exception:

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001

I issued the following command and reboot the system but can't solve the problem:
db2set DB2_RR_TO_RS=YES -g

Can anyone help me? Thanks a lot!

How offen are you writing "commits" in these transactions?

The program spawn 2 threads each insert 2500 rows then commit. One thread fails with error described above, and the other thread completes successfully.

The program can be run with Oracle very well.

You can try to increase your LOCKTIMEOUT parameter (be carefull with side effects on another applications), commit more frequently or both.
The lock implementation in Oracle and in DB2 is different. While Oracle makes a copy from the "old" entity (redo log) and allows others to access the data, DB2 sets a x-lock by INSERTS, UPDATES and DELETES and gets exclusive control over the data.
HTH

Thank you RKrick.

My current setting of LOCKTIMEOUT is -1, means I don't have such setting.
Also, I tried to increase another parameter DLCHKTIME buy no use.