Skip to Content

Default language.

Information
Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

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 SQL Explorer Main Menu, type 1 (for Explain), change the SSID and DDF locations if necessary, and press Enter.
    • On the APPTUNE Main Menu, select Explain Interface and press Enter.
    • On the MainView for DB2 - DC Main Menu, select Explain Interface and press Enter.

    The Explain Object Specification panel is displayed in Following Figure.

    Warning

    Note

    The product recognizes only the information that applies to the object type that you specify. For example, if you specify to Explain a package, any information existing in the plan, DBRM, or DBRMLIB fields is ignored. You do not need to remove any of the unrelated values before proceeding.


    PSSPA110 ---------------- Explain Object Specification ------------------------
     Command ===>                                                                   
                                                                                   
     Type  . . 2  (1=Plan, 2=Package, 3=DBRM, 4=DBRMLIB, 5=Ad Hoc SQL)              
                                                                                   
     Plan:                                                                          
       Name    DYNSTAPL                                                             
                                                                                   
     Package:                                                                       
       COLLID  C9AN31C              Name . . . *                                    
       Version *                                                                    
                                                                                   
     DBRM:                                                                          
       Plan    V10LGUPL              Name . . . *                                    
                                                                                   
     DBRMLIB:   (Specify PDS with member name or wildcard member.)                  
       DSN . . 'PSS.TESTING.V10.DBRM(V10TEST1)'                                       
                                                                                   
     Processing Mode:  L         (L=List object(s),                                 
                                  B=Batch Explain with specified objects)
  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.

    Success

    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.

    Success

    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. In the Explain Options field, type any character in the space beside the field, and press Enter.The Explain Options panel is displayed.

  8. Specify options for the Explain.For instructions, see Specifying-Explain-options.

    The Explain Object Selection List panel is displayed in Following Figure.

      FILE   COMMANDS   OPTIONS   HELP
    -------------------------------------------------------------------------------
    PSSPE100                    Explain Object Selection List            7 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
        C9AN31C          TR003A            C9AN31C  Y     Y    N     B        S     
        C9AN31C          TR004A            C9AN31C  Y     Y    N     B        S     
        C9AN31C          TR00BA            C9AN31C  Y     Y    N     B        S

Related topic

Explaining-SQL-Statements



 

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

MainView for DB2 6.1