Database monitor view 3012 - Global Variables

Start of change Displays the SQL logical view format for database monitor QQQ3012. End of change

Create View QQQ3012 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 Unique_Refresh_Counter2, 
          QQUDEF as User_Defined, 
          QVRCNT as Unique_Refresh_Counter, 
          QQDBCLOB1 as DBCLOB_Global_Variable, 
          QQINT05 as SQ_Unique_Count, 
          QVC11 as GV_Truncated 
   FROM   UserLib/DBMONTable 
   WHERE  QQRID=3012)

Table 1. QQQ3012 - Global 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)
Unique_Refresh_Counter2	QQI5	Unique refresh counter
User_Defined	QQUDEF	User-defined column
Unique_Refresh_Counter	QVRCNT	Unique refresh counter
DBCLOB_Global_Variable	QQDBCLOB1	Global session variable values in a DBCLOB CCSID 1200 field.
SQ_Unique_Count	QQINT05	A unique count used to uniquely identify statements which do not have an ODP but do pass in global variables. If QQUCNT is 0 and the statement passes in global variables, this value is non-zero. An example would be a CALL statement.
GV_Truncated	QVC11	Host variable has been truncated (Y/N).