SYSTABSTATS catalog table

The SYSTABSTATS table contains one row for each partition of a partitioned table space. The schema is SYSIBM.

Rows in this table can be inserted, updated, and deleted.

Important: Use care when issuing SQL statements or using tools to update statistics values in catalog tables. If such updates introduce invalid data, unpredictable results can occur, including abends for RUNSTATS and other utilities. If such problems occur, you can run the RUNSTATS utility and collect statistics at the table space level to resolve the problems, in most cases.
Table 1. SYSIBM.SYSTABSTATS table column descriptions
Column name Data type Description Use
CARD
INTEGER
NOT NULL
 Total number of rows in the partition. S
NPAGES
INTEGER
NOT NULL
 Total number of pages on which rows of the partition appear. S
PCTPAGES
SMALLINT
NOT NULL
 Percentage of total active pages in the partition that contain rows of the table. S
NACTIVE
INTEGER
NOT NULL
 Number of active pages in the partition. S
PCTROWCOMP
SMALLINT
NOT NULL
 Percentage of rows compressed within the total number of active rows in the partition. This includes any row in a table space that is defined with compression. 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
IBMREQD
CHAR(1)
NOT NULL
 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
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
NOT NULL WITH
DEFAULT -1
 Total number of rows in the partition. S