Database monitor logical table 3008 - Summary Row for Subquery Processing

|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
     A*
     A* DB Monitor logical table 3008 - Summary Row for Subquery Processing 
     A* 
     A          R QQQ3008                   PTABLE(*CURLIB/QAQQDBMN) 
     A            QQRID 
     A            QQTIME 
     A            QQJFLD 
     A            QQRDBN 
     A            QQSYS 
     A            QQJOB 
     A            QQUSER 
     A            QQJNUM 
     A            QQTHRD                    RENAME(QQI9) + 
                                            COLHDG('Thread' + 
                                                   'Identifier') 
     A            QQUCNT 
     A            QQUDEF 
     A            QQQDTN 
     A            QQQDTL 
     A            QQMATN 
     A            QQMATL
     A            QQORGQ                    RENAME(QQI1) + 
                                            COLHDG('Original' +
                                                   'Number' +    
                                                   'of QDTs')
     A            QQMRGQ                    RENAME(QQI2) + 
                                            COLHDG('Number' +
                                                   'of QDTs' +    
                                                   'Merged')
     A* 
     A* Columns added for Visual Explain
     A*
     A            QQFNLQ                    RENAME(QQI3) + 
                                            COLHDG('Final' +
                                                   'Number' +    
                                                   'of QDTs')
     A            QVRCNT
     A          K QQJFLD 
     A          S QQRID                     CMP(EQ 3008)

Table 21. QQQ3008 - Summary Row for Subquery Processing

Logical Column Name	Physical Column Name	Description
QQRID	QQRID	Row identification
QQTIME	QQTIME	Time row was created
QQJFLD	QQJFLD	Join column (unique per job)
QQRDBN	QQRDBN	Relational database name
QQSYS	QQSYS	System name
QQJOB	QQJOB	Job name
QQUSER	QQUSER	Job user
QQJNUM	QQJNUM	Job number
QQTHRD	QQI9	Thread identifier
QQUCNT	QQUCNT	Unique count (unique per query)
QQUDEF	QQUDEF	User defined column
QQQDTN	QQQDTN	Unique subselect number
QQQDTL	QQQDTL	Subselect nested level
QQMATN	QQMATN	Materialized view subselect number
QQMATL	QQMATL	Materialized view nested level
QQORGQ	QQI1	Original number of QDTs
QQMRGQ	QQI2	Number of QDTs merged
QQFNLQ	QQI3	Final number of QDTs
QVRCNT	QVRCNT	Unique refresh counter