dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

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: ...


Home > Database Forum > Other Databases > db2-udb > SQLState: 40001 ROLLBACK DUE TO DEADLOCK/TIMEOUT; REASON 68

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 11-11-2008, 10:25 AM
Database Newbie
 
Join Date: Nov 2008
Posts: 3
rodex2mail is on a distinguished road
Question SQLState: 40001 ROLLBACK DUE TO DEADLOCK/TIMEOUT; REASON 68

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: 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.
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 09:23 PM.