Using virtual system tables

Depending on the size and complexity of your database, some online database administration utilities can take a significant amount of time to complete. You can use the _UserStatus virtual system table (VST) to monitor the state of the following administration utilities that can be performed online:

IDXANALYS — Displays information about index blocks

IDXCOMPACT — Increases space utilization of an index block

IDXFIX — Detects corrupt indexes and records with a missing or incorrect index

IDXMOVE — Moves indexes among application data storage areas

TABLEMOVE — Moves tables among application data storage areas

For detailed descriptions of each VST, see VirtualSystem Tables.

Using the virtual system table mechanism, you can monitor the status and progress of several database administration utilities.

The following code sample demonstrates using an ABL routine to monitor all the index move (PROUTIL IDXMOVE) processes being performed:

/* Monitor all "index move" processes every three seconds */
REPEAT:
  FOR EACH _UserStatus WHERE _UserStatus-Operation = "Index move" NO-LOCK:
    DISPLAY _UserStatus.
  END.
  PAUSE 3.
END.

The following is an equivalent OpenEdge SQL statement to monitor all the index move (PROUTIL IDXMOVE) processes being performed:

SELECT * FROM _UserStatus WHERE _UserStatus-Operation = "Index move";