| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| NAME |
VARCHAR(18) NOT NULL |
Name of the table, view, or alias. |
G |
| CREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of the table, view, or alias. |
G |
| DBNAME |
CHAR(8) 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 |
CHAR(8) 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, the value is SYSPKAGE. For a view of a
view, the value is SYSVIEWS. For an alias, it is SYSDBAUT. |
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, 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 COMPRESS YES. The
value is -1 if statistics have not been gathered, or the row describes a view, alias,
temporary table, or auxiliary table. |
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,
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 came from the basic machine-readable material
(MRM) tape. For all other values, see Release dependency indicators in topic D.0. |
G |
