Database monitor logical table 3004 - Summary Row for Temp Table

|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
     A*
     A* DB Monitor logical table 3004 - Summary Row for Temp Table 
     A* 
     A          R QQQ3004                   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            QQTLN 
     A            QQTFN 
     A            QQTMN
     A            QQPTLN 
     A            QQPTFN 
     A            QQPTMN
     A            QQSTIM 
     A            QQETIM 
     A            QQDFVL                    RENAME(QQC11) + 
                                            COLHDG('Default' + 
                                                   'Values')
     A            QQTMPR
     A            QQRCOD 
     A* 
     A* Columns added for Visual Explain
     A*
     A            QVQTBL 
     A            QVQLIB
     A            QVPTBL
     A            QVPLIB
     A            QVTTBLN                   RENAME(QQC101) + 
                                            COLHDG('Temporary' +
                                                   'Table' +  
                                                   'Name')
     A            QVTTBLL                   RENAME(QQC102) + 
                                            COLHDG('Temporary' +
                                                   'Table' + 
                                                   'Library')
     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            QVTTRSZ                   RENAME(QQI2) + 
                                            COLHDG('Row Size' +
                                                   'Temporary' +
                                                   'Table')
     A            QVTTSIZ                   RENAME(QQI3) + 
                                            COLHDG('Table Size' +
                                                   'Temporary' +
                                                   'Table')
     A            QVTTRST                   RENAME(QQC12) + 
                                            COLHDG('Temporary' +
                                                   'Result')
     A            QVTTDST                   RENAME(QQC13) + 
                                            COLHDG('Distributed' +
                                                   'Table')
     A            QVTTNOD                   RENAME(QVC3001) + 
                                            COLHDG('Data' +
                                                   'Nodes')
     A          K QQJFLD 
     A          S QQRID                     CMP(EQ 3004)

Table 17. QQQ3004 - Summary Row for Temp Table

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
QQTLN QQTLN Library of table queried
QQTFN QQTFN Name of table queried
QQTMN QQTMN Member name of table queried
QQPTLN QQPTLN Library name of base table
QQPTFN QQPTFN Name of base table for table queried
QQPTMN QQPTMN Member name of base table
QQSTIM QQSTIM Start timestamp
QQETIM QQETIM End timestamp
QQDFVL QQC11 Default values may be present in temporary

Y - Yes
N - No

QQTMPR QQTMPR Number of rows in the temporary
QQRCOD QQRCOD Reason code. Possible values are:

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 sort rather than an index to order the results of the query.
F8 - Perform specified row selection to minimize I/O wait time.
F9 - The query optimizer chose to use a hashing algorithm rather than an index to perform the grouping.
FA - The query contains a join condition that requires a temporary table.
H1 - Table is a join logical file and its join type does not match the join type specified in the query.
H2 - Format specified for the logical table references more than one base table.
H3 - Table is a complex SQL view requiring a temporary table to contain the the results of the SQL view.
H4 - For an update-capable query, a subselect references a column in this table which matches one of the columns being updated.
H5 - For an update-capable query, a subselect references an SQL view which is based on the table being updated.
H6 - For a delete-capable query, a subselect references either the table from which rows are to be deleted, an SQL view, or an index based on the table from which rows are to be deleted

QVQTBL QVQTBL Queried table, long name
QVQLIB QVQLIB Library of queried table, long name
QVPTBL QVPTBL Base table, long name
QVPLIB QVPLIB Library of base table, long name
QVTTBLN QQC101 Temporary table name
QVTTBLL QQC102 Temporary table library
QVBNDY QVBNDY I/O or CPU bound. Possible values are:

I - I/O bound
C - CPU bound

QVRCNT QVRCNT Unique refresh counter
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
QVPARPF QVPARPF Parallel Prefetch (Y/N)
QVPARPL QVPARPL Parallel Preload (Y/N)
QVPARD QVPARD Parallel degree requested
QVPARU QVPARU Parallel degree used
QVPARRC QVPARRC Reason parallel processing was limited
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

QVTTRSZ QQI2 Row size of temporary table, in bytes
QVTTSIZ QQI3 Size of temporary table, in bytes
QVTTRST QQC12 Temporary result table that contains the results of the query. (Y/N)
QVTTDST QQC13 Distributed Table (Y/N)
QVTTNOD QVC3001 Data nodes of temporary table

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
QQTLN	QQTLN	Library of table queried
QQTFN	QQTFN	Name of table queried
QQTMN	QQTMN	Member name of table queried
QQPTLN	QQPTLN	Library name of base table
QQPTFN	QQPTFN	Name of base table for table queried
QQPTMN	QQPTMN	Member name of base table
QQSTIM	QQSTIM	Start timestamp
QQETIM	QQETIM	End timestamp
QQDFVL	QQC11	Default values may be present in temporary Y - Yes N - No
QQTMPR	QQTMPR	Number of rows in the temporary
QQRCOD	QQRCOD	Reason code. Possible values are: 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 sort rather than an index to order the results of the query. F8 - Perform specified row selection to minimize I/O wait time. F9 - The query optimizer chose to use a hashing algorithm rather than an index to perform the grouping. FA - The query contains a join condition that requires a temporary table. H1 - Table is a join logical file and its join type does not match the join type specified in the query. H2 - Format specified for the logical table references more than one base table. H3 - Table is a complex SQL view requiring a temporary table to contain the the results of the SQL view. H4 - For an update-capable query, a subselect references a column in this table which matches one of the columns being updated. H5 - For an update-capable query, a subselect references an SQL view which is based on the table being updated. H6 - For a delete-capable query, a subselect references either the table from which rows are to be deleted, an SQL view, or an index based on the table from which rows are to be deleted
QVQTBL	QVQTBL	Queried table, long name
QVQLIB	QVQLIB	Library of queried table, long name
QVPTBL	QVPTBL	Base table, long name
QVPLIB	QVPLIB	Library of base table, long name
QVTTBLN	QQC101	Temporary table name
QVTTBLL	QQC102	Temporary table library
QVBNDY	QVBNDY	I/O or CPU bound. Possible values are: I - I/O bound C - CPU bound
QVRCNT	QVRCNT	Unique refresh counter
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
QVPARPF	QVPARPF	Parallel Prefetch (Y/N)
QVPARPL	QVPARPL	Parallel Preload (Y/N)
QVPARD	QVPARD	Parallel degree requested
QVPARU	QVPARU	Parallel degree used
QVPARRC	QVPARRC	Reason parallel processing was limited
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
QVTTRSZ	QQI2	Row size of temporary table, in bytes
QVTTSIZ	QQI3	Size of temporary table, in bytes
QVTTRST	QQC12	Temporary result table that contains the results of the query. (Y/N)
QVTTDST	QQC13	Distributed Table (Y/N)
QVTTNOD	QVC3001	Data nodes of temporary table

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