SYSTABSTATS_HIST catalog table
The SYSTABSTATS_HIST table contains rows from the SYSTABSTATS table.
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 |
|---|---|---|---|
| NPAGES | INTEGER
NOT NULL |
Total number of pages on which rows of the partition appear. | S |
| STATSTIME | TIMESTAMP
NOT NULL |
|
G |
| DBNAME | VARCHAR(24)
NOT NULL |
Database that contains the table space named in TSNAME. | G |
| TSNAME | VARCHAR(24)
NOT NULL |
Table space that contains the table. | G |
| PARTITION | SMALLINT
NOT NULL |
Partition number of the table space that contains the table. | G |
| OWNER | VARCHAR(128)
NOT NULL |
The schema of the table. | G |
| NAME | VARCHAR(128)
NOT NULL |
Name of the table. | G |
| CARDF | FLOAT(8)
NOT NULL WITH DEFAULT -1 |
Total number of rows in the partition. The value is -1 if statistics have not been gathered. | S |
| 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 |
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.