Information about the temporary table
created
ID Name Type
Description
2510
QQTMPR
BIN(32) Number of
rows in table created.
2512 QVTTSIZ
BIN(32) Size, in
bytes, of table created.
2514 QVTTRSZ
BIN(32) Row size, in
bytes, of table created.
2516 QQDFVL
CHAR(1) Default
values in table created.
Y - Yes
N - No
2518
QVTTRST
CHAR(1) Temporary
result table created.
Y - Yes
N - No
2520
QVTDSTB
CHAR(10) Distributed table
created.
Y - Yes
N - No
2522
QVTNODS
CHAR(10) Nodes of
distributed table created.
2524 QVTTRC
CHAR(2) Reason code
why temporary table was
created. Possible values are:
F1 - Query contains grouping columns
(GROUP BY) from more that one
table, or contains grouping
columns from a secondary table
of a join query that cannot be
reordered.
F2 - Query contains ordering columns
(ORDER BY) from more that one
table, or contains ordering
columns from a secondary table
of a join query that cannot be
reordered.
F3 - The grouping and ordering
columns are not compatible.
F4 - DISTINCT was specified for the
query.
F5 - UNION was specified for the query.
F6 - Query had to be implemented
using a sort. Key length of
more than 2000 bytes or more
than 120 key columns specified
for ordering.
F7 - Query optimizer chose to use a
sort rather than an index to order
the results of the query.
F8 - Perform specified row selection
to minimize I/O wait time.
F9 - The query optimizer chose to use a
hashing algorithm rather than an
index to perform the grouping.
FA - The query contains a join condition
that requires a temporary file.
H1 - Table is a join logical file and its
join type does not match the join
type specified in the query.
H2 - Format specified for the
logical table references more
than one base table.
H3 - Table is a complex SQL view
requiring a temporary table to
contain the the results of the
SQL view.
H4 - For an update-capable query, a
subselect references a column in
this table which matches one of the
columns being updated.
H5 - For an update-capable query, a
subselect references an SQL view
which is based on the table being
updated.
H6 - For a delete-capable query, a
subselect references either:
- the table from which rows are to
be deleted
- an SQL view, or
- an index based on the table from
which rows are to be deleted