External table description (QAQQ3003) - Query sort

 

Table 1. QQQ3003 - Query sort
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
QQTTIM Sort time
QQRSS Number of rows selected or sorted
QQSIZ Size of sort space
QQPSIZ Pool size
QQPID Pool id
QQIBUF Internal sort buffer length
QQEBUF External sort buffer length
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.

  • FC - The query contains grouping fields and there is a read trigger on at least one of the physical files in the query.
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