Resolving SQLCODE -911 in IBM DB2

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • amarhegde
    New Member
    • Feb 2007
    • 2

    Resolving SQLCODE -911 in IBM DB2

    Hi ,
    This error is got in the logs
    ErrorLogger E org.quartz.core .ErrorLogger schedulerError An error occured
    while scanning for the next trigger to fire.
    org.quartz.JobP ersistenceExcep tion: Couldn't
    acquire next trigger: DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 2


    On going through few DB2 sites i was able to find that SQLSTATE: 40001 is got when we have an deadlock situation. But i was not able to find the SQLCODE matching to the one we get in our logs. Some one please explain as to what this code means and is it interrelated to deadlocks. This happens during finding the next trigger to fire using quartz job scheduler.
  • premit
    New Member
    • Mar 2007
    • 1

    #2
    Originally posted by amarhegde
    Hi ,
    This error is got in the logs
    ErrorLogger E org.quartz.core .ErrorLogger schedulerError An error occured
    while scanning for the next trigger to fire.
    org.quartz.JobP ersistenceExcep tion: Couldn't
    acquire next trigger: DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 2


    On going through few DB2 sites i was able to find that SQLSTATE: 40001 is got when we have an deadlock situation. But i was not able to find the SQLCODE matching to the one we get in our logs. Some one please explain as to what this code means and is it interrelated to deadlocks. This happens during finding the next trigger to fire using quartz job scheduler.

    Hi Amar,
    I am getting the same exception while working with Weblogic8.1, DB2 and Quartz. If you have solved the problem, please post the solution here.

    Thanks..
    Premit

    Comment

    Working...