?
Solved

I am unable to read data from tables .Please see the screen shot for table lock information  .

Posted on 2010-09-02
9
Medium Priority
?
780 Views
Last Modified: 2012-05-10
when i am trying to read data using below query
select offer_key from vendor_offers fetch first 5 rows only for read only with ur

am getting  error as DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68
Message: The current transaction has been rolled back because of a deadlock or timeout. Reason code "68".
image.JPG
0
Comment
Question by:partminer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
9 Comments
 
LVL 4

Expert Comment

by:thepanch
ID: 33584159
the code means:

68 transaction rolled back due to lock timeout.

You can avoid this by setting an appropriate value for the LOCKTIMEOUT database config param, and making sure that your apps commit (to release locks).
0
 
LVL 4

Expert Comment

by:thepanch
ID: 33584172
you can check this site to learn more about db2 technology
http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp
0
 

Author Comment

by:partminer
ID: 33584185
Thepanch do you know whey it's creating super exclusive lock for even fetch operations also .
0
Quick Cloud Training

Looking for some quick training on the cloud in 2 hours or less? Check out these how-to guides in AWS, Linux, OpenStack, Azure, and more!

 
LVL 4

Expert Comment

by:thepanch
ID: 33584244
super exclusive locks  is a 'special waiter' lock, designed specifically to wait for anyone with a conflicting lock to leave while never starving new lock requests coming in.

So someone out there isn't releasing their table lock - either a connection never does commit/rollback or does only commits with hold so that the table lock is never released.

that could be happening.
0
 
LVL 4

Expert Comment

by:thepanch
ID: 33584249
Now i remember, that happens also when any table is doing index reorganization, or the db is doing manteinance job, that super exclusive lock means the DB/Table is busy and you cant do nothing, like if someone has a transaction pending with no commit, and you are triying to select from that table.
0
 

Author Comment

by:partminer
ID: 33584455
Thepanch is it not release those locks from our end .I have all admin rights available on db . My SBA is out of office .I need to start my application . But application unable to read data from tables due to super exclusive lock .
0
 

Author Comment

by:partminer
ID: 33584524
Thepanch is it not possible to release those locks from our end
0
 
LVL 46

Accepted Solution

by:
Kent Olsen earned 1500 total points
ID: 33586001
Hi Partminer,

If a table is locked and no processes are running, you've got a serious DB2 issue that should be reported to IBM.  They'll want to know exactly what happened to get into this state because it's not supposed to happen.

That said, are you sure that there are no processes running?  You can check by running 'LIST APPLICATIONS' from the Command Line Interface.


My guess is that there really is something running but it's not obvious.


Kent
0
 

Author Closing Comment

by:partminer
ID: 33594886
Some what helpful not exactlky
0

Featured Post

AWS Certified Solutions Architect - Associate

This course has been developed to provide you with the requisite knowledge to not only pass the AWS CSA certification exam but also gain the hands-on experience required to become a qualified AWS Solutions architect working in a real-world environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month9 days, 23 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question