The STATUS statement causes the SARDBA09 messages to be displayed. The meaning of the index statistics displayed in the SARDBA09 messages are as follows:
The number of levels or hierarchies in the master index.
The total number of records in the master index.
The total number of control areas or segments that comprise the master index.
The total number of database blocks that comprise the master index.
These index blocks can be pointer blocks, data blocks, or free blocks.
The total number of database blocks currently being used in the master index.
This value includes the index pointer block, the index data blocks, and the index empty blocks.
The total number of higher level hierarchical index blocks that reference lower level index blocks.
The total number of database blocks that comprise the lowest level of the master index, and that contain the physical index data.
The total number of index data blocks that do not contain any index records.
When index records are deleted from the master 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. REORG or UNLOAD/LOAD functions of the SARDBASE utility are recommended for a database with a high percentage of empty blocks.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|