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.

Table 1. SYSIBM.SYSTABSTATS_HIST table column descriptions
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

Start of changeIf 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.End of change

 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