Utilities › RMODBASE - Database Maintenance › STATUS Control Statement › Messages Resulting From STATUS

Messages Resulting From STATUS

The STATUS statement causes the RMODBA09 messages to be displayed. The descriptions of the database statistics displayed in the RMODBA09 messages are as follows:

Index levels

Specifies the number of levels or hierarchies in the database index.

Index records

Specifies the total number of records in the database.

Index allocations

Specifies the total number of control areas or segments that comprise the database.

Index blocks

Specifies the total number of database blocks that comprise the database index.

These index blocks can be pointer blocks, data blocks, or free blocks.

Index used blocks

Specifies the total number of database blocks currently being used in the database index.

This value includes the index pointer block, the index data blocks, and the index empty blocks.

Index pointer blocks

Specifies the total number of higher level hierarchical index blocks that reference lower level index blocks.

Index data blocks

Specifies the total number of database blocks that comprise the lowest level of the database index, and that contain the physical database data.

Index empty blocks

Specifies the total number of index data blocks that do not contain any index records.

When index records are deleted from the database index, the index data is removed from the index data block. When all index records have been removed from the index data block, the index data block is considered empty but available for subsequent use in the same key range. COPY or UNLOAD/LOAD functions of the RMODBASE utility are recommended for a database with a high percentage of empty blocks.