SYSTABLES_HIST catalog table
The SYSTABLES_HIST table contains rows from the SYSTABLES 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 |
|---|---|---|---|
| NAME | VARCHAR(128)
NOT NULL |
Name of the table, view, or alias. | G |
| CREATOR | VARCHAR(128)
NOT NULL |
The schema of the table, view, or alias. | G |
| DBNAME | VARCHAR(24)
NOT NULL |
For a table, or a view of tables, the name of the database that contains the table space named in TSNAME. For a temporary table, an alias, or a view of a view, the value is DSNDB06. | G |
| TSNAME | VARCHAR(24)
NOT NULL |
For a table, or a view of one table, the name of the table space that contains the table. For a view of more than one table, the name of a table space that contains one of the tables. For a temporary table, a view of a view, or an alias, it is SYSTSTAB. | G |
| COLCOUNT | SMALLINT
NOT NULL |
Number of columns in the table or view. The value is 0 if the row describes an alias. | G |
| PCTPAGES | SMALLINT
NOT NULL WITH DEFAULT -1 |
Percentage of active table space pages that contain rows of the table. A page is termed active if it is formatted for rows, regardless of whether it contains any. If the table space is segmented, the percentage is based on the number of active pages in the set of segments assigned to the table. The value is -1 if statistics have not been gathered, or the row describes a view, alias, temporary table, accelerator-only table, or auxiliary table. | S |
| PCTROWCOMP | SMALLINT
NOT NULL WITH DEFAULT -1 |
Percentage of rows compressed within the total number of active rows in the table. This includes any row in a table space that is defined with compression. The value is -1 if statistics have not been gathered, or the row describes a view, alias, temporary table, accelerator-only table, or auxiliary table. | G |
| STATSTIME | TIMESTAMP
NOT NULL |
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. For a temporary table, the value of STATSTIME is always the default value. |
G |
| CARDF | FLOAT(8)
NOT NULL WITH DEFAULT -1 |
Total number of rows in the table or total number of LOBs in an auxiliary table. The value is -1 if statistics have not been gathered or the row describes a view, alias, accelerator-only table, or temporary table. | S |
| NPAGESF | FLOAT(8)
NOT NULL WITH DEFAULT -1 |
Total number of pages on which rows of the partition appear. The value is -1 if statistics have not been gathered. | S |
| AVGROWLEN | INTEGER
NOT NULL WITH DEFAULT -1 |
Average row length of the table specified in the table space. The value is -1 if statistics have not been gathered. | G |
| SPACEF | FLOAT(8)
NOT NULL WITH DEFAULT -1 |
Kilobytes of DASD storage. The value is -1 if statistics have not been gathered. This is an updatable column. | 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 |