473,396 Members | 1,989 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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.JobPersistenceException: 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.
Feb 7 '07 #1
1 21249
premit
1
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.JobPersistenceException: 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
Mar 1 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Tborn2b | last post by:
DB2 V 7, Z/OS: I receive an SQLCODE -104 for the following trigger : CREATE TRIGGER TRSERED1 NO CASCADE BEFORE INSERT ON SEMINAR REFERENCING NEW AS ZUGANG
5
by: Jean-Marc Blaise | last post by:
Dear all, Could you explain why some SQL messages do not possess a SQLSTATE ? Why not transmitting the SQLSTATE of the original <sqlcode>, for example if you get a -911 on a RUNSTATS ? ...
3
by: JDPope | last post by:
I have a situation which I cannot get a good lead on how to resolve. One of the applications I support uses the Hibernate software to generate SQL. The app is JAVA with JDBC. In testing the users...
15
by: Twan Kennis | last post by:
Hi, I have a DB2 database on the IBM iSeries platform, on which I created several Stored Procedures with the SQLCODE as a return-parameter. These Stored Procedures are called from a Windows...
2
by: Richard | last post by:
Our web programmer was looking in his application log an found the following error: 2006-08-31 16:33:35,129 ERROR org.hibernate.util.JDBCExceptionReporter - < SQL0723N An error occurred in a...
5
by: misterutterbag | last post by:
Stack trace below. Only happens in WebSphere 6.0. DB2 v 8.2. FP12. Only against 1 database. I have other databases in this database instance, but they don't seem to have this problem. ...
10
by: scoonie999 | last post by:
I'm having a problem that I can't seem to find any solution for online. I'm using a cursor in a cobol program to fetch some data. I know for a fact that the select should return 2 rows. The...
1
by: amarhegde | last post by:
When u perform the SELECT operation, Sometimes u get this error Code java.rmi.RemoteException: ; nested exception is: javax.ejb.EJBException: nested exception is: ...
22
by: Sri | last post by:
All Recenetly our shop migrated to DB2 V8 from V7. We are in IBM System Level: z/OS 1.6.1 @ RSU 0702. Processor : IBM 2064-1C7 (z/900) # 1B89 Mode: 64-bit One of my application is facing...
3
by: lenygold via DBMonster.com | last post by:
Thank you very much SERGE for your help. I found example in Graeme Birchall COOKBOOK wich i think exactly what i need for SQL check in triggers: • User query joins to table function - sends...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.