Solved

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

Posted on 2010-09-02
9
779 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
Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

 
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:
Kent Olsen 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

Turn Insights into Action

Communication across every corner of your business is essential to increase the velocity of your application delivery and support pipeline. Automate, standardize, and contextualize your communication processes with xMatters.

Question has a verified solution.

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

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 (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 brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

696 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