Database monitor view 3010 - Host Variable & ODP Implementation

Displays the SQL logical view format for database monitor QQQ3010.


Create View QQQ3010 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, 
          QQI5 as Unqiue_Refresh_Counter2, 
          QQUDEF as User_Defined, 
          QQC11 as ODP_Implementation, 
          QQC12 as Host_Variable_Implementation, 
          QQ1000 as Host_Variable_Values, 
          QVRCNT as Unique_Refresh_Counter, 
          QQDBCLOB1 as DBCLOB_CCSID, 
          QQI7 as DBCLOB_Length, 
          QQINT05 as SQ_Unique_Count, 
          QVC11 as HV_Truncated,
          QQSMINTF as Plan_Iteration_Number 
   FROM   UserLib/DBMONTable 
   WHERE  QQRID=3010)
Table 1. QQQ3010 - HostVar & ODP Implementation
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)
Unqiue_Refresh_Counter2 QQI5 Unique refresh counter
User_Defined QQUDEF User defined column
ODP_Implementation QQC11 ODP implementation
  • R - Reusable ODP
  • N - Nonreusable ODP
  • ' ' - Column not used
Host_Variable_Implementation QQC12 Host variable implementation
  • I - Interface supplied values (ISV)
  • V - Host variables treated as literals (V2)
  • U - Table management row positioning (UP)
  • S - SQL Insert/Update host variable value
Host_Variable_Values QQ1000 Host variable values
Unique_Refresh_Counter QVRCNT Unique refresh counter
DBCLOB_CCSID QQDBCLOB1 Host variables values in a DBCLOB CCSID 1200 field
DBCLOB_Length QQI7 Length of host variables in the DBCLOB column.
SQ_Unique_Count QQINT05 A unique count used to uniquely identify statements which do not have an ODP but do pass in host variables. If QQUCNT is 0 and the statement passes in host variables, this value will be non-zero. An example would be a CALL statement.
HV_Truncated QVC11 Host variable has been truncated (Y/N).
Start of changePlan_Iteration_NumberEnd of change Start of changeQQSMINTFEnd of change Start of changeAQP Plan iteration number; original optimization = 1.End of change