| Nome da coluna |
Tipo de dados |
Descrição |
Uso |
| PARTITION |
SMALLINT NOT NULL |
Partition number; 0 if index is not partitioned. |
G |
| IXNAME |
VARCHAR(18) NOT NULL |
Name of the index. |
G |
| IXCREATOR |
VARCHAR(8) NOT NULL |
Authorization ID of the owner of the index. |
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 INDEX with UPDATE(ALL) or UPDATE
(SPACE) is executed; otherwise, the value is zero. |
G |
| SQTY |
SMALLINT NOT NULL |
Secondary space allocation in units of 4KB storage blocks.
For user-managed data sets, the value is set to the secondary space
allocation only if RUNSTATS INDEX with UPDATE(ALL) or UPDATE
(SPACE) is executed; otherwise, the value is zero. |
G |
| STORTYPE |
CHAR(1) NOT NULL |
Type of storage allocation:
E explicit and STORNAME names an integrated catalog facility catalog
I implicit and STORNAME names a storage group |
G |
| STORNAME |
CHAR(8) NOT NULL |
Name of storage group or integrated catalog facility catalog used for
space allocation. |
G |
| VCATNAME |
CHAR(8) NOT NULL |
Name of integrated catalog facility catalog used for space allocation. |
G |
| |
INTEGER NOT NULL |
Not used |
S |
| |
INTEGER NOT NULL |
Not used |
S |
| LEAFDIST |
INTEGER NOT NULL |
100 times the average number of leaf pages between successive active
leaf pages of the index. The value is -1 if statistics have not been
gathered. |
G |
| |
INTEGER NOT NULL |
Not used |
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 FOR BIT DATA
|
The high value of the limit key of the partition in an internal format. 0 if
the index is not partitioned.
If any column of the key has a field procedure, the internal format is the
encoded form of the value. |
S |
| FREEPAGE |
SMALLINT NOT NULL |
The number of pages that are loaded before a page is left as free space. |
G |
| PCTFREE |
SMALLINT NOT NULL |
The percentage of each subpage or nonleaf page that is left as free
space. |
G |
| SPACE |
INTEGER NOT NULL
WITH DEFAULT |
Number of kilobytes of DASD storage allocated to the index 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 index is related to a storage group. The
value is updated by RUNSTATS if the utility is executed as RUNSTATS
INDEX with UPDATE(ALL) or UPDATE(SPACE). |
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 |
| |
CHAR(1) NOT NULL |
Not used |
N |
| GBPCACHE |
CHAR(1) NOT NULL
WITH DEFAULT |
Group buffer pool cache option specified for this index or index
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 |
| FAROFFPOSF |
FLOAT NOT NULL
WITH DEFAULT -1 |
Number of referred to rows far from optimal position because of an insert
into a full page. The value is -1 if statistics have not been gathered. |
S |
| NEAROFFPOSF |
FLOAT NOT NULL
WITH DEFAULT -1 |
Number of referred to rows near, but not at optimal position, because of
an insert into a full page. |
S |
| CARDF |
FLOAT NOT NULL
WITH DEFAULT -1 |
Number of rows referred to by the index or partition. The value is -1 if
statistics have not been gathered. |
S |
