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:

For more information on VSTs, see Virtual System Tables."

EXAMPLES

Using 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:

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

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

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

The following example describes how to use a Progress 4GL routine to monitor the status of all administration utilities performed:

/*Monitor all user processes who report their status (admin utilities)*/ 
REPEAT:	
  FOR EACH _UserStatus WHERE _UserStatus-Operation <> ?: 
    DISPLAY _UserStatus. 
  END. 
PAUSE 3. 
END. 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095