Contains one row for each table. Views or aliases are, therefore,
not included.
Table 119. SYSSTAT.TABLES Catalog View
| Column Name | Data Type | Nullable | Description | Updatable |
|---|---|---|---|---|
| TABSCHEMA | CHAR(8) |
| Qualified name of the table. |
|
| TABNAME | VARCHAR(18) |
|
| |
| CARD | INTEGER |
| 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:
| Yes |
| NPAGES | INTEGER |
| Total number of pages on which the rows of the table exist; -1
if statistics are not gathered; -2 for a subtable. (8)
This column can only be updated with the following values:
| Yes |
| FPAGES | INTEGER |
| Total number of pages in the file; -1 if statistics are not
gathered; -2 for a subtable. (8)
This column can only be updated with the following values:
| Yes |
| OVERFLOW | INTEGER |
| Total number of overflow records in the table; -1 if
statistics are not gathered; -2 for a subtable. (8)
This column can only be updated with the following values:
| Yes |
(8) A value of -2 indicates a subtable. A value of -2 is set by the database manager, and cannot be updated with another value. The value of this column cannot be updated with the value -2.