Db2 Error 913
Contents |
with a mandatory word, e.g. keyword2 keyword1 +keyword2 Questions excluding a reason code 00c9008e sqlstate 57033 word, e.g. keyword2 keyword1 -keyword2 Questions with a specific sqlerrmc=00c9008e tag and keyword(s) +[tag1] keyword1 Questions with two or more specific tags and dsnt376i keyword(s) +[tag1] +[tag2] keyword1 To search for all posts by a user or all posts with a specific tag, start typing and http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n913.html choose from the suggestion list. Tags Spaces API Connect Appsecdev BPM Blockchain Bluemix CICS Cloud Analytics Cloud marketplace Content Services (ECM) Continuous Testing Courses DB2 LUW DataPower Decision Optimization DevOps Services Digital Experience Hadoop IBM Design IIDR ITOA InformationServer Integration Bus Internet of Things https://developer.ibm.com/answers/questions/183297/why-am-i-getting-a-sqlcode-913-sqlstate57033-error.html LinuxONE Mainframe Messaging Node.js ODM Open Predictive Analytics PureData for Analytics Push Run Book Automation Storage Streamsdev Swift UrbanCode WASdev WSRR Watson dW Answers Help dW Premium developerWorks Team Watson Health More Users Badges Ask a question Why am I getting a SQLCODE=-913, SQLSTATE=57033 error-message when executing a WebSphere batch-job? Question by Ayron Fears ( 1822) | Mar 31, 2015 at 07:22 AM waswebsphere application serverwebspherewebsphere batch I am getting SQLCODE=-913, SQLSTATE=57033 error-messages when executing a WebSphere batch-job. The detailed exception stack-trace was: StepManagerIm E com.ibm.ws.gridcontainer.batch.impl.StepManagerImpl executeStep ERROR-->exception during job execution: com.ibm.batch.api.BatchContainerRuntimeException: CWLRB1520E: [Long Running Job Container [Batch Data Stream outputStream] [job
here for a quick overview of the site Help Center Detailed answers to any questions you might have http://stackoverflow.com/questions/16530919/timeout-updating-db2-table Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with http://www.idug.org/p/fo/et/thread=43315 us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, db2 sql just like you, helping each other. Join them; it only takes a minute: 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 = db2 error 913 ? "); sql.append("WHERE ID = ?"); conn = getConn(); pstmt = conn.prepareStatement(sql.toString()); int idx1 = 0; pstmt.setInt(++idx1, status); pstmt.setInt(++idx1, 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 th
Events Forums DB2-LDB2-L ArchivesNA ConferenceEMEA Conference Resources BlogsIDUG eBulletinIDUG NewsroomCommunitiesRegional User Groups Articles&Content IDUG Content ArticlesTech ChannelBeginner's BlogDB2 Hot Topics BlogContent LibraryIDUG YouTubePast Conference ContentCodeplace Library GetInvolved Volunteering with IDUGVolunteer PositionsJoin a Regional User GroupBecome an IDUG MentorSponsorship OpportunitiesJoin a CommunitySpeaker Community process failing -913 steve gear process failing -913 March 19, 2014 03:49 PM hello, we have processes failing with the following. .* MESSAGE 1 : ERROR READING EDI SPLT HEADER TABLE (DB2) * .* MESSAGE 2 : THE FOLLOWING IS THE SQLSTATE * .* MESSAGE 3 : 40001 * .* SORT STATUS : " " * .* * .****************************************************************************** .* * .* PED23870 A B E N D E D * .* IN STEP DB2 * .* DATE = 03/01/14 TIME = 03:26:03 * .* * .* PROGRAM : COMPILED : * .* PARAGRAPH : 4230-WRITE-HEADER * .* INSTRUCTION : * .* FILE STATUS : ".." * .* DUMP : NO * .* MESSAGE 1 : INSERT FAIL * .* MESSAGE 2 : THE FOLLOWING IS THE SQLSTATE * .* MESSAGE 3 : 40001 * .* SORT STATUS : " " * GIS Process failures when trying to write moderate to large sized records to EDI split detail table: × ¤ 1393382113803-743111 ¤ 02/25/14 20:35:13 ¤ GIS ¤ 2126166750807162426 ¤ 1101545896 ¤ sli.eom.base.exceptions.DatabaseException.logAll ¤ Exception Data: ¤ núll ¤ CommBine_GIS_Adapter_Service_EAR ¤ núll ¤ PROD ¤ CBCibmprd51.schneider.com ¤ 0 ¤ sli.eom.base.exceptions.DatabaseException: sni.commbine.db.da.CommBineEDISplitServiceDA.executeUpdateInternal : com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -913, SQLSTATE: 57033, SQLERRMC: 00C9008E;00000D01;00000325.00000006 SQLState : 57033 Message : DB2 SQL error: SQLCODE: -913, SQLSTATE: 57033, SQLERRMC: 00C9008E;00000D01;00000325.00000006 at sli.eom.util.persistence.da.BaseDA.executeUpdateInternal(BaseDA.java:1267) at sli.eom.util.persistence.da.BaseDA.executeUpdate(BaseDA.java:1164) at sni.commbine.db.da.CommBineServiceDA.appl