SQLState: 40001 ROLLBACK DUE TO DEADLOCK/TIMEOUT; REASON 68 - db2-udb
This is a discussion on SQLState: 40001 ROLLBACK DUE TO DEADLOCK/TIMEOUT; REASON 68 - db2-udb ; Our J2EE Application will do batch inserts in DB2. Database server = DB2/SUN64 8.2.4 recently we are getting Exceptions net.sf.hibernate.util.JDBCExceptionReporter.logExc eptions(JDBCExceptionReporter.java:58)] ERROR - [BEA][DB2 JDBC Driver][DB2]Abnormal end unit of work condition occurred. net.sf.hibernate.util.JDBCExceptionReporter.logExc eptions(JDBCExceptionReporter.java:57)] WARN - SQL Error: -911, SQLState: ...
![]() |
| | LinkBack | Thread Tools | Display Modes |
|
#1
| |||
| |||
| Database server = DB2/SUN64 8.2.4 recently we are getting Exceptions net.sf.hibernate.util.JDBCExceptionReporter.logExc eptions(JDBCExceptionReporter.java:58)] ERROR - [BEA][DB2 JDBC Driver][DB2]Abnormal end unit of work condition occurred. net.sf.hibernate.util.JDBCExceptionReporter.logExc eptions(JDBCExceptionReporter.java:57)] WARN - SQL Error: -911, SQLState: 40001 [net.sf.hibernate.util.JDBCExceptionReporter.logExc eptions(JDBCExceptionReporter.java:58)] ERROR - [BEA][DB2 JDBC Driver][DB2]ROLLBACK DUE TO DEADLOCK/TIMEOUT; REASON 68 We tried a lot to replicate the error in Our Dev environments . but we could not able to do... It seems issue is with DB configurations. And what we observed is ....when we query the data from table , at sametime bacth inserts are happeing on that table, we are getting exceptions. This table has 900K rows have one column with CLOB(50080) Is there anything todo with Tablespace and Bufferpool configurations? Can someone pls advise me if u have idea? Thanks. |
![]() |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
| |
All times are GMT -4. The time now is 09:23 PM.




Linear Mode