Contains one row for each base table. Views or aliases are,
therefore, not included. For typed tables, only the root table of a
table hierarchy is included in this view. Statistics are not recorded for inherited columns of typed
tables. The CARD value applies to the root table only while the other
statistics apply to the entire table hierarchy.
Table 127. SYSSTAT.TABLES Catalog View
| Column Name | Data Type | Nullable | Description | Updatable |
|---|---|---|---|---|
| TABSCHEMA | VARCHAR(128) |
| Qualified name of the table. |
|
| TABNAME | VARCHAR(128) |
|
| |
| CARD | BIGINT |
| Total number of rows in the table; -1 if statistics are not
gathered.
An update to CARD for a table should not attempt to assign it a value less than the COLCARD value of any of the columns in that table. This column can only be updated with the following values: 5.
| Yes |
| NPAGES | INTEGER |
| Total number of pages on which the rows of the table exist; -1
if statistics are not gathered; -2 for subtables and
H-tables.
This column can only be updated with the following values: 5
| Yes |
| FPAGES | INTEGER |
| Total number of pages in the file; -1 if statistics are not
gathered; -2 for subtables and H-tables.
This column can only be updated with the following values: 5
| Yes |
| OVERFLOW | INTEGER |
| Total number of overflow records in the table; -1 if
statistics are not gathered; -2 for subtables and H-tables.
This column can only be updated with the following values: 5
| Yes |