Creating a monitoring profile in ISPF

Create a monitoring profile for each Db2 subsystem or data sharing group that you want to monitor.

Procedure

To create a monitoring profile:

  1. On the IBM DB2 Query Monitor for z/OS panel (the main menu), specify option 8, and press Enter.
  2. On the Monitoring Profiles panel, type CREATE on the command line, and press Enter.
  3. On the Create Monitoring Profile pop-up panel, specify the profile name and optionally any QM plans to excludes from exceptions, alerts, and current activity, and press Enter.
    Figure 1. Create Monitoring Profile pop-up panel
         ----------- Create Monitoring Profile -------------------  
Option  ===> _________________________________________________      
                                                                    
  Profile Name ........... ________                                 
  Exclude QM Plans (Y/N)   N                                        
  QM Plan#1  ________   QM Plan#2  ________   QM Plan#3  ________   
                                                                    
                                                                    
  Press Enter to create profile or PF3/CANCEL to exit

    If you want to exclude QM plans, set Exclude QM Plans to Y and then specify up to three plan patterns to identify the plans that you want to exclude; you can specify wildcards.

  4. On the Create Monitoring Profile panel, add your monitoring profile lines.
    Figure 2. Create Monitoring Profile panel
    YYYY/MM/DD HH:MM:SS  ----- Create Monitoring Profile ----  Row 1 of 1          
Option  ===>                                                  Scroll ===> PAGE 
Profile Name: MONPR1                                                          
                                                                               
C:I-Insert,U-Update,R-Repeat,D-Delete,C-Copy,M-Move,A-After,B-Before           
------------------------------------------------------------------------     > 
CMD   WORKLOAD NAME                    INCL\EXCL SSID Plan     Program         
 -    --------------------------------    -      ---- -------- --------        
 __                                       I      *    *        *               
***************************** Bottom of Data **********************************

    Each profile line can define the inclusion or exclusion of specific workloads from summary reporting, exception processing, and alert processing. The sequence of these lines determines the order in which Db2 Query Monitor looks for a match and, if found, includes or excludes activity information.

    To insert a monitoring profile line, use the I line command; see Adding a monitoring profile line in ISPF.

    Use the other line commands to edit the profile lines as needed; see Creating and updating monitoring profile lines in ISPF

  5. When you are done entering all of your monitoring profile lines, exit the panel (PF3) to save your new monitoring profile.