SQL Reference

SYSSTAT.TABLES

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 107. 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: 115.

  • -1 or >= 0 (zero)
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: 115

  • -1 or >= 0 (zero)
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: 115

  • -1 or >= 0 (zero)
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: 115

  • -1 or >= 0 (zero)
Yes

Footnotes:

115
A value of -2 can not be changed and a column value can not be directly set to -2.

[ Top of Page | Previous Page | Next Page ]