External table description (QAQQ3004) - Temporary table

 

Table 1. QQQ3004 - Temporary table
Column Name Description
QQKEY Join column (unique per query) used to link rows for a single query together
QQTIME Time row was created
QQQDTN QDT number (unique per QDT)
QQQDTL RQDT subquery nested level relational database name
QQMATN Materialized view QDT number
QQMATL Materialized view nested level
QQTLN Library
QQTFN Table
QQTTIM Temporary table create time
QQTMPR Number of rows in temporary
QQRCOD Reason code

  • F1 - Query contains grouping columns (Group By) from more than 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 than 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 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 access path to perform the grouping for the query.

  • FA - The query contains a join condition that requires a temporary file.

  • FB - The query optimizer creates a run-time temporary file in order to implement certain correlated group by queries.

  • FC - The query contains grouping fields and there is a read trigger on at least one of the physical files in the query.

  • FD - The query optimizer creates a runtime temporary file for a static-cursor request.

  • 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 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.

  • H7 - A user-defined table function was materialized.
QQDFVL Default values may be present in temporary

Y - Yes
N - No

QQLTLN Library-long
QQLTFN Table-long
QQC11 Reserved
QQC12 Reserved
QQC21 Reserved
QQC22 Reserved
QQI1 Reserved
QQI2 Reserved
QQC301 Reserved
QQC302 Reserved
QQ1000 Reserved

 

Parent topic:

Memory Resident Database Monitor: DDS