Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Apptune for Db2 13.1.

Generating a list of packages to Explain

Use the following procedure to generate a list of packages to Explain.

  1. Access the Explain Object Specification panel.

    The method varies depending on the product:

    • On the BMC AMI SQL Explorer for Db2 Main Menu, type 1 (for Explain), change the SSID and DDF locations if necessary, and press Enter.
    • On the BMC AMI Apptune for Db2 Main Menu, select Explain Interface and press Enter.
    • On the BMC AMI Ops Monitor for Db2
       - DC Main Menu, select Explain Interface and press Enter.

    The  Explain Object Specification panel is displayed.

    Note

    The product recognizes only the information that applies to the object type that you specify.

    Example

    If you specify to Explain a package, the product ignores information in the Plan or DBRMLIB fields. You do not need to remove any unrelated values before proceeding.

    PSSPA110 ---------------- Explain Object Specification ------------------------
    Command ===>                                                                   
                                                                                  
    Type  . . 2  (1=Plan, 2=Package, 3=UNAVAIL, 4=DBRMLIB, 5=Ad Hoc SQL)           
                                                                                  
    Plan:                                                                          
      Name                                                                         
                                                                                  
    Package:                                                                       
      COLLID  GXRALIAS          Name . . . PSSXSQL                           
      Version %                                                                    
                                                                                  
    DBRMLIB:   (Specify PDS with member name or wildcard member.)                  
      DSN . .                                                                      
                                                                                  
    Processing Mode:  B      (L=List object(s),                                 
                                   B=Batch Explain with specified objects)           
                                                                                  
    List Valid and Operative packages ONLY:  N  (Y/N)                              
                                                                                  
      Explain Options   
  2. In the Type field, select Package.

  3. In the Package: COLLID field, type the name of the package collection.

    You can use wildcards in this field.

    Tip

    If the information is truncated, place your cursor on the field, and press F4 or F6 (ZOOM). The contents of the entire field are displayed in a pop-up window.

  4. In the Package: Name field, type the name of the package that you want to Explain.

    This name is the one used when the package was bound. You can enter a specific name, or use wildcards to display a list and select the package from the list. If the Name information is truncated, place your cursor on the field, and press F4 or F6 (ZOOM). The contents of the entire field are displayed in a pop-up window.

  5. In the Package: Version field, type the version identifier for the package.

    You can type a specific version, use wildcards, or leave the field blank (for packages that do not use a version). If the package that you want to Explain has a version but you leave this field blank, the package does not appear in your results.

    Tip

    BMC recommends using a wildcard because package versions can contain mixed-case characters or timestamps and can be long and difficult to remember.

  6. In the Processing Mode field, select List object(s) to view a list of object specification criteria.

  7. (BMC.DB2.SPE2110)

     In the List Valid and Operative packages ONLY field, select one of the following options:

    • Y specifies whether to display only valid and operative packages.
    • N specifies whether to display ALL packages. (default)

    Note

    This option is applicable to List option. It can't be combined with Batch Explain. Batch Explain processes valid and operative packages only.  

  8. In the Explain Options field, type any character in the space beside the field, and press Enter.

    The Explain Options panel is displayed.

  9. Specify options for the Explain.

    The Explain Object Selection List panel is displayed.

    FILE  COMMANDS  OPTIONS  HELP                                                
    -------------------------------------------------------------------------------
    PSSPE100                    Explain Object Selection List            2 Objects
    Command ===>                                                  Scroll ===> CSR  
                                                                     More:       >
       Actions: S H R RS RW RI XD XS XC XP XB                                      
       COLLID           NAME     VERS     OWNER    VALID OPER REOPT VALIDATE ISOLAT
       GXRV12PL         DOTSQL   PGMV1    RDAGXR   Y     Y    N     B        S     
       GXRV12PL         DOTSQL   PGMR_RDA RDAGXR   Y     Y    N     B        S     
    ******************************** Bottom of Data *******************************

 

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