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.

Setting data set options

Use this procedure to specify options for JCL, SYSPRINT, summary, and SYSIN data sets.

Note

If the data sets do not exist, the product creates them the first time that a particular task requires them. The product creates the data sets as partitioned if you specified a member name. Otherwise, they are created as sequential.

You can enclose the data set and member name with single quotation marks. If you use quotation marks, the product uses the exact data set and name that you specify. Otherwise, the product attempts to append the data set and member name with the TSO prefix (if you have a prefix set) as the first node.

To review or change data set options

  1. Access the JCL Options panel using the procedure described in Specifying-JCL-options-in-batch-mode.

  2. In the Options field, select 2 (for Data Sets) and press Enter.

    The Data Set Options panel is displayed.

    Data Set Options panel

    PSSPODS2 ----------------------- Data Set Options -----------------------------
    Command ===>                                                                   
                                                                                  
    Specify options and press ENTER to continue.                                   
                                                                                  
    Use #### in member name to have counter variable generated into member name.   
    Counter . . . . . . . . 651  (Replaces #### in member name, then incremented)  
                                                                                  
      Note: JCL, SYSPRINT, Summary, and SYSIN data sets can be partitioned or      
            sequential.                                                            
                                                                                  
    JCL Data Set  . . . . . 'RDAGXR.SQLXPLR.CNTL(SQLX####)'                        
                                                                                  
    SYSPRINT Data Set . . . 'RDAGXR1.SQLXPLR.SYSPRINT(SQLX####)'                   
    SYSPRINT SYSOUT . . . . Y  (Y/N)      SYSOUT Class . . . *                     
                                                                                  
    Summary Data Set  . . . 'RDAGXR.SQLXPLR.SUMMARY(SQLX####)'                     
    Summary SYSOUT  . . . . Y  (Y/N)      SYSOUT Class . . . *                     
                                                                                  
    SYSIN Data Set  . . . . 'RDAGXR.SQLXPLR.SYSIN'                                 
                                                                                  
      Additional Data Set (Update)                                                 

  3. In the Counter field, type any value from 1 through 9999 to replace the '####' suffix in the PDS member name.

    If needed, the product adds leading zeros to fill the four-digit suffix.

  4. In the JCL Data Set field, type the name of the partitioned or sequential data set to which the product writes the JCL and selected options for the batch job.

    The product creates partitioned data sets if you specify a member name or sequential data sets if you omit the member name. You can enclose the data set and member name with single quotation marks. If you use quotation marks, the product uses the exact data set and name that you specify. Otherwise, the product attempts to append the data set and member name with the TSO prefix (if you have a prefix set) as the first node.

  5. Specify options for SYSPRINT data, as follows:
    1. In the SYSPRINT Data Set field, type the name of the partitioned or sequential data set to which the product writes SYSPRINT data for the job.
    2. In the SYSPRINT SYSOUT field, type Y to use a SYSOUT class or N to use a SYSPRINT data set.

    3. In the SYSOUT Class field, specify the JES message class for the SYSPRINT data set.

      You can use a wildcard in this field.

  6. Specify options for summary data:
    1. In the Summary Data Set field, specify the name of the partitioned or sequential data set to which the product writes summary data for the job.
    2. In the Summary SYSOUT field, type Y to use a SYSOUT class or N to use a summary data set.

    3. In the SYSOUT Class field, specify the JES message class for the summary data set.

      You can use a wildcard in this field.

    4. In the SYSIN Data Set field, type the name of the partitioned or sequential data set to which the product writes SYSIN data for an online job.
  7. Specify options for additional data sets:

    1. Type any character in the space beside Additional Data Sets, and press Enter.

      The Additional Data Set Options panel is displayed.

       Additional Data Set Options panel

      PSSPODS3 ----------------- Additional Data Set Options ------------------------
      Command ===>                                                                   
                                                                                    
      Specify options and press ENTER to continue.                                   
                                                                                    
        NOTE: The Update data set can only be sequential.                            
              The Update data set is needed only for Migrate Access Path Statistics.
                                                                                    
                                                                                    
      Update Data Set . . . . 'RDAGXR.SQLXPLR.UPDATE'                                
    2. In the Update Data Set field, type the name of the sequential data set to which the access path statistics for the Migrate Access Path Statistics job are written.
  8. Press Enter or END to store changes and leave the panel:
    • Press Enter to continue to the next set of options in the menu sequence.
    • Press END once to return to the previous panel, or twice to return to the main Options panel.

Related topics

Allocating-a-data-set-for-a-specific-job

Specifying-JCL-options-in-batch-mode

Explaining SQL statements


 

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