Error Code=-913 Sqlstate=57033
Contents |
Technote (troubleshooting) Problem(Abstract) You receive deadlocks on z/OS when sql state 57033 running WebSphere Business Events V6.2.1 with time-based context expiration. Symptom
Reason Code Sqlstate=57033
DB2 on z/OS reports deadlock exceptions similar to the following: com.ibm.db2.jcc.t2zos.cb: [IBM/DB2][T2zos/3.6.67]T2zosResultSet.readFetch_:nativeFetch:2950: DB2 engine db2 sqlstate 57033 SQL error, SQLCODE = -913, SQLSTATE = 57033, error tokens = 00C90088;00000302;WBE621 .TSNAME5 .X'000002' Trace: 2009/04/20 09:22:00.358 01 t=9C1B58 c=UNK key=P8 (13007002) ThreadId: 00000044 http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n913.html FunctionName: com.ibm.wbe.db.DataSourceDB SourceId: com.ibm.wbe.db.DataSourceDB Category: SEVERE ExtendedMessage: BEER0886E: An error occurred while processing a result set: com.ibm.db2.jcc.t2zos.cb: [IBM/DB2][T2zos/3.6.67]T2zo sResultSet.readFetch_:nativeFetch:2950: DB2 engine SQL error, SQLCODE = -913, SQLSTATE = 57033, error tokens = 00C90088;00000302;WBE 621 .TSNAME5 .X'000002' See attached file for complete stack. Cause These exceptions http://www-01.ibm.com/support/docview.wss?uid=swg21386398 are the result of the steps table daemon attempting to execute deletes against the steps table at the same time as regular complex filter evaluation is accessing the steps table in read mode. Resolving the problem Disable automated context expiration clean-up on z/OS. Refer to the Pruning the WebSphere Business Events steps table automatically topic in the WebSphere Business Events information center for instructions. If clean-up is required on the steps table, it should be performed manually. Refer to the Pruning the WebSphere Business Events steps table manually topic in the WebSphere Business Events information center for instructions. Document information More support for: WebSphere Business Events Usability Software version: 6.2.1 Operating system(s): z/OS Reference #: 1386398 Modified date: 2009-06-09 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
the http://www.sqlerror.de/db2_sql_error_-913_sqlstate_57033.html victim in a deadlock or experienced a timeout. The reason code indicates whether a deadlock or timeout http://knowledgebase.progress.com/articles/Article/What-can-cause-the-error-Failed-Execution-Due-to-Deadlock-Timeout-SQLState-57033-Error-Code-913-on-DB2 occurred. Refer to message DSNT500I under DB2 Messages for an explanation of 'resource-type' and 'resource-name'. Refer to Table db2 sql 3 in Appendix C, “Problem determination,” on page 757 for an explanation of resource type codes. System action: The SQL statement cannot be executed. If the SQL statement being executed was a cursor FETCH, DB2 closes error code=-913 sqlstate=57033 the cursor. SQLERRD(3) also contains the reason-code which indicates whether a deadlock or timeout occurred. The most common reason codes are: v 00C90088 - deadlock v 00C9008E - timeoutProgrammer response: The application should either commit or roll back to the previous COMMIT. Then, generally, the application should terminate. See message DSNT376I for possible ways to avoid future deadlocks or timeouts. For more information about how CICS and TSO handle deadlocks, see Part 4 of DB2 Application Programming and SQL Guide. <- BACK TO INDEX This is a free Service. I assume no warranty for misprints, and for the correctness and completeness of information and entries.
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & Deployment DevCraft Leverage a complete UI toolbox for web, mobile and desktop development OpenEdge Build, protect and deploy apps across any platform and mobile device Kendo UI Build rich, smart HTML5 and JavaScript apps for any platform, browser or device Telerik Platform Build mobile apps for iOS, Android and Windows Phone Nativescript Use Angular, TypeScript or JavaScript to build truly native mobile apps Rollbase Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud Test Studio Automate UI, load and performance testing for web, desktop and mobile Modulus Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud Data Connectivity DataDirect Connectors Optimize data integration with high-performance connectivity Business Rules Management Corticon Automate decision processes with a no-code business rules engine View All Products Solutions Digital Business Transformation Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation. Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for empowering marketers aPaaS Fuel agility with ever-ready applications, built in the cloud Enterprise Mobility Faster, tailored mobile experiences for any device and data source New & Trending E-book The Digital Ultimatum: Why Businesses Must Digitally Transform to Survive â€" and Thrive Survey Report The State of Digital Business Support & Learning Support Support Services Knowledge Base Customer Order Management Download Center Services Training Consulting Services Managed Database Offering Learning Documentation Webinars How-To Videos Whitepapers Community Blogs Success Stories Partners Company Login Progress Support Rollbase DataDirect Cloud PartnerLink Telerik Your Account Telerik Platform Global Sites Brazil France Germany Netherlands United States Menu 1-800-477-6473 CONTACT SLAES Knowledge Base 000026211 < Back to search results What can cause the error "Failed Execution Due to Deadlock/Timeout" to occur against DB2 when using the JDBC DB2 driver?Printable View &la