Database Utilities › STATUS › Index File Statistics

Index File Statistics

Executing the database utility SARDBASE/STATUS FULL creates a report with detailed statistics for the index space. The following is an example of the report.

   SARDBA09  Index file statistics:
   SARDBA09     Block size:                 8906
   SARDBA09     Total cylinders:              40
   SARDBA09     Total blocks:               3600
   SARDBA09     Total used blocks:          1440
   SARDBA09     Percent utilization:          40
   SARDBA09     Total levels:                  3
   SARDBA09     Total records:             20727
   SARDBA09     Total allocations:            16
   SARDBA09     Total pointer blocks:          7
   SARDBA09     Total data blocks:           183
   SARDBA09     Total empty blocks:            0
   SARDBA09     Total free blocks:          1249

where:

Block Size

The default block size of the index extent is 8906.

Cylinders Total Blocks

Total blocks represents the number of blocks that were allocated in the total space (number of cylinders) allocated to the index space.

Used Blocks

The 'percent utilized' is a simple calculation of the 'used/total' but it is not a calculation of the amount of space in all used blocks which contain data.

Unlike a block in the data space, a block in the index space might only contain one or two index pointers or control records, so 80% of the blocks might be in use, but those blocks might be only 20% full. A block might also have been used but is now 'free'.

Levels

The number of levels in the index 'tree'.

Higher level index blocks contain lower level index block pointers and the lowest level contains the Master Index record data. Thus, three 'levels' would represent two index pointer levels and the Master Index record data level.

Records

This is the total number of Master Index records.

Beginning with r11, the number of index records has increased. These records help improve the performance of functions such as the backup cycle.

Pointer Blocks

The number of blocks which contain lower level index pointers.

Data Blocks

The number of blocks that contain Master Index data records.

Empty Blocks

A block can be placed in this block pool under certain rare error conditions; under normal circumstances, expect this field to display zero blocks.

Free Blocks

The number of allocated blocks that were allocated, that is, shown in the number of used blocks, but that are currently empty and available for use when additional blocks are needed.