Db2 Sql Error Sqlcode=-911 Sqlstate=40001
Contents |
administering Portal SQLCODE: -911; SQLSTATE: db2 sql error sqlcode=-911 sqlstate=40001 sqlerrmc=2 40001; SQLERRMC: 68; -911; 911; 40001; 68 Technote (troubleshooting) Problem(Abstract) While sqlcode=-911 sqlstate=40001 sqlerrmc=2 performing an administrative task in WebSphere Portal (either with XMLAccess, thru the Portal Adminstration Pages, or a WPSconfig/ConfigEngine sql error code 911 script), a DB2 exception with SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68 appears. Symptom The exception will resemble the following (taken from an XMLAccess script): ==============================
Db2 Sqlstate 40001
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
Db2 Sqlcode 911
the company Business Learn more about hiring developers or posting ads with us Stack Overflow sqlcode=-1218 sqlstate=57011 Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 db2 sql error sqlcode 911 sqlstate 40001 sqlerrmc 2 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 http://www-01.ibm.com/support/docview.wss?uid=swg21440972 ran: alter table tablename add column columnname varchar(1) default 'N'; DB2 SQL Error: 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 http://stackoverflow.com/questions/12463493/db2-sql-error-sqlcode-911-sqlstate-40001-sqlerrmc-68 transaction that has this row/index value in an incompatible lock state. This lock that caused the timeout could even be 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
be sure to check out the FAQ by clicking the link above. You may http://www.dbforums.com/showthread.php?1629947-DB2-SQL-Error-SQLSTATE-40001-SQLERRMC-68 have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: DB2 SQL Error: SQLSTATE: 40001, SQLERRMC: 68 Tweet Thread Tools Show Printable Version Subscribe db2 sql to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-01-08,18:15 #1 Priya M View Profile View Forum Posts Registered User Join Date May 2008 Posts 1 Unanswered: DB2 SQL Error: SQLSTATE: 40001, SQLERRMC: 68 Hi, I am getting the following exception when db2 sql error there are multiple instances of EJB that try to update the same row in the database. I have a sequence number stored in a properties table and two nodes in a cluster have EJBs running that want to increment this sequence number. The exception is occuring when the code does a save on the hiberate DAO object, to update the row. Could someone please tell me what do I need to do to avoid this error? I would really appreciate your help. Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68 at com.ibm.db2.jcc.b.rc.b(rc.java:3180) at com.ibm.db2.jcc.a.eb.i(eb.java:227) at com.ibm.db2.jcc.a.eb.a(eb.java:183) at com.ibm.db2.jcc.a.eb.a(eb.java:34) at com.ibm.db2.jcc.a.s.a(s.java:30) at com.ibm.db2.jcc.a.h.Gb(h.java:325) at com.ibm.db2.jcc.b.rc.R(rc.java:3022) at com.ibm.db2.jcc.a.d.f(d.java:1070) at com.ibm.db2.jcc.b.r.a(r.java:191) at com.ibm.db2.jcc.b.rc.c(rc.java:302) at com.ibm.db2.jcc.b.rc.next(rc.java:277) at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJ dbcResultSet.java:2419) at org.hibernate.loader.Loader.doQuery(Loader.java:68 5) at org.hibernate.loader.Loader.doQueryAndInitializeNo nLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:221 1) ... 29 more Thanks, Priya Reply With Quote 05-01-08,21:24 #2 Marcus_A View Profile View Forum Posts Registered User Join Date May 2003 Location USA Posts 5