Database monitor view 3010 - HostVar & ODP Implementation

 

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    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 constants (V2) U - Table management row positioning (UP)
Host_Variable_Values	QQ1000	Host variable values
Unique_Refresh_Counter	QVRCNT	Unique refresh counter

 

Parent topic:

Optional database monitor SQL view format