External table description (QAQQ3001) - Using existing index
Table 1. QQQ3001 - Using existing index 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 Physical table QQILNM Index library QQIFNM Index QQTOTR Total rows in table QQREST Estimated number of rows selected QQFKEY Number of key positioning keys QQKSEL Number of key selection keys QQAJN Join position - when available QQEPT Estimated processing time, in seconds QQJNP Join position - when available QQJNDS Dataspace number QQJNMT Join method - when available NL - Nested loop
MF - Nested loop with selection
HJ - Hash joinQQJNTY Join type - when available IN - Inner join
PO - Left partial outer join
EX - Exception joinQQJNOP Join operator - when available EQ - Equal
NE - Not equal
GT - Greater than
GE - Greater than or equal
LT - Less than
LE - Less than or equal
CP - Cartesian productQQIDXK Number of advised key columns that use index scan-key positioning QQKP Index scan-key positioning Y - Yes
N - NoQQKPN Number of key positioning columns QQKS Index scan-key selection Y - Yes
N - NoQQDSS Dataspace selection Y - Yes
N - NoQQIDXA Index advised Y - Yes
N - NoQQRCOD Reason code I1 - Row selection
I2 - Ordering/Grouping
I3 - Row selection and
Ordering/Grouping
I4 - Nested loop join
I5 - Row selection using
bitmap processingQQCST Constraint indicator Y - Yes
N - NoQQCSTN Constraint name QQLTLN Library-long QQLTFN Table-long QQLPTL Physical library-long QQLPTF Table-long QQLILN Index library – long QQLIFN Index – long QQIDXD Key columns for the index advised QQC11 Materialized query table QQC12 Reserved QQC21 Reserved QQC22 Reserved QQI1 Reserved QQI2 Reserved QQC301 Reserved QQC302 Reserved QQ1000 Reserved
Parent topic:
Memory Resident Database Monitor: DDS