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.
| 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 |
|
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 |
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.