| Nome da coluna |
Tipo de dados |
Descrição |
Uso |
| CARD |
INTEGER NOT NULL |
Total number of rows in the partition. This is an updatable column. |
S |
| NPAGES |
INTEGER NOT NULL |
Total number of pages on which rows of the partition appear. This is an
updatable column. |
S |
| PCTPAGES |
SMALLINT NOT NULL |
Percentage of total active pages in the partition that contain rows of the
table. This is an updatable column. |
S |
| NACTIVE |
INTEGER NOT NULL |
Number of active pages in the partition. This is an updatable column. |
S |
| PCTROWCOMP |
SMALLINT NOT NULL |
Percentage of rows compressed within the total number of active rows in
the partition. This includes any row in a table space that is defined with
COMPRESS YES. This is an updatable column. |
S |
| STATSTIME |
TIMESTAMP NOT NULL |
If RUNSTATS updated the statistics, the date and time when the last
invocation of RUNSTATS updated the statistics. This is an updatable
column. |
G |
| IBMREQD |
CHAR(1) NOT NULL |
Whether the row came from the basic machine-readable material (MRM)
tape.
N No
Y Yes |
G |
| DBNAME |
CHAR(8) NOT NULL |
Database that contains the table space named in TSNAME. |
G |
| TSNAME |
CHAR(8) NOT NULL |
Table space that contains the table. |
G |
| PARTITION> |
SMALLINT NOT NULL |
Partition number of the table space that contains the table. |
G |
| OWNER |
CHAR(8) NOT NULL |
Authorization ID of the owner of the table. |
G |
| NAME |
VARCHAR(18) NOT NULL |
Name of the table. |
G |
