Kbase P157190: How to get the value of the promon's 'Lock Waits' column using VSTs?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/06/2010 |
|
Status: Unverified
GOAL:
How to get the value of the promon's 'Lock Waits' column using VSTs?
GOAL:
How to get the value of the promon's 'Total Waits' column using VSTs?
GOAL:
How to get the value of the promon's 'Resource Waits' column using VSTs?
GOAL:
How to programmatically retrieve the same kind of data that is displayed on the promon's Activity: Performance Indicators Screen?
GOAL:
What VST table(s) match up to the Lock Waits info in promon?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Progress 9.x
FIX:
One can get the value of the "Total Waits" column in promon by doing a FOR EACH against the _resrc table and accumulating the values stored in the _resrc-wait field.
For the promon's "Lock Waits" column, one can get its value by accumulating the values in the _resrc-wait field when the _resrc-name field has a value of "Record Lock".
As for the "Resource Waits" column in promon, one can get its value by subtracting the value of the "Lock Waits" from the value of the "Total Waits" above.