• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 2

 
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Exceptioncom.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 2. I have a db2 database update statement in java compute node in message broker with which I am getting the above mentioned sql error (due to deadlock). This happened 2 days and I could see that this error is there in the message broker logs but the database logs do not contain any deadlock history. I know that by setting lock flags we can get rid of this issue, but then I want to know what exactly is causing this issue when we dont find any deadlock or timeout error in DB2 log?
 
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There are some pointers for deadlock troubleshooting in db2 using its deadlock event monitor, e.g.:

Finding the needle in the Deadlock haystack

Regards, Jan
 
reply
    Bookmark Topic Watch Topic
  • New Topic