Kbase P8908: What is the lock table high water mark?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/19/2006 |
|
Status: Unverified
FACT(s) (Environment):
What is the lock table high water mark?
FIX:
In promon under R&D > Status Displays > Shared Resources, a value for the "Lock Table High water mark" is displayed. This value is the maximum number of lock table entries that have been in use at the same time. It will always have a value of at least 1, due to the schema lock.
The VST _DbStatus._DbStatus-MostLocks can also be accessed for this information.
For example:
FIND FIRST _DBstatus USE-INDEX _Dbstatus-Id NO-LOCK NO-ERROR.
IF AVAILABLE _Dbstatus THEN
DISPLAY_Dbstatus._Dbstatus-NumLocks
_Dbstatus._Dbstatus-MostLocks.