| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| PARTITION |
SMALLINT NOT NULL |
Partition number. 0 if table space is not partitioned. |
G |
| TSNAME |
CHAR(8) NOT NULL |
Name of the table space. |
G |
| DBNAME |
CHAR(8) NOT NULL |
Name of the database that contains the table space. |
G |
| PQTY |
INTEGER NOT NULL |
Primary space allocation in units of 4KB storage blocks. The value of this column is
0 if a storage group is not used. PQTY is based on a value of PRIQTY in the
appropriate CREATE or ALTER TABLESPACE statement. |
G |
| SECQTYI |
INTEGER NOT NULL |
Secondary space allocation in units of 4KB storage. If a storage group is not used,
the value is 0. |
G |
| FARINDREF |
INTEGER NOT NULL
WITH DEFAULT -1 |
Number of rows that have been relocated far from their original page.
The value is -1 if statistics have not been gathered. Not applicable if the table
space is a LOB table space. |
S |
| NEARINDREF |
INTEGER NOT NULL
WITH DEFAULT -1 |
Number of rows that have been relocated near their original page. The value is -1
if statistics have not been gathered. Not applicable if the table space is a LOB table
space. |
S |
| PERCACTIVE |
SMALLINT NOT NULL
WITH DEFAULT -1 |
Percentage of space occupied by rows of data from active tables. The value is -1 if
statistics have not been gathered. The value is -2 if the table space is a LOB table
space. |
S |
| PERCDROP |
SMALLINT NOT NULL
WITH DEFAULT -1 |
Percentage of space occupied by rows of dropped tables. The value is -1 if
statistics have not been gathered. The value is 0 for segmented table spaces. Not
applicable if the table is an auxiliary table. |
S |
| SPACEF |
FLOAT(8) NOT NULL
WITH DEFAULT -1 |
Number of kilobytes of DASD storage allocated to the table space partition. The
value is -1 if statistics have not been gathered. |
G |
| PAGESAVE |
SMALLINT NOT NULL |
Percentage of pages saved in the table space or partition as a result of defining the
table space with COMPRESS YES or other compression routines. For example, a
value of 25 indicates a savings of 25 percent, so that the pages required are only
75 percent of what would be required without data compression. The calculation
includes overhead bytes for each | row, the bytes required for dictionary, and the
bytes required for the current FREEPAGE and PCTFREE specification for the table
space or partition. This calculation is based on an average row length, and the
result varies depending on the actual lengths of the rows. The value is 0 if there
are no savings from using data compression, or if statistics have not been gathered.
The value can be negative, if for example, data compression causes an increase in
the number of pages in the data set. |
S |
| STATSTIME |
TIMESTAMP NOT NULL |
If RUNSTATS updated the statistics, the date and time when the last invocation of
RUNSTATS updated the statistics.
The default value is '0001-01-01-00.00.00.000000'. |
G |
| CARDF |
FLOAT(8) NOT NULL
WITH DEFAULT -1 |
Number of rows in the table space or partition, or if the table space is a LOB table
space, the number of LOBS in the table space. The value is -1 if statistics have not
been gathered. |
G |
| EXTENTS |
INTEGER NOT NULL
WITH DEFAULT -1 |
Number of data set extents. The value is -1 if statistics have not been gathered.
This value is only for the last DSNUM for the object. |
G |
| DSNUM |
INTEGER NOT NULL
WITH DEFAULT -1 |
Data set number within the table space. For partitioned table spaces, this value
corresponds to the partition number for a single partition copy, or 0 for a copy of an
entire partitioned table space or index space. The value is -1 if statistics have not
been gathered. |
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 |
