Database monitor view 3019 - Rows retrieved
Create View QQQ3019 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, QQI1 as CPU_Time_to_Return_All_Rows, QQI2 as Clock_Time_to_Return_All_Rows, QQI3 as Number_Synchronous_Database_Reads, QQI4 as Number_Synchronous_Database_Writes, QQI5 as Number_Asynchronous_Database_Reads, QQI6 as Number_Asynchronous_Database_Writes, QVP151 as Number_Page_Faults, QQI7 as Number_Rows_Returned, QQI8 as Number_of_Calls_for_Returned_Rows, QVP15F as Number_of_Times_Statement_was_Run FROM UserLib/DBMONTable WHERE QQRID=3019)
Table 1. QQQ3019 - Rows retrieved 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 CPU_Time_to_Return_All_Rows QQI1 CPU time to return all rows, in milliseconds Clock_Time_to_Return_All_Rows QQI2 Clock time to return all rows, in milliseconds Number_Synchronous_Database_Reads QQI3 Number of synchronous database reads Number_Synchronous_Database_Writes QQI4 Number of synchronous database writes Number_Asynchronous_Database_Reads QQI5 Number of asynchronous database reads Number_Asynchronous_Database_Writes QQI6 Number of asynchronous database writes Number_Page_Faults QVP151 Number of page faults Number_Rows_Returned QQI7 Number of rows returned Number_of_Calls_for_Returned_Rows QQI8 Number of calls to retrieve rows returned Number_of_Times_Statement_was_Run QVP15F Number of times this Statement was run. If Null, then the statement was run once.
Parent topic:
Optional database monitor SQL view format