Db2 Sql Error Code 913
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more ibm db2 sql error code about Stack Overflow the company Business Learn more about hiring developers or posting ads
Db2 Sql Error Code 805
with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow
Db2 Sql Error Code 404
is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up What is the difference between DB2 sql codes -913 and -904 with
Db2 Sql Error Code 104
an example? [closed] up vote -3 down vote favorite What is the difference between DB2 sql codes -913 and -904 with an example? db2 share|improve this question edited Jun 25 '13 at 14:09 Leons 1,186918 asked Jun 25 '13 at 12:50 Rahul khandelwal 112 closed as too broad by Andrew Barber Sep 4 '13 at 20:56 There are either too many possible answers, or good answers would be too long db2 sql error code 803 for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question. add a comment| 2 Answers 2 active oldest votes up vote 2 down vote An SQL code of -913 is UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name An SQL code of -904 is UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name A -913 is a deadlock, or two programs trying to get the same resource. The classic example is program 1 updating table B, then A; and program 2 updating table A, then B. Neither program can get to the second resource, so you have a deadlock. To prevent this, all of your programs must modify DB2 tables in the same order (A, then B). A -904 is an unavailable resource. A dropped table or a locked table. Both errors give you the name of the deadlocked resource or the unavailable resource. share|improve this answer answered Jun 25 '13 at 13:19 Gilbert Le Blanc 34.1k532
Samples & SAS Notes Focus Areas SUPPORT License Assistance Manage My Software Account Downloads & Hot Fixes TRAINING & BOOKS Books Training Certification SAS Global Academic db2 sql error code 811 Program SAS OnDemand For Academics USERS GROUPS Advanced Search support.sas.com Knowledge db2 sql error code 204 Base Support Training & Books Store Support Communities Knowledge Base Products & Solutions System Requirements Install db2 sql error code 206 Center Third-Party Software Reference Documentation Papers Samples & SAS Notes Browse by Topic Search Samples Search Usage Notes Search Installation Notes Search Problem Notes Focus Areas Problem Note http://stackoverflow.com/questions/17297845/what-is-the-difference-between-db2-sql-codes-913-and-904-with-an-example 50803: The occurrence of a -913 error from DB2 might not stop subsequent steps from processing Subsequent steps might still be executed when you are running a query in a z/OS operating environment when the following conditions exist: The DB2 query results in a deadlock and a -913 error is issued. The system option DB2RRS is specified. http://support.sas.com/kb/50803 In addition, to the job continuing to process, the job return code might still be 0. The DB2 error might look similar to the following: DB2 ERROR: RESULT OF SQL STATEMENT: DSN00913E UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE 00C9008E, TYPE OF RESOURCE 00000D01, AND RESOURCE NAME 00000285.00013904 A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS: ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 13172878 SQLCODE: -913 SQLSTATE: 57033 SQLERRP: DSNXRUP2 There is no workaround for this issue other than not using the system option DB2RRS. Operating System and Release InformationProduct FamilyProductSystemSAS ReleaseReportedFixed*SAS SystemSAS/ACCESS Interface to DB2z/OS9.2 TS2M3* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed. A fix for this issue for SAS/ACCESS Interface to DB2 9.3_M2 is available at:http://ftp.sas.com/techsup/download/hotfix/HF2/J41.html#50803 Type:Problem NotePriority:highDate Modified:2013-09-16 09:28:34Date Created:2013-08-19 17:12:10 This content is presented in an iframe, which your browser does not support. To view the RateIT tab, click here.
the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To http://www.dbforums.com/showthread.php?1697927-SQLerror-code-913 start viewing messages, select the forum that you want to visit from the http://www.geekinterview.com/question_details/33960 selection below. Results 1 to 3 of 3 Thread: SQLerror code -913 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 11-06-13,05:20 #1 venkat1436 View Profile View Forum Posts Registered User Join Date db2 sql Nov 2013 Posts 2 Unanswered: SQLerror code -913 Hi All, After migration from neon driver to jdbc driver we are getting time out exception "SEVERE: DB2 SQL Error: SQLCODE=-913, SQLSTATE=57033, SQLERRMC=00C9008E;00000302;BBBD02P .BBBS0287.X'000012', DRIVER=3.52.95 com.ibm.db2.jcc.a.SqlException: DB2 SQL Error: SQLCODE=-913, SQLSTATE=57033, SQLERRMC=00C9008E;00000302;BBBD02P .BBBS0287.X'000012', DRIVER=3.52.95 at com.ibm.db2.jcc.a.ad.a(ad.java:669) at com.ibm.db2.jcc.a.ad.a(ad.java:60) at com.ibm.db2.jcc.a.ad.a(ad.java:127) at com.ibm.db2.jcc.a.rl.c(rl.java:2424) at com.ibm.db2.jcc.a.rl.a(rl.java:1929) at com.ibm.db2.jcc.t4.db.n(db.java:739) at com.ibm.db2.jcc.t4.db.i(db.java:257) at com.ibm.db2.jcc.t4.db.c(db.java:52) at com.ibm.db2.jcc.t4.t.c(t.java:44) at com.ibm.db2.jcc.t4.sb.i(sb.java:153) at db2 sql error com.ibm.db2.jcc.a.rl.ab(rl.java:1924) at com.ibm.db2.jcc.a.sl.e(sl.java:3286) at com.ibm.db2.jcc.a.sl.Ob(sl.java:569)" Why this causing please help me here before we never got such kind of exception. Thanks in Advance Reply With Quote 11-06-13,08:12 #2 przytula_guy View Profile View Forum Posts Visit Homepage Registered User Join Date Apr 2006 Location Belgium Posts 2,514 Provided Answers: 11 message is very clear : SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason code "
Management Accounting Operating System Operating System Android iOS Microsoft Coding Programming J2EE Languages Database Database Data Warehousing Oracle Applications Applications Clarify CRM Oracle Apps Peoplesoft Siebel Software Testing Testing Testing Tools Miscelleanous Helpdesk Mainframe Networking SAP R/3 Web Interview Coaching Career Counseling Job Interview Interview eBooks Accounting eBook C eBook Citrix eBook Job Interview eBook Career Advice Career Change Jobs Help Projects Requests Resume Help Training Advice Engineering Chemical Engineering Civil Engineering Electrical Engineering Electronics Engineering Micro Processor Mechanical Engineering By Company Ask Question Home Interview QuestionsMainframeDB2 What is difference between 911 and 913 error code in DB2 ? Interview Candidate Sep 1st, 2006 4 20873 DB2 Answer First Prev Next Last Showing Answers 1 - 4 of 4 Answers Sam Sep 8th, 2006 The unit of work has been rolled back due to dead lock or commit-----SQL code 911 Was this answer useful?Yes Reply jayakumar Sep 10th, 2006 ABEND -911:A deadlock has occured and the rollback is done sucessfullyABEND -913A deadlock has occured ,but the rollback was unsucessfulcheers,jai Was this answer useful?Yes 1 Reply bnirmalraj Sep 26th, 2006 911 - THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name913-UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON reason-code, TYPE OF RESOURCE resource-type, ANDRESOURCE NAME resource-name
Was this answer useful?Yes Reply sangramkc Nov 27th, 2006 for both -911 or -913 , you can check further SQLERRD(3) also contains the reason-code which indicates whether a deadlock or timeout occurred. The most common reason codes are: o 00C90088 - deadlock o 00C9008E - timeout Thanks,SangramOm jai sai ram Was this answer useful?Yes Reply Give your answer: If you think the above answer is not correct, Please select a reason and add your answer below. - Reason - Answer is wrong Spelling Mistakes Duplicate Answer Inappropriate Answer Other Answer Question Click here to Login / Register your free account Name: Email: Answer: Inser