Creating new Db2 subsystem configurations and/or monitoring profiles via duplication on PARMGEN

In order to monitor more Db2 subsystems/data sharing groups, you need to add more subsystem configurations to the PARMGEN profile. The same applies to monitoring profiles, if you want to analyze different performance metrics for selected Db2 subsystems. In order to create a new Db2 configuration or monitoring profile, you can duplicate an existing one. Per default, two Db2 configurations and one monitoring profile are available.

Before you begin

This best practice does not require any prerequisites. You can follow the steps while doing your first configuration or when updating your existing configuration.

About this task

You will duplicate an existing monitoring profile in this workflow. However, this information is also applicable to all other parameters that are table-based. These are all parameters of the structure Kpp_AAxx, where:
  • pp is the product code
  • AA is the parameter function identifier (for example, PF for monitoring profiles, or DB for Db2 configurations)
  • xx is the row ID

In order to create a new monitoring profile in the PARMGEN user profile, you duplicate an existing profile. After this step, you adjust the profile ID that is part of the parameter. For example, in parameter KD2_PF01_SQLPA_VERSION, the profile ID is PF01.

The sample PARMGEN profile that is provided with OMEGAMON® for Db2 PE already contains a default monitoring profile configuration. You can use this default profile for the following steps, or create a new profile PF02.

Procedure

  1. Open the PARMGEN user profile and search for the first or any existing monitoring profile. Issue the following command: f PFxx
  2. Issue the following primary command to exclude all lines: x all 
     
  File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help               
----------------------------------------------------------------------------------
EDIT       SAR.PG.V540.OMPE01.WCONFIG(OMPE01) - 01.03          All lines excluded 
Command ===> x all                                               Scroll ===> CSR  
****** ****************************** Top of Data ********************************
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 2534 Line(s) not Displayed 
****** ***************************** Bottom of Data ******************************
  3. Issue the following primary command to include all profile monitoring parameters: f PF01 all 
     
  File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help               
----------------------------------------------------------------------------------
EDIT       SAR.PG.V540.OMPE01.WCONFIG(OMPE01) - 01.03            253 CHARS 'PF01' 
Command ===> f PF01 all                                          Scroll ===> CSR  
****** ****************************** Top of Data ********************************
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 1742 Line(s) not Displayed 
001743 ** BEGIN KD2_PF01 - Monitoring profile ID: P001                            
001744 KD2_PF01_ROW                      01                                       
001745 KD2_PF01_PROFID                   P001                                     
001746 KD2_PF01_DESCRIPTION              "P001 PROFILE"                           
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 6 Line(s) not Displayed 
001753 KD2_PF01_OA_ECM                   N            * Enablement Parameter *    
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 1 Line(s) not Displayed 
001755 KD2_PF01_OA_WAIT                  5                                        
001756 KD2_PF01_OA_START                 N                                        
001757 KD2_PF01_OA_THREAD                N                                        
001758 KD2_PF01_OA_INTV                  15                                       
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 7 Line(s) not Displayed
    Note: You can include commented lines using the line command f. For example, to include the six lines between KD2_PF01_DESCRIPTION and KD2_PF01_OA_ECM, use f6. This results in the following screen:
     
File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help                 
----------------------------------------------------------------------------------
EDIT       SAR.PG.V540.OMPE01.WCONFIG(OMPE01) - 01.03            253 CHARS 'PF01' 
Command ===>                                                     Scroll ===> CSR  
****** ****************************** Top of Data ********************************
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 1742 Line(s) not Displayed 
001743 ** BEGIN KD2_PF01 - Monitoring profile ID: P001                            
001744 KD2_PF01_ROW                      01                                       
001745 KD2_PF01_PROFID                   P001                                     
001746 KD2_PF01_DESCRIPTION              "P001 PROFILE"                           
f6- -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 6 Line(s) not Displayed 
001753 KD2_PF01_OA_ECM                   N            * Enablement Parameter *    
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 1 Line(s) not Displayed 
001755 KD2_PF01_OA_WAIT                  5                                        
001756 KD2_PF01_OA_START                 N                                        
001757 KD2_PF01_OA_THREAD                N                                        
001758 KD2_PF01_OA_INTV                  15                                       
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 7 Line(s) not Displayed
    Results in: 
     
