Kbase P109293: How many Lock Tables entries are being used for a database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/01/2011 |
|
Status: Verified
GOAL:
How to see how many Lock Table entries are in use?
GOAL:
How to see the lock table high water mark?
GOAL:
Is there a way to see how many Lock Table entries are being used?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
FIX:
The Lock Table High Water Mark for a database can be viewed in promon. The steps to locate this information are:
1. promon dbname
2. Type R&D and press return.
3. Select 1. Status Displays
4. Select 13. Shared Resources
5. Look at the following two lines of information:
Lock table entries in use: 0 of 8192
Lock table high water mark: 1
Lock table entries in use ? The number of lock table entries that are currently being used, and the total number of entries available.
Lock table high water mark ? The maximum number of lock table entries that were in use simultaneously.
This information can also be identified by making use of VSTs (Virtual System Tables). See solution: P148123, "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"