| Nome da coluna |
Tipo de dados |
Descrição |
Uso |
| NAME |
VARCHAR(18) NOT NULL |
Name of the index. |
G |
| CREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of the index |
G |
| TBNAME |
VARCHAR(18) NOT NULL |
Name of the table on which the index is defined. |
G |
| TBCREATOR |
VARCHAR(8) NOT NULL |
Authorization ID of the owner of the table. |
G |
| UNIQUERULE |
CHAR(1) NOT NULL |
Whether the index is unique:
D No (duplicates are allowed)
U Yes
P Yes, and it is a primary index (As in prior releases of DB2, a value of
P is used for primary keys that are used to enforce a referential
constraint.)
C Yes, and it is an index used to enforce UNIQUE constraint
N Yes, and it is defined with UNIQUE WHERE NOT NULL
R Yes, and it is an index used to enforce the uniqueness of a non-
primary parent key
|
G |
| COLCOUNT |
SMALLINT NOT NULL |
The number of columns in the key. |
G |
| CLUSTERING |
CHAR(1) NOT NULL |
Whether CLUSTER was specified when the index was created:
N No
Y Yes |
G |
| CLUSTERED |
CHAR(1) NOT NULL |
Whether the table is actually clustered by the index:
N No: a significant number of rows are not in clustering order, or
statistics were not gathered.
Y Yes: most of the rows are in clustering order.
The entry can be changed by the changed by the RUNSTATS utility. |
G |
| DBID |
SMALLINT NOT NULL |
Internal identifier of the database. |
S |
| OBID |
SMALLINT NOT NULL |
Internal identifier of the index fan set descriptor. |
G |
| ISOBID |
SMALLINT NOT NULL |
Internal identifier of the index page set descriptor. |
S |
| DBNAME |
CHAR(8) NOT NULL |
Name of the database that contains the index. |
G |
| INDEXSPACE |
CHAR(8) NOT NULL |
Name of the index space. |
G |
| |
INTEGER NOT NULL |
Not used |
N |
| |
INTEGER NOT NULL |
Not used |
N |
| NLEAF |
INTEGER NOT NULL |
Number of active leaf pages in the index. The value is -1 before statistics
are gathered. This is an updateable column. |
S |
| NLEVELS |
SMALLINT NOT NULL |
Number of levels in the index tree. If the index is partitioned, it is the
maximum of the number of levels in the index tree for all the partitions.
Before statistics are gathered, the value is -1. This is an updateable column. |
G |
| BPOOL |
CHAR(8) NOT NULL |
Name of the buffer pool used for the index. |
G |
| PGSIZE |
SMALLINT NOT NULL |
Size, in bytes, of the subpages in the index: 256, 512, 1024, 2048 or 4096 |
G |
| ERASERULE |
CHAR(1) NOT NULL |
Whether the data sets are erased when dropped. The value is
meaningless if the index is partitioned.
N No
Y Yes |
G |
| DSETPASS |
CHAR(8) NOT NULL |
The password for the data sets of the index. |
G |
| CLOSERULE |
CHAR(1) NOT NULL |
Whether the data sets are candidates for closure when the limit on the
number of open data sets is reached.
N No
Y Yes |
G |
| SPACE |
INTEGER NOT NULL |
Number of kilobytes of DASD storage allocated to the index, as
determined by the last execution of the STOSPACE utility. The value is 0
if the index is not related to a storage group, or if STOSPACE has not
been run. If the index space is partitioned, the value is the total kilobytes
of DASD storage allocated to all partitions that are defined in a storage
group. |
G |
| IBMREQD |
CHAR(1) NOT NULL |
Whether the row came from the basic machine-readable material (MRM) tape:
N No
Y Yes
C V2R1 dependency indicator; not from MRM tape
D V2R2 dependency indicator; not from MRM tape
E V2R3 dependency indicator; not from MRM tape
G V4 dependency indicator; not from MRM tape |
G |
| CLUSTERRATIO |
SMALLINT NOT NULL
WITH DEFAULT
|
Percentage of rows that are in clustering order. For a partitioned index,
it is the weighted average of all index partitions in terms of the number
if rows in the partition. 0 before statistics are gathered. This column is
updateable. |
G |
CREATEDBY NOT NULL
WITH DEFAULT |
CHAR(8) |
Primary authorization ID of the user who created the index. |
G |
| |
SMALLINT NOT NULL |
Internal use only |
I |
| |
SMALLINT NOT NULL |
Not used |
N |
| 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'. This is an updateable column. |
G |
| INDEXTYPE |
CHAR(1) NOT NULL
WITH DEFAULT |
The index type.
2 Type 2 index
blank Type 1 index |
G |
FIRSTKEYCARDF
|
FLOAT NOT NULL
WITH DEFAULT -1 |
Number of distinct values of the first key column. This number is an
estimate if updated while collecting statistics on a single partition. The
value is -1 before statistics are gathered. This is an updateable column. |
S |
| FIRSTKEYCARDF |
FLOAT NOT NULL
WITH DEFAULT -1 |
Number of distinct values of the first key column. This number is an
estimate if updated while collecting statistics on a single partition. The
value is -1 before statistics are gathered. This is an updateable column. |
S |
| FULLKEYCARDF |
FLOAT NOT NULL
WITH DEFAULT -1 |
Number of distinct values of the key. The value is -1 before statistics are
gathered. This is an updateable column. |
S |
| CREATEDTS |
TIMESTAMP NOT NULL
WITH DEFAULT |
Time when the CREATE statement was executed for the index. If the
index was created in a DB2 release prior to Version 5, the value is
'0001-01-01.00.00.00.000000'. |
G |
| ALTEREDTS |
TIMESTAMP NOT NULL
WITH DEFAULT |
Time when the most recent ALTER INDEX statement was executed for
the index. If no ALTER INDEX statement has been applied, ALTEREDTS
has the value of CREATEDTS. If the index was created in a DB2 release
prior to Version 5, the value is '0001-01-01.00.00.00.000000'. |
G |
| PIECESIZE |
INTEGER NOT NULL
WITH DEFAULT |
Maximum size of a data set storage piece (in kilobytes, KB) that will be
used by DB2 for non-partitioned indexes.
The value of this column is one of the following:
256
512
1024
2048
4096
8192
16384
32768
65536
131072
262144
524288
1048576
2097152
4194304
0
The value of zero (0) indicates that this index is a partitioning index or
that this index was created in a DB2 release prior to Version 5. |
G |
