Progress
Database Administration
Guide and Reference
Using Virtual System Tables To Obtain Status Of Administration Utilities
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:
- PROUTIL IDXANALYS – displays information about index blocks
- PROUTIL IDXCOMPACT – increases space utilization of an index block
- PROUTIL IDXFIX – detects corrupt indexes and records with a missing or incorrect index
- PROUTIL IDXMOVE – moves indexes among application data storage areas
- PROUTIL TABLEMOVE – moves tables among application data storage areas
For more information on VSTs, see Virtual System Tables."
EXAMPLESUsing the virtual system table mechanism, you can monitor the status and progress of several database administration utilities.
The following example describes how to use a Progress 4GL routine to monitor all the index move (PROUTIL IDXMOVE) processes being performed:
The following is an equivalent SQL-92 statement to monitor all the index move (PROUTIL IDXMOVE) processes being performed:
The following example describes how to use a Progress 4GL routine to monitor the status of all administration utilities performed:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |