Row table locked

[Mel Apiso]

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.

[Fan Ruo Xin]

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.