Database monitor view 3018 - STRDBMON/ENDDBMON

 

Create View QQQ3018 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, 
          QQC11 as Monitored_Job_type,  
          QQC12 as Monitor_Command,  
          QQC301 as Monitor_Job_Information, 
          QQ1000L as STRDBMON_Command_Text 
   FROM   UserLib/DBMONTable    WHERE  QQRID=3018)

Table 1. QQQ3018 - STRDBMON/ENDDBMON
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
Monitored_Job_type QQC11 Type of job monitored

  • C - Current

  • J - Job name

  • A - All
Monitor_Command QQC12 Command type

Monitor_Job_Information QQC301 Monitored job information

  • * - Current job

  • Job number/User/Job name

  • *ALL - All jobs
STRDBMON_Command_Text QQ1000L STRDBMON command text.

 

Parent topic:

Optional database monitor SQL view format