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. The CARD value applies to the root table only while the other statistics apply to the entire table hierarchy.
| Note: | Summary tables are not included in this view for Version 5.2. If updating statistics for a summary table, use the OBJSTAT.TABLES view (see Appendix E. Catalog Views For Use With Structured Types for how to define this view). |
Table 76. 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.
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.
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.
This column can only be updated with the following values:
| Yes |