SYSINDEXPART_HIST catalog table
The SYSINDEXPART_HIST catalog table contains rows from SYSINDEXPART. The schema is SYSIBM.
Rows are added or changed in this table when RUNSTATS collects history statistics. Rows in this table can also be inserted, updated, and deleted.
| Column name | Data type | Description | Use |
|---|---|---|---|
| PARTITION | SMALLINT
NOT NULL |
Partition number. Zero if index is not partitioned. | G |
| IXNAME | VARCHAR(128)
NOT NULL |
Name of the index. | G |
| IXCREATOR | VARCHAR(128)
NOT NULL |
The schema of the index. |
G |
| PQTY | INTEGER NOT NULL
|
For user-managed data sets, the
value is the primary space allocation in units of 4KB storage blocks
or -1. For user-specified values of PRIQTY other than -1, the value is set to the primary space allocation only if RUNSTATS INDEX with UPDATE(ALL) or UPDATE(SPACE) is executed; otherwise, the value is zero. PQTY is based on a value of PRIQTY in the appropriate CREATE or ALTER INDEX statement. Unlike PQTY, however, PRIQTY asks for space in 1KB units. A value of -1 indicates that either of the following cases is true:
If a storage group is not used, the value is 0. |
G |
| SECQTYI | INTEGER
NOT NULL |
For user-managed data sets, the
value is the secondary space allocation in units of 4KB storage blocks
or -1. For user-specified values of SECQTY other than -1, the value is set to the secondary space allocation only if RUNSTATS INDEX with UPDATE(ALL) or UPDATE(SPACE) is executed; otherwise, the value is zero. SQTY is based on a value of SECQTY in the appropriate CREATE or ALTER INDEX statement. Unlike SQTY, however, SECQTY asks for space in 1KB units. A value of -1 indicates that either of the following cases is true:
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 |
|
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. For a sparse index, the statistic is based on the actual contents of the index. |
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. For a sparse index, the statistic is based on the actual contents of the index. |
S |
| CARDF | FLOAT(8)
NOT NULL WITH DEFAULT -1 |
Number
of RIDs in the index that refer to data rows or LOBs. The value is
-1 if statistics have not been gathered. For a sparse index, the statistic is based on the actual contents of the index. |
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_
ENTRIES |
INTEGER
NOT NULL WITH DEFAULT -1 |
Number of pseudo 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 was provided with the Db2 product code. For all other values, see Release dependency indicators. The value in this field is not a reliable indicator of release dependencies. |
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 value is -1 if statistics have not been gathered. This is an updatable column. | S |
| AVGKEYLEN | INTEGER
NOT NULL WITH DEFAULT -1 |
Average length of keys within the index. The value
is -1 if statistics have not been gathered. For a sparse index, the statistic is based on the actual contents of the index. |
G |
If RUNSTATS or another utility with inline statistics updated the statistics, the date and time when the last utility invocation updated the statistics. The default value is '0001-01-01-00.00.00.000000'. The default value indicates that statistics were not collected. This column can be updated.