Previous Topic: SETNext Topic: Messages Resulting From STATUS


STATUS

The STATUS control statement is used to display usage statistics about the database. These usage statistics are as follows:

You can view a partial set of these statistics.

Note: For more information about these usage statistics, see the chapter, "System Administration" in the User Guide.

The high-level name of the database must have been defined with the NAME control statement (or the PARM parameter of the EXEC JCL statement).

Syntax:

STATUS display-option reserve-option

where:

display-option

Specifies FULL to print complete statistics for the database, master index, and data sets, or INDEX to print statistics for the database and master index only, or USED to print the 'percentage used' for the database.

If the parameter is omitted, statistics for the database and data sets are printed.

reserve-option

Specifies either RESERVE to place a reserve on the database for the duration of the index evaluation process or NORESERVE to not place a reserve on the database.

This option is only applicable when specified with the display–option. Because the master index is updated by many tasks, jobs, or online sessions, the master index data can change during the evaluation process, causing inconsistent statistics. The RESERVE option delays external updates to the database for obtaining consistent statistics. If reserve-option is omitted, NORESERVE is assumed.

To compile index statistics information, the entire master index must be read. Depending on the size of the database, this process can take a long time.