Solved

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

Posted on 2010-09-02
9
775 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
  • 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
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 45

Accepted Solution

by:
Kdo earned 500 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem to script 14 187
Call a stored proc from a VIEW 5 101
DB2 CONCAT FAILING 4 112
iSeries DB2 Query 2 95
November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

831 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