| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may 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.
|
 |
07-22-09, 13:51
|
|
Registered User
|
|
Join Date: Apr 2009
Posts: 42
|
|
|
lock-wait with no other applications
|
|
Hi,
Application is in lock-wait, but when I list applications this is the only application connected to the database. What could be the reason?
Thank you!
|
|
07-22-09, 16:27
|
|
Registered User
|
|
Join Date: May 2003
Location: USA
Posts: 5,196
|
|
Did you try list applications show detail?
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
|
|
07-22-09, 16:50
|
|
Registered User
|
|
Join Date: Apr 2009
Posts: 42
|
|
|
|
list applications show detail displays the same information - one application in lock-wait
|
|
07-22-09, 20:43
|
|
∞∞∞∞∞∞
|
|
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
|
|
Use snapshot / db2pd to see what it's waiting for. If this is the only appl connected to the db, then I suspect that there is an indoubt transaction.
|
|
07-23-09, 10:09
|
|
Registered User
|
|
Join Date: Apr 2009
Posts: 42
|
|
How can I tell if we have indoubt transactions?
|
|
07-23-09, 10:45
|
|
Super Moderator
|
|
Join Date: Aug 2001
Location: UK
Posts: 4,534
|
|
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
|
Last edited by sathyaram_s; 07-23-09 at 10:48.
|
07-23-09, 11:13
|
|
Registered User
|
|
Join Date: Apr 2009
Posts: 42
|
|
Thank you. How do I tell if we have indoubt transactions from DB2 snapshot?
|
|
07-23-09, 12:29
|
|
Registered User
|
|
Join Date: Nov 2005
Location: IL
Posts: 554
|
|
Read prior post 
__________________
--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
DB2 v9.1.0.2 os 5.3.0.0
|
|
07-23-09, 13:32
|
|
Registered User
|
|
Join Date: Apr 2009
Posts: 42
|
|
But prior post doesn't tell me how to tell if my application is in lock-wait with indoubt transactions. How to tell this information from DB2 snapshots?
|
|
07-23-09, 13:55
|
|
∞∞∞∞∞∞
|
|
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
|
|
Does snapshot show you what it's waiting for?
|
|
07-23-09, 14:00
|
|
∞∞∞∞∞∞
|
|
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
|
|
|
|
07-24-09, 17:10
|
|
Registered User
|
|
Join Date: Jul 2009
Location: NY
Posts: 886
|
|
Do you use big sized Global Temporary Tables in application ?
Also the problem could be related to the sensitive cursors.
Lenny K.
|
|
07-24-09, 18:35
|
|
Registered User
|
|
Join Date: Apr 2009
Posts: 42
|
|
Lenny, Can you explain how this problem can be related to sensitive cursors?
Snapshot showed that it was in lock-wait with application 0.
|
|
07-24-09, 21:10
|
|
Registered User
|
|
Join Date: Jul 2009
Posts: 150
|
|
|
Last edited by DB2Plus; 07-24-09 at 21:38.
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
lock-wait with no other applications
