Database monitor view 3026 - Set operation
Create View QQQ3026 as (SELECT QQRID as Row_ID, QQTIME as Time_Created, QQJFLD as Join_Column, QQRDBN as Relational_Database_Name, QQSYS as System_Name, QQJOB as Job_Name, QQUSER as Job_User, QQJNUM as Job_Number, QQI9 as Thread_ID, QQUCNT as Unique_Count, QQUDEF as User_Defined, QQQDTN as Unique_SubSelect_Number, QQQDTL as SubSelect_Nested_Level, QQMATN as Materialized_View_Subselect_Number, QQMATL as Materialized_View_Nested_Level, QVP15E as Materialized_View_Union_Level, QVP15A as Decomposed_Subselect_Number, QVP15B as Total_Number_Decomposed_SubSelects, QVP15C as Decomposed_SubSelect_Reason_Code, QVP15D as Starting_Decomposed_SubSelect, QVRCNT as Unique_Refresh_Counter, QVPARPF as Parallel_Prefetch, QVPARPL as Parallel_PreLoad, QVPARD as Parallel_Degree_Requested, QVPARU as Parallel_Degree_Used, QVPARRC as Parallel_Degree_Reason_Code, QQEPT as Estimated_Processing_Time, QVCTIM as Estimated_Cumulative_Time, QQREST as Estimated_Rows_Selected, QQC11 as Union_Type, QVFILES as Join_Table_Count, QQUNIN as Has_Union, QWC16 as Last_Union_Subselect, QQC23 as Set_in_a_View, QQC22 as Set_Operator FROM UserLib/DBMONTable WHERE QQRID=3026)
Table 1. QQQ3026 - Set operatoin View Column Name Table Column Name Description Row_ID QQRID Row identification Time_Created QQTIME Time row was created Join_Column QQJFLD Join column (unique per job) Relational_Database_Name QQRDBN Relational database name System_Name QQSYS System name Job_Name QQJOB Job name Job_User QQUSER Job user Job_Number QQJNUM Job number Thread_ID QQI9 Thread identifier Unique_Count QQUCNT Unique count (unique per query) User_Defined QQUDEF User defined column Unique_SubSelect_Number QQQDTN Unique subselect number SubSelect_Nested_Level QQQDTL Subselect nested level Materialized_View_Subselect_Number QQMATN Materialized view subselect number Materialized_View_Nested_Level QQMATL Materialized view nested level Materialized_View_Union_Level QVP15E Materialized view union level Decomposed_Subselect_Number QVP15A Decomposed query subselect number, unique across all decomposed subselects Total_Number_Decomposed_SubSelects QVP15B Total number of decomposed subselects Decomposed_SubSelect_Reason_Code QVP15C Decomposed query subselect reason code Starting_Decomposed_SubSelect QVP15D Decomposed query subselect number for the first decomposed subselect Unique_Refresh_Counter QVRCNT Unique refresh counter Parallel_Prefetch QVPARPF Parallel Prefetch (Y/N) Parallel_PreLoad QVPARPL Parallel Preload (Y/N) Parallel_Degree_Requested QVPARD Parallel degree requested Parallel_Degree_Used QVPARU Parallel degree used Parallel_Degree_Reason_Code QVPARRC Reason parallel processing was limited Estimated_Processing_Time QQEPT Estimated processing time, in seconds Estimated_Cumulative_Time QVCTIM Estimated cumulative time, in seconds Estimated_Rows_Selected QQREST Estimated number of rows selected Union_Type QQC11 Type of union. Possible values are:
- A - Union All
- U - Union
Join_Table_Count QVFILES Number of tables queried Has_Union QQUNIN Union subselect (Y/N) Last_Union_Subselect QWC16 This is the last subselect, or only subselect, for the query. (Y/N) Set_in_a_View QQC23 Set operation within a view.
- Byte 1 of 2 (Y/N): This subselect is part of a query that is contained within a view and it contains a set operation (for example, Union).
- Byte 2 of 2 (Y/N): This is the last subselect of the query that is contained within a view.
Set_Operator QQC22 Type of set operation. Possible values are:
- UU - Union
- UA - Union All
- UR - Union Recursive
- EE - Except
- EA - Except All
- II - Intersect
- IA - Intersect All
Parent topic:
Optional database monitor SQL view format