Description: Contains one row for each partition of a partitioning index or a data-partitioned secondary index (DPSI). Rows in this table can be inserted, updated, and deleted.
Tablespace: SYSSTATS
Indexes(Fields):
DSNTXX01(OWNER.NAME.PARTITION)
| Column name | Description | Data type |
|---|---|---|
| FIRSTKEYCARD | For the index partition, number of distinct values of the first key column. | NOT NULL |
| FULLKEYCARD | For the index partition, number of distinct values of the key. | NOT NULL |
| NLEAF | Number of active leaf pages in the index partition. | NOT NULL |
| NLEVELS | Number of levels in the index tree. | NOT NULL |
| Not used | NOT NULL | |
| Not used | NOT NULL | |
| CLUSTERRATIO | For the index partition, the percentage of rows that are in clustering order. The value is 0 if statistics have not been gathered. | NOT NULL |
| STATSTIME | 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'. | NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL |
| PARTITION | Partition number of the index. | NOT NULL |
| OWNER | Authorization ID of the owner of the index. | NOT NULL |
| NAME | Name of the index. | NOT NULL |
| KEYCOUNT | Total number of rows in the partition. | NOT NULL |
| FIRSTKEYCARDF | For the index partition, number of distinct values of the first key column. | NOT NULL WITH DEFAULT -1 |
| FULLKEYCARDF | For the index partition, number of distinct values of the key. | NOT NULL WITH DEFAULT -1 |
| KEYCOUNTF | Total number of rows in the partition. | WITH DEFAULT -1 |
| CLUSTERRATIOF | For the index partition, the value, when multiplied by 100, is the percentage of rows that are in clustering order. For example, a value of .9125 indicates 91.25%. The value is 0 if statistics have not been gathered. | NOT NULL WITH DEFAULT |
| Internal use only | NOT NULL WITH DEFAULT FOR BIT DATA |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).