Kbase P4470: How to verify the activity of a specific index or group of indexes
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/3/2002 |
|
Solution ID: P4470
GOAL:
How to verify the activity of a specific index or group of indexes
FACT(s) (Environment):
Progress 9.x
FIX:
Check the activity of a group of indexes or a specific index by fetching the _indexstat VST table.
The _indexstat table records statistical information from a range of indexes defined by the database parameters, -baseindex and -indexrangesize. Adjust these database startup parameters as necessary to accommodate the range of indexes that you need to monitor.
The following 4GL program maps the index name and the records of the _indexstat table:
FOR EACH _indexstat NO-LOCK:
FIND FIRST _index WHERE _idx-num = _indexstat-id NO-LOCK NO-ERROR.
IF AVAILABLE (_index) THEN DISPLAY _index-name _indexstat-read.
END.