Information about the temporary index
created
ID Name Type
Description
2402
QQRIDX
BIN(32) Number of
entries in index created.
2404 QVTIXPZ
BIN(32) Page size of
index created.
2406 QVTIXRZ
BIN(32) Row size of
index created.
2408 QVTIXACF
CHAR(1) Alternate
Collating Sequence (ACS) table used.
Y - Yes
N - No
2409
QVTIXACS
CHAR(10) ACS table
name.
2410
QVTIXACL
CHAR(10) ACS schema.
2412
QVTIXRU
CHAR(1) Index
created is reusable.
Y - Yes
N - No
2414
QVTIXSP
CHAR(1) Index
created is sparse.
Y - Yes
N - No
2416
QVTIXTY
CHAR(1) Type of
index created. Possible values are:
B - Binary Radix
E - Encoded Vector Index (EVI)
2418 QVTIXPO
CHAR(1) Index
created is permanent object.
Y - Yes
N - No
2420
QVTIXFX
CHAR(1) Index
created from existing index.
Y - Yes
N - No
2422
QVTIXPD
BIN(32) Parallel
degree requested for index created.
2424 QVTIXPU
BIN(32) Parallel
degree used during index created.
2426 QVTIXPRC
BIN(32) Parallel
degree reason code for index created.
2428 QVTIXRC
BIN(32) Reason code
why index was created.
Possible values are:
1 - Perform specified ordering or grouping.
2 - Perform specified join criteria.
3 - Perform specified query selection to
minimize I/O wait time.
2430 QQCRTK
VARCHAR(300) Key columns of index created.