Db2 Sql Error Code 911
Contents |
administering Portal SQLCODE: -911; SQLSTATE: db2 sql error code 805 40001; SQLERRMC: 68; -911; 911; 40001; 68 Technote (troubleshooting) Problem(Abstract) While db2 sql error code 404 performing an administrative task in WebSphere Portal (either with XMLAccess, thru the Portal Adminstration Pages, or a WPSconfig/ConfigEngine http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n911.html script), a DB2 exception with SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68 appears. Symptom The exception will resemble the following (taken from an XMLAccess script): ==============================
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 the company Business Learn more about hiring http://stackoverflow.com/questions/12463493/db2-sql-error-sqlcode-911-sqlstate-40001-sqlerrmc-68 developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question https://coderanch.com/t/481066/JDBC/databases/DB-SQL-error-SQLCODE-SQLSTATE 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: Sign up DB2 SQL Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=68 up vote 0 down vote favorite I am getting this error when I ran: alter table tablename add column columnname varchar(1) default 'N'; DB2 SQL Error: db2 sql SQLCODE=-911, SQLSTATE=40001, SQLERRMC=68 How to solve it? db2 share|improve this question edited Nov 7 '13 at 15:21 Benjamin 11.4k1692171 asked Sep 17 '12 at 16:31 Naga 1442311 add a comment| 4 Answers 4 active oldest votes up vote 1 down vote The alter statement wants to get an X lock on this row in SYSIBM.SYSTABLES. There is an open transaction that has this row/index value in an incompatible lock state. This lock that caused the timeout could even be db2 sql error from an open cursor that reads this row with an RS or RR isolation level. Terminate any other SQL currently trying to query SYSTABLES and any utilities that may be trying to update SYSTABLES like reorg and runstats then try the alter again. share|improve this answer answered Apr 23 '15 at 13:55 Bill Peck 362 Run "db2 get snapshot for locks on
New Topic programming forums Java Java JSRs Mobile Certification Databases Caching Books Engineering Languages Frameworks Products This Site Careers Other all forums Forum: JDBC and Relational Databases DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 2 Geetha Gubendran Ranch Hand Posts: 75 posted 6 years ago Exceptioncom.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 2. I have a db2 database update statement in java compute node in message broker with which I am getting the above mentioned sql error (due to deadlock). This happened 2 days and I could see that this error is there in the message broker logs but the database logs do not contain any deadlock history. I know that by setting lock flags we can get rid of this issue, but then I want to know what exactly is causing this issue when we dont find any deadlock or timeout error in DB2 log? Jan Cumps Bartender Posts: 2602 13 I like... posted 6 years ago There are some pointers for deadlock troubleshooting in db2 using its deadlock event monitor, e.g.: Finding the needle in the Deadlock haystack Regards, Jan OCUP UML fundamental and ITIL foundation Post Reply Bookmark Topic Watch Topic New Topic Similar Threads DB2 SQL error: SQLCODE: -8002 Error Code DB issue (prepared statement) error clarification Issue when migrating from Spring 2.5 to Spring 2.5.6 SEC 02 version All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter Contact Us | advertise | mobile view | Powered by JForum | Copyright © 1998-2016 Paul Wheaton