| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| PARTITION |
SMALLINT NOT NULL |
Partition number. Zero if index is not partitioned. |
G |
| IXNAME |
VARCHAR(18) NOT NULL |
Name of the index. |
G |
| IXCREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of the index. |
G |
| PQTY |
INTEGER NOT NULL |
Primary space allocation in units of 4KB storage blocks. Zero if a storage group is
not used. |
G |
| SECQTYI |
INTEGER NOT NULL |
Secondary space allocation in units of 4KB storage. If a storage group is not used,
the value is 0. |
G |
| LEAFDIST |
INTEGER NOT NULL
WITH DEFAULT -1 |
100 times the average number of leaf pages between successive active leaf pages of the index.
The value is -1 if statistics have not been gathered. |
S |
| SPACEF |
FLOAT(8) NOT NULL
WITH DEFAULT -1 |
Number of kilobytes of DASD storage allocated to the index space partition. The
value is -1 if statistics have not been gathered. |
G |
| STATSTIME |
TIMESTAMP NOT NULL |
If RUNSTATS updated the statistics, the date and time when the last invocation of
RUNSTATS updated the statistics.
The default value is '0001-01-01-00.00.00.000000'. |
G |
| FAROFFPOSF |
FLOAT(8) NOT NULL
WITH DEFAULT -1 |
Number of referred to rows far from optimal position because of an insert into a full
page. The value is -1 if statistics have not been gathered. The column is not
applicable for an index on an auxiliary table. |
S |
| NEAROFFPOSF |
FLOAT(8) NOT NULL
WITH DEFAULT -1 |
Number of referred to rows near, but not at optimal position, because of an insert
into a full page. Not applicable for an index on an auxiliary table. The value is -1 if
statistics have not been gathered. |
S |
| CARDF |
FLOAT(8) NOT NULL
WITH DEFAULT -1 |
Number of keys in the index that refer to data rows or LOBs. The value is -1 if
statistics have not been gathered. |
S |
| EXTENTS |
INTEGER NOT NULL
WITH DEFAULT -1 |
Number of data set extents. The value is -1 if statistics have not been gathered.
This value is only for the last DSNUM for the # object. |
G |
| PSEUDO_DEL_ENT |
INTEGER NOT NULL
WITH DEFAULT -1 |
Number of psuedo deleted entries. The value is -1 if statistics have not been
gathered. |
G |
| DSNUM |
INTEGER NOT NULL
WITH DEFAULT -1 |
Data set number within the table space. For partitioned index spaces, this value
corresponds to the partition number for a single partition copy, or 0 for a copy of an
entire partitioned index space. The value is -1 if statistics have not been gathered. |
G |
| IBMREQD |
CHAR(1) NOT NULL
WITH DEFAULT 'N' |
A value of Y indicates that the row came from the basic machine-readable material
(MRM) tape. For all other values, see Release dependency indicators in topic D.0. |
G |
| LEAFNEAR |
INTEGER NOT NULL
WITH DEFAULT -1 |
Number of leaf pages physically near previous leaf page for successive active leaf
pages. The value is -1 if statistics have not been gathered. This is an updatable
column. |
S |
| LEAFFAR |
INTEGER NOT NULL
WITH DEFAULT -1 |
Number of leaf pages located physically far away from previous leaf pages for
successive (active leaf) pages accessed in an index scan. The alue is -1 if statistics
have not been gathered. This is an updatable column. |
S |