File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help                 
----------------------------------------------------------------------------------
EDIT       SAR.PG.V540.OMPE01.WCONFIG(OMPE01) - 01.03         Columns 00001 00080 
Command ===>                                                     Scroll ===> CSR  
****** ****************************** Top of Data ********************************
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 1742 Line(s) not Displayed 
001743 ** BEGIN KD2_PF01 - Monitoring profile ID: P001                            
001744 KD2_PF01_ROW                      01                                       
001745 KD2_PF01_PROFID                   P001                                     
001746 KD2_PF01_DESCRIPTION              "P001 PROFILE"                           
001747                                                                            
001748 ** ------                                                                  
001749 ** Object and Volume Analysis (OA):                                        
001750 ** ------                                                                  
001751 ** Specify Object and Volume Analysis (OA) parameters used in the          
001752 ** xKD2PAR(STRTOA) member:                                                 
001753 KD2_PF01_OA_ECM                   N            * Enablement Parameter *    
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 1 Line(s) not Displayed 
001755 KD2_PF01_OA_WAIT                  5                                        
001756 KD2_PF01_OA_START                 N                                        
001757 KD2_PF01_OA_THREAD                N                                        
001758 KD2_PF01_OA_INTV                  15                                       
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 7 Line(s) not Displayed
  4. Issue the rr block line command on all included lines to repeat the profile once. 
     
  File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help               
----------------------------------------------------------------------------------
EDIT       SAR.PG.V540.OMPE01.WCONFIG(OMPE01) - 01.03            253 CHARS 'PF01' 
Command ===>                                                     Scroll ===> CSR  
****** ****************************** Top of Data ********************************
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 1742 Line(s) not Displayed 
rr1743 ** BEGIN KD2_PF01 - Monitoring profile ID: P001                            
001744 KD2_PF01_ROW                      01                                       
001745 KD2_PF01_PROFID                   P001                                     
001746 KD2_PF01_DESCRIPTION              "P001 PROFILE"                           
   :
   :
rr2159 ** END KD2_PF01 - Monitoring profile ID: P001
  5. Issue the rr block line command to exclude the first of the two identical profiles to ensure you do not edit it. 
     
  File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help               
----------------------------------------------------------------------------------
EDIT       SAR.PG.V540.OMPE01.WCONFIG(OMPE01) - 01.03            253 CHARS 'PF01' 
Command ===>                                                     Scroll ===> CSR  
****** ****************************** Top of Data ********************************
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 1742 Line(s) not Displayed 
xx1743 ** BEGIN KD2_PF01 - Monitoring profile ID: P001                            
001744 KD2_PF01_ROW                      01                                       
001745 KD2_PF01_PROFID                   P001                                     
001746 KD2_PF01_DESCRIPTION              "P001 PROFILE"                           
   :
   :
xx2159 ** END KD2_PF01 - Monitoring profile ID: P001                              
002160 ** BEGIN KD2_PF01 - Monitoring profile ID: P001                            
002161 KD2_PF01_ROW                      01                                       
002162 KD2_PF01_PROFID                   P001                                     
002163 KD2_PF01_DESCRIPTION              "P001 PROFILE"
  6. Issue the following primary command to change the monitoring profile ID to a new ID, so that you have two different monitoring profiles:
    c PF01 PF02 all nx
     
  File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help               
----------------------------------------------------------------------------------
EDIT       SAR.PG.V540.OMPE01.WCONFIG(OMPE01) - 01.04         Columns 00001 00080 
Command ===> c PF01 PF02 all nx                                  Scroll ===> CSR  
****** ****************************** Top of Data ********************************
- - -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 2159 Line(s) not Displayed 
==CHG> ** BEGIN KD2_PF02 - Monitoring profile ID: P001                            
==CHG> KD2_PF02_ROW                      01                                       
==CHG> KD2_PF02_PROFID                   P001                                     
==CHG> KD2_PF02_DESCRIPTION              "P001 PROFILE"
    Note: The nx command ensures that the change command only affects the non-excluded lines.
  7. Change the KD2_PF02_ROW parameter to match the ID in PFxx. 
     
  File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help              
---------------------------------------------------------------------------------
EDIT       SAR.PG.V540.OMPE01.WCONFIG(OMPE01) - 01.04     CHARS 'KD2_PF02_PROFID'
Command ===>                                                     Scroll ===> CSR 
002161 KD2_PF02_ROW                      02
  8. Change the KD2_PF02_PROFID parameter to a new monitoring profile ID to ensure that it differs from the original profile ID. 
     
File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help                    
----------------------------------------------------------------------------------
EDIT       SAR.PG.V540.OMPE01.WCONFIG(OMPE01) - 01.04     CHARS 'KD2_PF02_PROFID' 
Command ===>                                                     Scroll ===> CSR  
002162 KD2_PF02_PROFID                   P002                                          
002163 KD2_PF02_DESCRIPTION              "P002 PROFILE"