Db2 Sql Error Sqlcode=-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
Db2 Sql Error Sqlcode 305
of this site About Us Learn more about Stack Overflow the company db2 sql error sqlcode 440 sqlstate 42884 stored procedure Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges db2 sql error sqlcode 804 Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n913.html Sign up Timeout updating DB2 table up vote 3 down vote favorite 1 I am doing an update to a DB2 table like this (java code): // Some code ripped out for brevity... sql.append("UPDATE " + TABLE_THREADS + " "); sql.append("SET STATUS = ? "); sql.append("WHERE ID = ?"); conn = getConn(); pstmt = conn.prepareStatement(sql.toString()); int idx1 = 0; pstmt.setInt(++idx1, status); pstmt.setInt(++idx1, http://stackoverflow.com/questions/16530919/timeout-updating-db2-table id); int rowsUpdated = pstmt.executeUpdate(); return rowsUpdated; After a long while, I get a rollback and an error message: UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE 00C9008E, TYPE OF RESOURCE 00000302, AND RESOURCE NAME SOME.THING.X'000002'. SQLCODE=-913, SQLSTATE=57033, DRIVER=3.57.82 The documentation for error -913 says this REASON CODE means it is a timeout. The resource type, 00000302 is a table space page, and I do not recognize the resource name at all. When I run the SQL by itself, it works fine: UPDATE MY.THREADS SET STATUS = 1 WHERE ID = 156 I can SELECT and see the status has been updated. (Although when I run this SQL during the long wait period before the timeout, I have the same issue. It takes forever and I just cancel it). There are several things happening in the transaction and I don't see any other updates to this table or record. There are create/delete triggers on the table, but no update triggers. I don't see any selects with cursors, or weird isolation level changes. I don't see much else in the transaction that would cause th
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 about Stack Overflow http://stackoverflow.com/questions/17297845/what-is-the-difference-between-db2-sql-codes-913-and-904-with-an-example the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of https://www.experts-exchange.com/questions/28694190/DB3-913-err-can-anyone-plz-help-to-solve-this-issue.html 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 an example? [closed] up vote -3 db2 sql 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 for this format. Please add details to narrow db2 sql error 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.1k53272 add a comment| up vote 0 down vote -913 is SQL0913N Unsuccessful execution caused by de
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > DB3-913 err can anyone plz help to solve this issue Want to Advertise Here? Solved DB3-913 err can anyone plz help to solve this issue Posted on 2015-07-01 DB2 Java 1 Verified Solution 3 Comments 114 Views Last Modified: 2016-05-23 DB2-error.txtJun 19 2015 01:51:27 80244162 ERROR [WebContainer : 1] - Error writing XML to ODB in VendorInterfaceRequestManager.loadBeans(HttpServletRequest):com.metlife.mars.marsexception.MarsException: DB2 SQL error: SQLCODE: -913, SQLSTATE: 57033, SQLERRMC: 00C90088;00000302;H2571POD.SOD#ACXL.X'014685' com.ibm.db2.jcc.b.SqlException caught in TOD_ACTY_XML_DS.insert() Activity ID = [562664584799237429] Business ObjectID = [] LOB = [] Policy Number = [] Suffix = [] Exception Message = [DB2 SQL error: SQLCODE: -913, SQLSTATE: 57033, SQLERRMC: 00C90088;00000302;H2571POD.SOD#ACXL.X'014685'] in class com.metlife.autoandhome.entity.dataservice.TOD_ACTY_XML_DS in method insert 0 Question by:punith410 Facebook Twitter LinkedIn Google LVL 45 Active 1 day ago Best Solution byKdo Hi punith, State 57033 is a deadlock or timeout without automatic rollback. Some other application has a lock on an item that this application is trying to access. DB2 waits for the lock to clear, Go to Solution 1 Comment LVL 45 Overall: Level 45 DB2 30 Java 3 Message Active 1 day ago Accepted Solution by:Kdo2015-07-02 Hi punith, State 57033 is a deadlock or timeout without automatic rollback. Some other application has a lock on an item that this application is trying to access. DB2 waits for the lock to clear, but it doesn't so DB2 aborts the application when the timeout period expires. You can create an event monitor and track deadlocks, but that will only identif