SYSTABLEPART_HIST catalog table
The SYSTABLEPART_HIST table contains rows from the SYSTABLEPART table. The schema is SYSIBM.
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 |
|---|---|---|---|
| PARTITION | SMALLINT
NOT NULL |
Partition number. 0 if table space is not partitioned. | G |
| TSNAME | VARCHAR(24)
NOT NULL |
Name of the table space. | G |
| DBNAME | VARCHAR(24)
NOT NULL |
Name of the database that contains the table space. | G |
| PQTY | INTEGER
NOT NULL |
For user-managed data sets, the value
is the primary space allocation in units of 4 KB storage blocks or
-1. For user-specified values of PRIQTY other than -1, the value is set to the primary space allocation only if RUNSTATS TABLESPACE with UPDATE(ALL) or UPDATE(SPACE) is executed; otherwise, the value is zero. PQTY is based on a value of PRIQTY in the appropriate CREATE or ALTER TABLESPACE statement. Unlike PQTY, however, PRIQTY asks for space in 1 KB units. A value of -1 indicates that either of the following cases is true:
If a storage group is not used, the value is 0. |
G |
| SECQTYI | INTEGER
NOT NULL |
For user-managed data sets, the value
is the secondary space allocation in units of 4 KB storage blocks
or -1. For user-specified values of SECQTY other than -1, the value is set to the secondary space allocation only if RUNSTATS TABLESPACE with UPDATE(ALL) or UPDATE(SPACE) is executed; otherwise, the value is zero. SQTY is based on a value of SECQTY in the appropriate CREATE or ALTER TABLESPACE statement. Unlike SQTY, however, SECQTY asks for space in 1 KB units. A value of -1 indicates that either of the following cases is true:
If a storage group is not used, the value is 0. |
G |
| FARINDREF | INTEGER
NOT NULL WITH DEFAULT -1 |
Number of rows that have been relocated far from their original page. The value is -1 if statistics have not been gathered. Not applicable if the table space is a LOB table space. | S |
| NEARINDREF | INTEGER
NOT NULL WITH DEFAULT -1 |
Number of rows that have been relocated near their original page. The value is -1 if statistics have not been gathered. Not applicable if the table space is a LOB table space. | S |
| PERCACTIVE | SMALLINT
NOT NULL WITH DEFAULT -1 |
Percentage of space occupied by rows of data from active tables. The value is -1 if statistics have not been gathered. The value is -2 if the table space is a LOB table space. | S |
| PERCDROP | SMALLINT
NOT NULL WITH DEFAULT -1 |
Percentage of space occupied by rows of dropped tables. The value is -1 if statistics have not been gathered. The value is 0 for segmented table spaces. Not applicable if the table is an auxiliary table. | S |
| SPACEF | FLOAT(8)
NOT NULL WITH DEFAULT -1 |
Number of kilobytes of DASD storage allocated to the table space partition. The value is -1 if statistics have not been gathered. | G |
| PAGESAVE | SMALLINT
NOT NULL |
Percentage of pages saved in the table space or partition as a result of defining the table space with compression. For example, a value of 25 indicates a savings of 25 percent, so that the pages required are only 75 percent of what would be required without data compression. The calculation includes overhead bytes for each row, the bytes required for dictionary, and the bytes required for the current FREEPAGE and PCTFREE specification for the table space or partition. This calculation is based on an average row length, and the result varies depending on the actual lengths of the rows. The value is 0 if there are no savings from using data compression, or if statistics have not been gathered. The value can be negative, if for example, data compression causes an increase in the number of pages in the data set. |
S |
| STATSTIME | TIMESTAMP
NOT NULL |
|
G |
| CARDF | FLOAT(8)
NOT NULL WITH DEFAULT -1 |
Number of rows in the table space or partition, or if the table space is a LOB table space, the number of LOBS in the table space. The value is '-1' if statistics have not been gathered. | S |
| EXTENTS | INTEGER
NOT NULL WITH DEFAULT -1 |
Number of data set extents. The value is '-1' if statistics have not been gathered. This value is only for the last DSNUM for the object. | G |
| DSNUM | INTEGER
NOT NULL WITH DEFAULT -1 |
Data set number within the table space. For partitioned table spaces, this value corresponds to the partition number for a single partition copy, or 0 for a copy of an entire partitioned table space or index space. The value is '-1' if statistics have not been gathered. | G |
| 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 |
| AVGROWLEN | INTEGER
NOT NULL WITH DEFAULT -1 |
Average length of rows for the tables in the table space or part. If the table space or part is compressed, the value is the compressed row length. If the table space or part is not compressed, the value is the uncompressed row length. The value is '-1' if statistics have not been gathered. | 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.