Using application groups and profiles

Perform procedures in this topic to select, create, or update application groups and profiles.

(BMC.DB2.SPE2310) An application profile consists of one or more application groups. An application group is a logical collection of plans, programs, users, correlation IDs, collection IDs, Db2s (objects)—or any combination of these elements—that represent the workload associated with a particular business function or individual. After you define application groups and profiles for your site, you can monitor the SQL workload by application.

Related topic

Workload-analysis-tasks

To select an application profile

  1. On the SQL Workload Analysis Menu, select Application profile and press Enter.The Application Profile Selection panel is displayed. This panel lists available application profiles. Only profiles you have created or profiles granted public access appear.

    ASQEPRGS/P            Application Profile Selection               LINE 1 OF 17
     Command ====> ______________________________________________ Scroll ===> PAGE
                                                                                 
     Current application profile : DEFAULT   Owner :                              
                                                                                 
     Select the application profile that contains the desired application groups.
     Then press Enter.
                       
     Actions:  S -Select a profile     V -View profile definition
                                                                  
     Act   Name       Owner     Description                         
     ---   --------   -------   ------------------------------       
     S     COMPANY    SYSTEM    COMPANY WIDE APPLICATIONS             
     _     DEFAULT    BMCSFTWR  DEFAULT APPLICATION PROFILE            
     _     JOHNS      TSODA45   JOHN SMITHS SPECIAL PROFILE             
     _     KEVINS     TSODB02   KEVINS TEST PROFILE
  2. Type S in the Act field beside COMPANY to select the COMPANY profile, and press Enter.The SQL Workload Analysis Menu is displayed.
  3. Select Initial report and press Enter.The SQL Workload Initial Analysis Level panel is displayed.
  4. Select Application group and press Enter.The SQL Workload Analysis Menu is displayed.
  5. Select Report type and press Enter.The SQL Workload Analysis Report Type panel is displayed.
  6. Select Graph and press Enter.The SQL Workload Analysis Menu is displayed.

  7. Select Workload analysis and press Enter.When

    Some content is unavailable due to permissions.

    finishes collecting data, the Group Analysis report is displayed. In this example, SALES, PURCHASING, SHIPPING, MARKETING, AD-HOC, and DEFAULT_GROUP are the application groups contained in the COMPANY application profile. DEFAULT_GROUP is a system-created group containing all of the data that does not match the criteria for any of the defined groups in the profile.

    Group Analysis report

    ASQEQRPW/I                      VIEW A REPORT                     LINE 1 OF 32
    COMMAND ====> _______________________________________________ SCROLL ===> CSR_
                                                                                  
    BMCSftwr.SQMCAGTG    --     GROUP ANALYSIS (GRAPH)     --       09/05 19:15:20
    SOURCE : NC1I-ACTIVE   INTVL : 09/05 00:00 - UNLIMITED                         
    -------------------------------------------------------------------------------
       Zooms:   N-CLNTAP W-CLNTWS L-CORR  T-DETL   K-IMPQUL P-PLAN   S-STMT        
       Y-ACCEL  9-CLNTCT C-CONNID D-DB2   E-ERROR  V-INTVL  R-PROG   U-USER        
       M-ACCMTX I-CLNTID 8-CONNTY B-DSGRP X-EXCPTN O-OBJECT J-REQLOC               
       DB2:      DSGRP:           PLAN:            PROG:                           
                        SQL   --- IN-SQL ELAPSED TIME -- ----- IN-SQL CPU TIME ----
       APPL. GROUP      CALLS   %                          %                       
       ---------------- ----- ----- +------------------+ ----- +------------------+
    +  HOST              4421  36.9 |>>>>>>>           |   0.0 |                  |
    +  ALL               120M  29.3 |>>>>>             |   6.2 |>                 |
    +  IBM DB2 PROGRAMS 5879K   4.9 |>                 |   0.8 |                  |
    +  DISTSERV          806K   1.0 |                  |  88.2 |>>>>>>>>>>>>>>>>  |

