By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,678 Members | 2,439 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,678 IT Pros & Developers. It's quick & easy.

Row table locked

P: n/a
Hi,
I want to know if I can detect exactly what row table is locked.

My application is locked and I get valuable information (table, application,
lock mode...) with "get snapshot for locks..." command, but I need to know
what is the row table (the values in the row or PK row value) locked. Perhaps
exists some relationships between rows in the table and lock information.

Thanks in advance.
Mel.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
DB2 internally use the "Lock Name" or "Lock object Name" to find out the row
which is locked. I don't think this part is documented. You might need to
call IBM support to see if they can help you.

"Mel Apiso" <me*******@hotmail.com> wrote in message
news:f6**************************@posting.google.c om...
Hi,
I want to know if I can detect exactly what row table is locked.

My application is locked and I get valuable information (table, application, lock mode...) with "get snapshot for locks..." command, but I need to know what is the row table (the values in the row or PK row value) locked. Perhaps exists some relationships between rows in the table and lock information.

Thanks in advance.
Mel.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.