Database monitor logical table 3002 - Summary Row for Index Created

|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
     A*
     A* DB Monitor logical table 3002 - Summary Row for Index Created
     A* 
     A          R QQQ3002                   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            QQILNM 
     A            QQIFNM 
     A            QQIMNM 
     A            QQNTNM 
     A            QQNLNM
     A            QQSTIM
     A            QQETIM 
     A            QQTOTR
     A            QQRIDX 
     A            QQREST 
     A            QQFKEY 
     A            QQKSEL 
     A            QQAJN 
     A            QQEPT 
     A            QQJNP 
     A            QQJNDS                    RENAME(QQI1) + 
                                            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            QQIDXK                    RENAME(QQI2) + 
                                            COLHDG('Advised' +
                                                   'Primary' 'Keys') 
     A            QQKP 
     A            QQKPN                     RENAME(QQI3) + 
                                            COLHDG('Number' 'Key' +    
                                                   'Positioning' + 
                                                   'Columns') 
     A            QQKS 
     A            QQDSS 
     A            QQIDXA 
     A            QQRCOD 
     A            QQIDXD
     A            QQCRTK                     RENAME(QQ1000) + 
                                             COLHDG('Key Columns' + 
                                                    'of Index' + 
                                                    'Created')
     A* 
     A* Columns added for Visual Explain
     A*
     A            QVQTBL 
     A            QVQLIB
     A            QVPTBL
     A            QVPLIB
     A            QVINAM
     A            QVILIB
     A            QVBNDY
     A            QVRCNT
     A            QVJFANO
     A            QVFILES
     A            QVPARPF          
     A            QVPARPL 
     A            QVPARD        
     A            QVPARU        
     A            QVPARRC
     A            QVCTIM 
     A            QVTIXN                    RENAME(QQC101) + 
                                            COLHDG('Name of' +
                                                   'Index' +
                                                   'Created')
     A            QVTIXL                    RENAME(QQC102) + 
                                            COLHDG('Library of' + 
                                                   'Index' +
                                                   'Created')
     A            QVTIXPZ                   RENAME(QQI4) + 
                                            COLHDG('Page Size' +
                                                   'of Index' + 
                                                   'Created')
     A            QVTIXRZ                   RENAME(QQI5) + 
                                            COLHDG('Row Size' +
                                                   'of Index' + 
                                                   'Created')
     A            QVTIXACF                  RENAME(QQC14) + 
                                            COLHDG('ACS'  +
                                                   'Table' + 
                                                   'Used')
     A            QVTIXACS                  RENAME(QQC103) + 
                                            COLHDG('Alternate' +
                                                   'Collating' +
                                                   'Sequence' +  
                                                   'Table')
     A            QVTIXACL                  RENAME(QQC104) + 
                                            COLHDG('Alternate' +
                                                   'Collating' +
                                                   'Sequence' +  
                                                   'Library')
     A            QVTIXRU                   RENAME(QVC13) + 
                                            COLHDG('Index + 
                                                   'Created is' +
	                                                'Reusable')
     A            QVTIXSP                   RENAME(QVC14) + 
                                            COLHDG('Index + 
                                                   'Created is' +
                                                   'Sparse')
     A            QVTIXTY                   RENAME(QVC1F) + 
                                            COLHDG('Type of' + 
                                                   'Index' +
	                                                'Created')
     A            QVTIXUQ                   RENAME(QVP15A) + 
                                            COLHDG('Number of' + 
                                                   'Unique Values' +
                                                   'Index Created')
     A            QVTIXPO                   RENAME(QVC15) + 
                                            COLHDG('Permanent' +
 	                                                'Index' +
                                                   'Created') 
     A            QVTIXFX                   RENAME(QVC16) + 
                                            COLHDG('Index' +
                                                   'From' +
                                                   'Index')
     A            QVTIXPD                   RENAME(QVP151) + 
                                            COLHDG('Parallel' +
                                                   'Degree ' +
                                                   'Requested')
     A            QVTIXPU                   RENAME(QVP152) + 
                                            COLHDG('Parallel' +
                                                   'Degree ' +
                                                   'Used')
     A            QVTIXPRC                  RENAME(QVP153) + 
                                            COLHDG('Parallel' +
                                                   'Degree ' +
                                                   'Limited')
     A            QVKOA                     RENAME(QVC17) + 
                                            COLHDG('Index' +
                                                   'Only' +
                                                   'Access')
     A            QVIDXM                    RENAME(QVC18) + 
                                            COLHDG('Index' + 
                                                   'fits in' +
                                                   'Memory')
     A            QVIDXTY                   RENAME(QVC1B) + 
                                            COLHDG('Index' + 
                                                   'Type')
     A            QVIDXN                    RENAME(QQI6) + 
                                            COLHDG('Entries in' +
                                                   'Index' +
                                                   'Used')
     A            QVIDXUQ                   RENAME(QQI7) + 
                                            COLHDG('Number' + 
                                                   'Unique' +
                                                   'Values')
     A            QVIDXPO                   RENAME(QVP158) + 
                                            COLHDG('Percent' +
                                                   'Overflow')
     A            QVIDXVZ                   RENAME(QVP159) + 
                                            COLHDG('Vector' +
                                                   'Size')
     A            QVIDXSZ                   RENAME(QQI8) + 
                                            COLHDG('Size of' +
                                                   'Index' +
                                                   'Used')
     A            QVIDXPZ                   RENAME(QVP156) + 
                                            COLHDG('Page Size' +
                                                   'Index' +
                                                   'Used')
     A            QQPSIZ                    RENAME(QVP154) + 
                                            COLHDG('Pool' + 
                                                   'Size')
     A            QQPID                     RENAME(QVP155) + 
                                            COLHDG('Pool' + 
                                                   'ID')
     A            QVTBLSZ                   RENAME(QVP157) + 
                                            COLHDG('Table' + 
                                                   'Size')
     A            QVSKIPS                   RENAME(QVC1C) + 
                                            COLHDG('Skip' +
                                                   'Sequential')
     A            QVTSFLDS                  RENAME(QVC3001) + 
                                            COLHDG('Columns for' +
                                                   'Data Space' +
                                                   'Selection') 
     A            QVDVFLD                   RENAME(QVC1E + 
                                            COLHDG('Derived' +
                                                   'Column' +
                                                   'Selection')
     A            QVDVFLDS                  RENAME(QVC3002) + 
                                            COLHDG('Columns for' +
                                                   'Derived' +
                                                   'Selection')
     A            QVSKEYP                   RENAME(QVC3003) + 
                                            COLHDG('Columns Used' + 
                                                   'for Key' +
                                                   'Positioning') 
     A            QVSKEYS                   RENAME(QVC3004) + 
                                            COLHDG('Columns Used' + 
                                                   'for Key' +
                                                   'Selection')
     A          K QQJFLD 
     A          S QQRID                     CMP(EQ 3002)

Table 15. QQQ3002 - Summary row for Index Created

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
QQILNM QQILNM Library name of index used for access
QQIFNM QQIFNM Name of index used for access
QQIMNM QQIMNM Member name of index used for access
QQNTNM QQNTNM NLSS library
QQNLNM QQNLNM NLSS table
QQSTIM QQSTIM Start timestamp
QQETIM QQETIM End timestamp
QQTOTR QQTOTR Total rows in table
QQRIDX QQRIDX Number of entries in index created
QQREST QQREST Estimated number of rows selected
QQFKEY QQFKEY Keys selected thru index scan-key positioning
QQKSEL QQKSEL Keys selected thru index scan-key selection
QQAJN QQAJN Estimated number of joined rows
QQEPT QQEPT Estimated processing time, in seconds
QQJNP QQJNP Join position - when available
QQJNDS QQI1 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

QQIDXK QQI2 Number of advised key columns that use index scan-key positioning
QQKP QQKP Index scan-key positioning

Y - Yes
N - No

QQKPN QQI3 Number of columns that use index scan-key positioning for the index used
QQKS QQKS Index scan-key selection

Y - Yes
N - No

QQDSS QQDSS Data space selection

Y - Yes
N - No

QQIDXA QQIDXA Index advised

Y - Yes
N - No

QQRCOD QQRCOD Reason code

I1 - Row selection
I2 - Ordering/Grouping
I3 - Row selection and Ordering/Grouping
I4 - Nested loop join

QQIDXD QQIDXD Key columns for index advised
QQCRTK QQ1000 Key columns for index created
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
QVINAM QVINAM Name of index (or constraint) used, long name
QVILIB QVILIB Library of index used, long name
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 (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)
QVCTIM QVCTIM Estimated cumulative time, in seconds
QVTIXN QQC101 Name of index created
QVTIXL QQC102 Library of index created
QVTIXPZ QQI4 Page size of index created
QVTIXRZ QQI5 Row size of index created
QVTIXACS QQC103 Alternate Collating Sequence table of index created.
QVTIXACL QQC104 Alternate Collating Sequence library of index created.
QVTIXRU QVC13 Index created is reusable (Y/N)
QVTIXSP QVC14 Index created is sparse index (Y/N)
QVTIXTY QVC1F Type of index created. Possible values:

B - Binary Radix Index
E - Encoded Vector Index (EVI)

QVTIXUQ QVP15A Number of unique values of index created if index created is an EVI index.
QVTIXPO QVC15 Permanent index created (Y/N)
QVTIXFX QVC16 Index from index (Y/N)
QVTIXPD QVP151 Parallel degree requested (index created)
QVTIXPU QVP152 Parallel degree used (index created)
QVTIXPRC QVP153 Reason parallel processing was limited (index created)
QVKOA QVC17 Index only access (Y/N)
QVIDXM QVC18 Index fits in memory (Y/N)
QVIDXTY QVC1B Type of Index. Possible values are:

B - Binary Radix Index
C - Constraint (Binary Radix)
E - Encoded Vector Index (EVI)
T - Tertiary (AND/OR) Index

QVIDXN QQI6 Number of index entries, index used
QVIDXUQ QQI7 Number of unique key values, index used
QVIDXPO QVP158 Percent overflow, index used
QVIDXVZ QVP159 Vector size, index used
QVIDXSZ QQI8 Size of index used.
QVIDXPZ QVP156 Index page size
QQPSIZ QVP154 Pool size
QQPID QVP155 Pool id
QVTBLSZ QVP157 Table size
QVSKIPS QVC1C Skip sequential table scan (Y/N)
QVTSFLDS QVC3001 Columns used for data space selection
QVDVFLD QVC1E Derived column selection (Y/N)
QVDVFLDS QVC3002 Columns used for derived column seleciton
QVSKEYP QVC3003 Columns used for index scan-key positioning
QVSKEYS QVC3004 Columns used for index scan-key selection

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
QQILNM	QQILNM	Library name of index used for access
QQIFNM	QQIFNM	Name of index used for access
QQIMNM	QQIMNM	Member name of index used for access
QQNTNM	QQNTNM	NLSS library
QQNLNM	QQNLNM	NLSS table
QQSTIM	QQSTIM	Start timestamp
QQETIM	QQETIM	End timestamp
QQTOTR	QQTOTR	Total rows in table
QQRIDX	QQRIDX	Number of entries in index created
QQREST	QQREST	Estimated number of rows selected
QQFKEY	QQFKEY	Keys selected thru index scan-key positioning
QQKSEL	QQKSEL	Keys selected thru index scan-key selection
QQAJN	QQAJN	Estimated number of joined rows
QQEPT	QQEPT	Estimated processing time, in seconds
QQJNP	QQJNP	Join position - when available
QQJNDS	QQI1	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
QQIDXK	QQI2	Number of advised key columns that use index scan-key positioning
QQKP	QQKP	Index scan-key positioning Y - Yes N - No
QQKPN	QQI3	Number of columns that use index scan-key positioning for the index used
QQKS	QQKS	Index scan-key selection Y - Yes N - No
QQDSS	QQDSS	Data space selection Y - Yes N - No
QQIDXA	QQIDXA	Index advised Y - Yes N - No
QQRCOD	QQRCOD	Reason code I1 - Row selection I2 - Ordering/Grouping I3 - Row selection and Ordering/Grouping I4 - Nested loop join
QQIDXD	QQIDXD	Key columns for index advised
QQCRTK	QQ1000	Key columns for index created
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
QVINAM	QVINAM	Name of index (or constraint) used, long name
QVILIB	QVILIB	Library of index used, long name
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 (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)
QVCTIM	QVCTIM	Estimated cumulative time, in seconds
QVTIXN	QQC101	Name of index created
QVTIXL	QQC102	Library of index created
QVTIXPZ	QQI4	Page size of index created
QVTIXRZ	QQI5	Row size of index created
QVTIXACS	QQC103	Alternate Collating Sequence table of index created.
QVTIXACL	QQC104	Alternate Collating Sequence library of index created.
QVTIXRU	QVC13	Index created is reusable (Y/N)
QVTIXSP	QVC14	Index created is sparse index (Y/N)
QVTIXTY	QVC1F	Type of index created. Possible values: B - Binary Radix Index E - Encoded Vector Index (EVI)
QVTIXUQ	QVP15A	Number of unique values of index created if index created is an EVI index.
QVTIXPO	QVC15	Permanent index created (Y/N)
QVTIXFX	QVC16	Index from index (Y/N)
QVTIXPD	QVP151	Parallel degree requested (index created)
QVTIXPU	QVP152	Parallel degree used (index created)
QVTIXPRC	QVP153	Reason parallel processing was limited (index created)
QVKOA	QVC17	Index only access (Y/N)
QVIDXM	QVC18	Index fits in memory (Y/N)
QVIDXTY	QVC1B	Type of Index. Possible values are: B - Binary Radix Index C - Constraint (Binary Radix) E - Encoded Vector Index (EVI) T - Tertiary (AND/OR) Index
QVIDXN	QQI6	Number of index entries, index used
QVIDXUQ	QQI7	Number of unique key values, index used
QVIDXPO	QVP158	Percent overflow, index used
QVIDXVZ	QVP159	Vector size, index used
QVIDXSZ	QQI8	Size of index used.
QVIDXPZ	QVP156	Index page size
QQPSIZ	QVP154	Pool size
QQPID	QVP155	Pool id
QVTBLSZ	QVP157	Table size
QVSKIPS	QVC1C	Skip sequential table scan (Y/N)
QVTSFLDS	QVC3001	Columns used for data space selection
QVDVFLD	QVC1E	Derived column selection (Y/N)
QVDVFLDS	QVC3002	Columns used for derived column seleciton
QVSKEYP	QVC3003	Columns used for index scan-key positioning
QVSKEYS	QVC3004	Columns used for index scan-key selection

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