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