Kbase P102537: How to check who has the lock for a specific REC-ID
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/11/2008 |
|
Status: Verified
GOAL:
How to check who has the lock for a specific REC-ID
GOAL:
What user is holding a certain record lock?
GOAL:
How to verify which user is holding a specific lock via 4GL/ABL
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
Checking who has the lock for a specific record identified by its REC-ID can be done with the following 4GL statement.
FIND FIRST _Lock WHERE _Lock-Recid = <rec-id>.
DISPLAY _Lock-Usr _Lock-Name _Lock-Table _Lock-Type _Lock-Flags.
with:
_Lock_usr, user number
_Lock-Name, user name
_Lock-Table, table number
_Lock-Type, type of lock (should be REC)
_Lock-Flags, S(shared), X(exclusive), U(upgrade from shared to exclusive),
L(limbo) or Q(queued)
The statement might take long; the longest execution time would occur when there is no lock anymore and there is a large Lock Table (-L parameter on database broker).