| Nome da coluna |
Tipo de dados |
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 containing the table space. |
G |
| IXNAME |
VARCHAR(8) NOT NULL |
Name of the partitioned index. This column is blank if the table space is
not partitioned. |
G |
| IXCREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of the partitioned index. This column is
blank if the table space is not partitioned. |
G |
| PQTY |
INTEGER NOT NULL |
Primary space allocation in units of 4KB storage blocks.
For user-managed data sets, the value is set to the primary space
allocation only if RUNSTATS TABLESPACE with UPDATE(ALL) or
UPDATE(SPACE) is executed; otherwise, the value is zero. PQTY is based
on a value of PRIQTY in the appropriate CREATE or ALTER TABLESPACE
statement. Unlike PQTY, however, PRIQTY asks for space in 1KB units. |
G |
| SQTY |
SMALLINT NOT NULL |
Secondary space allocation in units of 4KB blocks. For user-managed
data sets, the value is set to the secondary space allocation only if
RUNSTATS TABLESPACE with UPDATE(ALL) or UPDATE(SPACE) is
executed; otherwise, the value is zero. SQTY is based on a value of
SECQTY in the appropriate CREATE or ALTER TABLESPACE statement.
Unlike SQTY, however, SECQTY asks for space in 1KB units. |
G |
| STORTYPE |
CHAR(1) NOT NULL |
Type of storage allocation:
E Explicit (storage group not used)
I Implicit (storage group used) |
G |
| STORNAME |
CHAR(8) NOT NULL |
Name of storage group used for space allocation. Blank if storage group
not used. |
G |
| VCATNAME |
CHAR(8) NOT NULL |
Name of integrated catalog facility catalog used for space allocation. |
G |
| CARD |
INTEGER NOT NULL |
Number of rows in the table space or partition. The value is 2147483647
if the number of rows is greater than or equal to 2147483647.
The value is -1 if statistics have not been gathered. |
G |
| FARINDREF |
INTEGER NOT NULL |
Number of rows that have been relocated far from their original page.
The value is -1
if statistics have not been gathered. |
G |
| NEARINDREF |
INTEGER NOT NULL |
Number of rows that have been relocated near their original page. The
value is -1 if
statistics have not been gathered. |
S |
| PERCACTIVE |
SMALLINT NOT NULL |
Percentage of space occupied by rows of data from active tables. The
value is -1 if statistics have not been gathered. |
S |
| PERCDROP |
SMALLINT NOT NULL |
Percentage of space occupied by rows of dropped tables. The value is -1
if statistics have not been gathered. 0 for segmented table spaces. |
S |
| IBMREQD |
CHAR(1) NOT NULL |
Whether the row came from the basic machine-readable material
(MRM) tape:
N No
Y Yes |
G |
| LIMITKEY |
VARCHAR(512) NOT NULL |
The high value of the partition in external format. 0 if the table space is
not partitioned. |
G |
| FREEPAGE |
SMALLINT NOT NULL |
The number of pages loaded before a page is left as free space. |
G |
| PCTFREE |
SMALLINT NOT NULL |
The percentage of each page left as free space. |
G |
| CHECKFLAG |
CHAR(1) NOT NULL
WITH DEFAULT |
C
the table space partition is in a check pending state and there
are rows in the table that can violate referential constraints,
table check constraints, or both.
blank The table space is not a partition, or does not contain rows that
may violate referential constraints, table check constraints, or
both. |
G |
| |
CHAR(4) NOT NULL
WITH DEFAULT FOR BIT DATA |
Not used |
N |
| SPACE |
CHAR(8) NOT NULL |
Number of kilobytes of DASD storage allocated to the table space
partition, as determined by the last execution of the STOSPACE or
RUNSTATS utility. The value is 0 if STOSPACE or RUNSTATS has not
been run. The value is updated by STOSPACE if the table space is
related to a storage group. The value is updated by RUNSTATS if the
utility is executed as RUNSTATS TABLESPACE with UPDATE(ALL) or
UPDATE(SPACE). |
G |
| COMPRESS |
CHAR(1) NOT NULL
WITH DEFAULT |
Indicates the following:
° For a table space partition, whether the COMPRESS attribute for the
partition is YES.
° For a nonpartitioned table space, whether the COMPRESS attribute is
YES for the table space.
Values for the column can be:
blank No compression
Y
Compression is defined for the table space
|
G |
| PAGESAVE |
SMALLINT NOT NULL
WITH DEFAULT |
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. |
G |
| STATSTIME |
TIMESTAMP NOT NULL
WITH DEFAULT |
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 |
| GBPCACHE |
CHAR(1) NOT NULL
WITH DEFAULT |
Group buffer pool cache option specified for this table space or table
space partition.
blank Only changed pages are cached in the group buffer pool.
A
Changed and unchanged pages are cached in the group buffer
pool. |
G |
| CHECKRID5B |
CHAR(5) NOT NULL
WITH DEFAULT |
Blank if the table or partition is not in a check pending state
(CHECKFLAG is blank), or if the table space is not partitioned. Otherwise,
the RID of the first row of the table space partition that can violate
referential constraints, table check constraints, or both; or the value is
X'0000000000', indicating that any row can violate referential constraints. |
G |