To create an application profile

  1. On the 

    Some content is unavailable due to permissions.

     Main Menu, select Application Profiles and press Enter.The Applications Profiles panel is displayed. Use this panel to create or modify application profiles.

    ASQEPRFG/P                Application Profiles               LINE 1 OF 17
     Command ====> _______________________________________________ Scroll ===> PAGE
                                                                                  
                                                                                  
     Select an application profile with an action code from the list below.        
     To add a profile, complete the "New profile" fields, then press Enter.        
                                                                                  
     Actions:  V -View     M -Modify     D -Delete     C -Copy                     
                                                                                  
     New profile name   ________    Description   ______________________________   
                owner   RDHDXJ__                                                   
                                                          +----- Last changed ----+
     Act Name     Owner    Description                    User     Date     Time   
     --- -------- -------- ------------------------------ -------- -------- -------
     _   COMPANY  SYSTEM   COMPANY WIDE APPLICATIONS      RDHCJM   2011-03-01 09:10
     _   DEFAULT  BMCSFTWR DEFAULT APPLICATION PROFILE    V2R4M00  2011-04-03 16:37
     _   JOHNS    TSODA45  JOHN SMITHS SPECIAL PROFILE    TSODA45  2011-01-18 05:33
     _   KEVINS   TSODB02  KEVINS TEST PROFILE            TSODB02  2011-01-18 05:33

  2. Create or modify an application profile:

    • To create a new application profile, type a new profile name and a short description, and press Enter.
    • To modify an existing application profile, type M in the Act field beside the application profile name, and press Enter.

    The Define Application Groups panel is displayed. If you are creating a new profile, no application groups appear on the Define Application Groups panel. You can specify on this panel whether other users have access to this profile, and if so, whether they are allowed to modify it.
    (BMC.DB2.SPE2310) 

    ASQEPRG0/P              Define Application Groups                 LINE 1 OF 18
     Command ====> ______________________________________________ Scroll ===> CSR_
                                                                              
     Profile name : COMPANY   Public access   R      (N=None,R=Read,U=Update)  
            owner : RDHDXJ4     Description   COMPANY_WIDE_APPLICATIONS_____   
                                                                              
     To add a new group or object, complete the appropriate fields and         
     press Enter.  Wildcards are allowed. See HELP for more information.       
                                                                              
     Action: D - Delete entry from the list                                    
                                                                              
     Appl. group   HELP_DESK_______  Description   HELP_DESK_APPLICATION_________
      New object   PLANSA50                 Type   PLAN  __  (P=PLAN,   R=PROGRAM)
                                                             (U=USERID, C=CorrId )
                                                             (D=DB2,    O=CollId )
     Act  Group            Object   Type     Description                         
     ---  ---------------- -------- -------- ------------------------------      
     _    AD-HOC           DSNESM68 PROGRAM  SPUFI AND THE LIKE                  
     _    AD-HOC           DSNTEP2  PROGRAM  SPUFI AND THE LIKE                  
     _    AD-HOC           RDH*     PROGRAM                                      
     _    FINANCE          PLANF*   PLAN     FINANCE APPLICATIONS                
     _    FINANCE          RF*      PROGRAM  FINANCE APPLICATIONS
  3. Specify a group name, a short description, the name of the object, and the type of object, then press Enter.

In the Modified Define Application Groups panel, a new application group called HELP_DESK is added to the application profile called COMPANY. You can define as many objects as you want to the same group name, and you can add as many groups as you want to the profile.

You cannot specify an object in more than one group. However, you can use the * (asterisk) wildcard in your specifications, which might result in an object matching specifications in more than one group. For more information about the wildcard rules and the rules of precedence for this panel, see online Help (press F1 or type HELP ASQEPRG0).

When you define this new application group, HELP_DESK appears among the application groups in the COMPANY application profile (displayed in the following figure). 
(BMC.DB2.SPE2310) 

Modified Define Application Groups panel

                 ASQEPRG0/P              Define Application Groups                 LINE 1 OF 18
 Command ====> _______________________________________________ Scroll ===> CSR_
                                                                               
 Profile name : COMPANY   Public access   R      (N=None,R=Read,U=Update)       
        owner : RDHDXJ4     Description   COMPANY_WIDE_APPLICATIONS_____        
                                                                               
 To add a new group or object, complete the appropriate fields and              
 press Enter.  Wildcards are allowed. See HELP for more information.            
                                                                               
 Action: D - Delete entry from the list                                         
                                                                               
 Appl. group   ________________  Description   ______________________________   
  New object   ________                 Type   ________  (P=PLAN,   R=PROGRAM)  
                                                         (U=USERID, C=CorrId )  
                                                         (D=DB2,    O=CollId )  
 Act  Group            Object   Type     Description                            
 ---  ---------------- -------- -------- ------------------------------         
 _    AD-HOC           DSNESM68 PROGRAM  SPUFI AND THE LIKE                     
 _    AD-HOC           DSNTEP2  PROGRAM  SPUFI AND THE LIKE                     
 _    AD-HOC           RDH*     PROGRAM                                         
 _    FINANCE          PLANF*   PLAN     FINANCE APPLICATIONS                   
 _    FINANCE          RF*      PROGRAM  FINANCE APPLICATIONS                   
 _    HELP_DESK        PLANSA50 PLAN     HELP DESK APPLICATION                  
 _    HUMAN RESOURCES  PLANH*   PLAN     HR APPLICATIONS

The Group Analysis report shows the newly defined HELP_DESK application group.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*