External table description (QAQQ3007) - Optimizer information

 

Table 1. QQQ3007 - Optimizer information

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
QQPTLN	Physical library
QQPTFN	Table
QQTOUT	Optimizer timed out Y - Yes N - No.
QQIRSN	Reason code
QQLTLN	Library-long
QQLTFN	Table-long
QQPTL	Physical library-long
QQPTF	Table-long
QQIDXN	Index names
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