Database monitor logical table 3003 - Summary Row for Query Sort

|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
     A* 
     A* DB Monitor logical table 3003 - Summary Row for Query Sort 
     A* 
     A          R QQQ3003                   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            QQSTIM 
     A            QQETIM 
     A            QQRSS 
     A            QQSSIZ                    RENAME(QQI1) + 
                                            COLHDG('Size of' + 
                                                   'Sort' + 
                                                   'Space') 
     A            QQPSIZ                    RENAME(QQI2) + 
                                            COLHDG('Pool' + 
                                                   'Size') 
     A            QQPID                     RENAME(QQI3) + 
                                            COLHDG('Pool' + 
                                                   'ID') 
     A            QQIBUF                    RENAME(QQI4) + 
                                            COLHDG('Internal' + 
                                                   'Buffer' + 
                                                   'Length') 
     A            QQEBUF                    RENAME(QQI5) + 
                                            COLHDG('External' + 
                                                   'Buffer' + 
                                                   'Length') 
     A            QQRCOD 
     A* 
     A* Columns added for Visual Explain
     A*
     A            QVBNDY
     A            QVRCNT
     A            QVPARPF
     A            QVPARPL 
     A            QVPARD        
     A            QVPARU        
     A            QVPARRC
     A            QQEPT
     A            QVCTIM
     A            QQAJN 
     A            QQJNP 
     A            QQJNDS                    RENAME(QQI6) + 
                                            COLHDG('Data Space' +
                                                   'Number') 
     A            QQJNMT                    RENAME(QQC21) + 
                                            COLHDG('Join' 'Method') 
     A            QQJNTY                    RENAME(QQC22) + 
                                            COLHDG('Join' 'Type') 
     A            QQJNOP                    RENAME(QQC23) + 
                                            COLHDG('Join' 'Operator')
     A            QVJFANO
     A            QVFILES                
     A          K QQJFLD 
     A          S QQRID                     CMP(EQ 3003)

Table 16. QQQ3003 - Summary Row for Query Sort

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
QQSTIM QQSTIM Start timestamp
QQETIM QQETIM End timestamp
QQRSS QQRSS Number of rows selected or sorted
QQSSIZ QQI1 Size of sort space
QQPSIZ QQI2 Pool size
QQPID QQI3 Pool id
QQIBUF QQI4 Internal sort buffer length
QQEBUF QQI5 External sort buffer length
QQRCOD QQRCOD Reason code

F1 - Query contains grouping columns (GROUP BY) from more that 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 that 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 key 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.

QVBNDY QVBNDY I/O or CPU bound. Possible values are:

I - I/O bound
C - CPU bound

QVRCNT QVRCNT Unique refresh counter
QVPARPF QVPARPF Parallel Prefetch (Y/N)
QVPARPL QVPARPL Parallel Preload (index used)
QVPARD QVPARD Parallel degree requested (index used)
QVPARU QVPARU Parallel degree used (index used)
QVPARRC QVPARRC Reason parallel processing was limited (index used)
QQEPT QQEPT Estimated processing time, in seconds
QVCTIM QVCTIM Estimated cumulative time, in seconds
QQAJN QQAJN Estimated number of joined rows
QQJNP QQJNP Join position - when available
QQJNDS QQI6 Data space number
QQJNMT QQC21 Join method - when available

NL - Nested loop
MF - Nested loop with selection
HJ - Hash join

QQJNTY QQC22 Join type - when available

IN - Inner join
PO - Left partial outer join
EX - Exception join

QQJNOP QQC23 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 product

QVJFANO QVJFANO Join fan out. Possible values are:

N - Normal join situation where fanout is allowed and each matching row of the join fanout is returned.
D - Distinct fanout. Join fanout is allowed however none of the join fanout rows are returned.
U - Unique fanout. Join fanout is not allowed. Error situation if join fanout occurs.

QVFILES QVFILES Number of tables joined

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
QQSTIM	QQSTIM	Start timestamp
QQETIM	QQETIM	End timestamp
QQRSS	QQRSS	Number of rows selected or sorted
QQSSIZ	QQI1	Size of sort space
QQPSIZ	QQI2	Pool size
QQPID	QQI3	Pool id
QQIBUF	QQI4	Internal sort buffer length
QQEBUF	QQI5	External sort buffer length
QQRCOD	QQRCOD	Reason code F1 - Query contains grouping columns (GROUP BY) from more that 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 that 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 key 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.
QVBNDY	QVBNDY	I/O or CPU bound. Possible values are: I - I/O bound C - CPU bound
QVRCNT	QVRCNT	Unique refresh counter
QVPARPF	QVPARPF	Parallel Prefetch (Y/N)
QVPARPL	QVPARPL	Parallel Preload (index used)
QVPARD	QVPARD	Parallel degree requested (index used)
QVPARU	QVPARU	Parallel degree used (index used)
QVPARRC	QVPARRC	Reason parallel processing was limited (index used)
QQEPT	QQEPT	Estimated processing time, in seconds
QVCTIM	QVCTIM	Estimated cumulative time, in seconds
QQAJN	QQAJN	Estimated number of joined rows
QQJNP	QQJNP	Join position - when available
QQJNDS	QQI6	Data space number
QQJNMT	QQC21	Join method - when available NL - Nested loop MF - Nested loop with selection HJ - Hash join
QQJNTY	QQC22	Join type - when available IN - Inner join PO - Left partial outer join EX - Exception join
QQJNOP	QQC23	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 product
QVJFANO	QVJFANO	Join fan out. Possible values are: N - Normal join situation where fanout is allowed and each matching row of the join fanout is returned. D - Distinct fanout. Join fanout is allowed however none of the join fanout rows are returned. U - Unique fanout. Join fanout is not allowed. Error situation if join fanout occurs.
QVFILES	QVFILES	Number of tables joined

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]