Database monitor view 3026 - Set operation
Displays the SQL logical view format for database monitor QQQ3026.
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,
QQSMINTF as Plan_Iteration_Number
FROM UserLib/DBMONTable
WHERE QQRID=3026)
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:
|
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.
|
Set_Operator | QQC22 | Type of set operation. Possible values are:
|
Plan_Iteration_Number | QQSMINTF | AQP Plan iteration number, original optimization = 1 |