NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
F-22
EXTENTS Display
EXTENTS Display
The following figure shows the EXTENTS display.
The first line in the EXTENTS display is the same as the first line in the DETAIL
display for tables, indexes, and Guardian files. The other fields are as follows:
STATISTICS Display
The following figure shows the STATISTICS display.
The fields in the STATISTICS display are as follows:
file-name date-and-time
EXTENT # OF PAGES STARTING PAGE [ PART ]
extent-num num-pages start-page [ name ]
...
extent-num The ordinal extent number of the entry. The first extent is 0. NONE
indicates no extents are allocated.
num-pages The number of disk pages (2048-byte units) in the extent.
start-page The absolute page address of the first page of the extent.
name For partitioned files, the partition name associated with the entry.
TOTAL TOTAL AVG # AVG AVG %
LEVEL BLOCKS RECS RECS SLACK SLACK PART
1 1 1 1.0 4065 99 $VOL1
DATA 1 1 1.0 4046 99
FREE 0
BITMAP 1
LEVEL Indicates the tree level of the entry, as follows:
DAT
A
Data level (this is the only level shown for relative
and entry-sequenced files)
n Number of level with 1 as lowest level (for key-
sequenced files)
The rest of the fields in the line apply to the indicated level.
TOTAL BLOCKS The total number of blocks in use.
TOTAL RECS The total number of records. At the DATA level, TOTAL
RECS is the total number of data records in the file.
AVG # RECS The average number of records per block.
AVG SLACK The average number of unused bytes per block.
AVG % SLACK The average percent of unused bytes for each block.