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

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
partminerAsked:
Who is Participating?
 
Kent OlsenData Warehouse Architect / DBACommented:
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
 
thepanchCommented:
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
 
thepanchCommented:
you can check this site to learn more about db2 technology
http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
partminerAuthor Commented:
Thepanch do you know whey it's creating super exclusive lock for even fetch operations also .
0
 
thepanchCommented:
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
 
thepanchCommented:
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
 
partminerAuthor Commented:
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
 
partminerAuthor Commented:
Thepanch is it not possible to release those locks from our end
0
 
partminerAuthor Commented:
Some what helpful not exactlky
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.