Kbase P81007: Can I use_UserStatus Virtual System Table to monitor the status of my database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Can I use _UserStatus Virtual System Table to monitor my database?
FIX:
Yes. Depending upon the size and complexity of your database, some online database administration utilities can take a significant amount of time to complete. With the database broker running, 4GL and SQL-92 you can use the _UserStatus Virtual System Table (VST) to monitor the state of the following 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
The progress of the above utilities can display:
- the phase the utility is in
- the user number
- the tables and indexes worked upon
- the current position in the record chain
- the number of blocks accessed
- the tables and indexes compacted