SYSIBM.SYSTABSTATS table

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

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

Important: Start of changeUse 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.End of change
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 COMPRESS YES. S
STATSTIME
TIMESTAMP
NOT NULL

Start of changeIf 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'. The default value indicates that statistics were not collected. This is an updatable column.End of change

 G
IBMREQD
CHAR(1)
NOT NULL
 A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. 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