Kbase P148123: Which VST table will give us information on the lock table with regard to: the total number of curre
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/24/2011 |
|
Status: Verified
GOAL:
Which VST table will give us information on the lock table with regard to: the total number of current locks in use and the high water mark
GOAL:
Which VST table has a total value for the number of locks currently in Use within the lock table?
GOAL:
Which VST table has a value for the high water mark of locks used in the lock table?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Progress 9.x
FIX:
The _ DBStatus table has this information. The field _DBStatus-MostLocks will give the high water mark of the lock table and the field _DbStatus-NumLocks will have the locks currently in use.
Example ABL code that can be ran against a database to see current # of Locks and Lock Table HighWater Mark:
DEFINE VARIABLE ivar1 AS INTEGER NO-UNDO.
DEFINE VARIABLE ivar2 AS INTEGER NO-UNDO.
FOR EACH _dbstatus:
ASSIGN ivar1 = _dbstatus-numlocks.
ASSIGN ivar2 = _dbstatus-mostlocks.
DISPLAY ivar1 LABEL "Cur. # of Locks"
ivar2 LABEL "Tot # of Locks" WITH 1 COLUMN DOWN.
END.
This same information is available using promon dbname -> R&D -> 1. Status Displays -> 13. Shared Resources.