Kbase P107244: How to use _LockReq table for finding abnormal number of locks per user
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to use _LockReq table for finding abnormal number of locks per user
FIX:
For each user there is an entry in the _LockReq VST table, the user beeing identified within _UserLock -Name. The field _UserLock -Recid is an array[512] and it gives the first 512 locks. The following program can been used to identify all users with more than 100 locks.
FOR EACH _UserLock:
IF _UserLock -Recid[100] <> ? THEN DISPLAY _UserLock -Name.
END.