Database monitor view 3011 - Array Host Variables

Edit online

Displays the SQL logical view format for database monitor QQQ3011.


Create View QQQ3011 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, 
          QQ19 as Thread_ID, 
          QQUCNT as Unique_Count, 
          QQUDEF as User_Defined,  
          QQC11 as ODP_Implementation, 
          QQC12 as Array_Variable_Implementation, 
          QQC101 as Array_Name, 
          QVRCNT as Unique_Refresh_Counter, 
          QQDBCLOB1 as Array_Values, 
          QQINT05 as SQ_Unique_Count, 
          QVC11 AS HV_Truncated, 
          QVC1281 as Array_Name, 
          QVC1282 as Array_Library, 
          QQI1 as Max_Cardinality, 
          QQI2 as Cur_Cardinality, 
          QQI3 as Index_Position 
   FROM   UserLib/DBMONTable 
   WHERE  QQRID=3011)
Table 1. QQQ3011 - Array Host Variables
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
ODP_Implementation QQC11 ODP implementation:
  • R - Reusable ODP
  • N - Nonreusable ODP
  • ' ' - Column not used
Array_Variable_Implementation QQC12 Array variable implementation:
  • I - Interface supplied values (ISV)
  • S- SQL Insert/Update array variable value
Array_Name QQC101 Array name generated by the optimizer. Matches the array value in the QQ1000 QQHVAR field in the 3010 record.
Unique_Refresh_Counter QVRCNT Unique refresh counter.
Array_Values QQDBCLOB1 Array variables values in a DBCLOB CCSID 1200 field (max 1 MB).
SQ_Unique_Count QQINT05 A unique count used to uniquely identify statements which do not have an ODP but do pass in Arrays. If QQUCNT is 0 and the statement passes in Arrays, this value will be non-zero. An example would be a CALL statement.
HV_Truncated QVC11 Host variable has been truncated (Y/N).
Array_Name QVC1281 Name of Array UDT.
Array_Library QVC1282 Library of Array UDT.
Max_Cardinality QQI1 Maximum cardinality of Array.
Cur_Cardinality QQI2 Current cardinality of Array.
Index_Position QQI3 Index position in the Array designated in the QQ1000 QQHVAR field in the 3010 record.