データベース・モニター・ビュー 3019 - 検索された行

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,
          QQINT03 as Temporary_Storage,
          QQC11 as DBMON_Temp_Result_Reused,
          QQC21 as DBMON_Temp_Reused_RC,
          QQINT01 as DBMON_Temp_Reuse_Count,
          QQIA as Skip_Lock_Row_Count,
          QQINT05 as Skip_Lock_Row_Runs,
          QQINT06 as Skip_Lock_On_Runs,
          QQF1 as Adjusted_Average_Run_Time,
          QVRCNT as Unique_Refresh_Counter, 
          QVP152 as Committed_Journal_Search_Requests, 
          QVP153 as Committed_Journal_Search_Failures, 
          QVP154 as Committed_Journal_Search_Time_Limit 
   FROM   UserLib/DBMONTable 
   WHERE  QQRID=3019)