Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

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.

Explaining a package in batch

Use the following procedure to perform a batch Explain on a package.

To perform a batch Explain

  1. Generate a list of packages to Explain.For instructions, see Generating-a-list-of-packages-to-Explain.
  2. Specify options for the Explain.For instructions, see Specifying-Explain-options.

  3. In the space beside an object or statement, type XB, and press Enter.The Batch Explain Type panel in the Following Figure  is displayed.

    PSSPA116              Batch Explain Type                               
                                                                          
    Explain Type . . . 1  1. XD=Explain Dynamic                            
                          2. XS=Explain Static from bind with EXPLAIN(YES)
                          3. XC=Explain Compare Dynamic and Static Explains
  4. Specify the batch Explain Type as follows:
    • XD performs a dynamic Explain.
    • XS performs a static Explain.
    • XC compares a dynamic Explain and a static Explain.
  5. Press Enter.The Batch Job panel is displayed. (See a sample panel in Specifying-JCL-options-in-batch-mode).

  6. Specify options for the batch Explain.For instructions, see Specifying-JCL-options-in-batch-mode. You can also change the layout data set using the Data Set Options panel (see the panel in Step 7).

    Warning

    Note

    If any of the data sets do not exist, the Allocate Data Set panel is displayed (see the figure in Allocating-a-data-set-for-a-specific-job).

  7. (optional) Customize the display of your batch Explain:

    1. In the Set JCL Options field, type Y, and press Enter.The JCL Options panel is displayed in the Following Figure .

      PSSPOJ00 ------------------------- JCL Options --------------------------------
      Command ===>                                                                   
                                                                                    
      Specify one of the options and press ENTER to continue.                        
                                                                                    
      Options   2 1. SMS Classes                                                     
                  2. Data Sets                                                       
                  3. Job Cards

    2. In the Options field, select Data Sets, and press Enter.The Data Set Options panel in Following Figure  is displayed.

      PSSPODS1 ----------------------- Data Set Options -----------------------------
      Command ===>                                                                   
                                                                                    
      Specify options and press ENTER to continue.                                   
                                                                                    
      Use #### in member name to have counter variable generated into member name.   
      Counter . . . . . . . . 13   (Replaces #### in member name, then incremented)  
                                                                                    
        Note: The JCL, SYSPRINT, and Summary data sets can be partitioned or         
              sequential.  The Layout data set must be partitioned with a member     
              name specified.                                                        
                                                                                    
      JCL Data Set  . . . . . 'RDAKNN.SQLXPLR.CNTL(SQLX####)'                        
                                                                                    
      SYSPRINT Data Set . . . 'RDAKNN.SQLXPLR.SYSPRINT(SQLX####)'                    
      SYSPRINT SYSOUT . . . . Y  (Y/N)      SYSOUT Class . . . *                     
                                                                                    
      Summary Data Set  . . . 'RDAKNN.SQLXPLR.SUMMARY(SQLX####)'                     
      Summary SYSOUT  . . . . Y  (Y/N)      SYSOUT Class . . . *                     
                                                                                    
      Layout Data Set . . . . 'BMCPERF.BMCSAMP(PSSREPA)'
    3. Verify that the options on the panel are correct, and press Enter.The Job Card Options panel is displayed .
    4. Specify job card options as needed, and press Enter.The JCL Options panel is displayed in Following Figure .
  8. Press F3 to display the generated job.
  9. Review and submit the batch Explain job.

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