Limited support BMC 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 Catalog Manager for Db2 13.1.

Using the BATCH command for a Db2 object list or a mixed list

You can run a batch command in a Db2 object list or mixed list.

Related topic

Generating-JCL-for-a-job-in-batch

  1. Generate a list:

  2. If you generated an object list, type command BATCH, DSNcommand BATCH or DB2command BATCH in the Cmd column of the source object, and press Enter.You can use any of the following commands:

    command

    DSNcommand

    DB2command

    CASCADE

    BIND

    DISPLAY

    CONNECT (can only be issued from a location (LO) list)

    FREE

    START

    DCL

    REBIND

    STOP

    DDL



    DES



    DESCRIBE



    DESTATISTICS



    HDDL

    (BMC.DB2.SPE2307) The OPTS and OPT options are not available in BATCH. To accomplish this function in batch, you should enter OPT 2 from the command line before entering the HDDL BATCH or HTDDL BATCH commands.



    HGRANT



    Catalog Manager displays the following message:

    BMC14651 Use BATCH command to generate JCL for all saved commands.

  3. In the Cmd column of the source object or on the Command line, type BATCH and press Enter.The Catalog Manager Batch Job panel is displayed.

    DEFF-------------------------  Catalog Manager Batch Job  ----------
    Command ===>
     JCL Dataset  . . .  'RDACRJ.DBDC.JCL(BATCH)'
     Set JCL options. .  N     (Y/N - Change options for creating JCL)
     Build Job  . . . .  Y     (Y/N - Create JCL, save in JCL dataset)
     Edit Dataset . . .  Y     (Y/N - Edit JCL dataset)
     Submit . . . . . .  N     (Y/N - Submit JCL dataset)
    --------------------------------  Job Options  -------------------------------
     Ssid . . . . . . .  DEDK     The ssid of the DB2 which batch is to connect to
     Default options  .  DC91QEDK The name of the default options to use in batch
     HDDL output dsn     &ZUSER..&SSID..HDDL
  4. In the JCL Dataset field, specify the member name of a partitioned data set.This field indicates the name of the data set in which the generated JCL will be stored.
  5. In the Set JCL options field, type Y to view the JCL Generation Options panel, from which you can specify the values for options that control operations.
  6. When the JCL Generation Options panel is displayed, press END to return to the Catalog Manager Batch Job panel.
  7. In the Build Job field, type Y to create the JCL and save it in the specified JCL data set.

  8. In the Edit Dataset field, type Y to edit the JCL data set.

    Note

    The I parameter in the CATBATCH step identifies whether you are connected to an indirect catalog (I=YES) or a direct (real) catalog (I=NO). The collection ID for indirect access is obtained from the installation options module.

    //CATBATCH EXEC PGM=ACTBMAIN, 
    // PARM='O=DC1211DO,S=DEEG,I=NO,V=DEEGCAT', 
    // REGION=0M

  9. In the Job Options section of the panel, specify your options for the batch processor:

    Note

    Ensure that the Ssid and Default options fields specify values for the local Db2 SSID.

    1. To specify a different SSID to which the batch processor will connect, type the name of the SSID.The value displayed for the SSID field is the current SSID, not the value saved in the ISPF profile.
    2. To specify the installation options module, type the name of the module in the Default options field.The value displayed in the Default options field is the current installation options module, not the value saved in the ISPF profile.
    3. (DCL, DDL, HDDL, and HGRANT commands) To specify the name of the sequential data set for output, in the HDDL output dsn field, type the name.If this data set does not exist, Catalog Manager prompts you to allocate it when you build the job.
  10. Press Enter.The generated JCL is displayed in an ISPF edit session.

  11. (optional for the CONNECT command) Modify the CONNECT statement in the SYSIN input stream to add the CONNECT command parameters.The command parameters are defined in Connecting-to-a-specified-SSID.

    Warning

    BMC strongly recommends that you exercise caution when modifying the commands in the SYSIN input stream. Using the incorrect syntax could produce unpredictable results.

  12. (optional for the Db2 DISPLAY, START, or STOP command) Modify the Db2 commands in the SYSIN input stream to specify objects.

    Warning

    BMC strongly recommends that you exercise caution when modifying the commands in the SYSIN input stream. Using the incorrect syntax could produce unpredictable results.

    The following table describes the command syntax.

    Command syntax

    Valid object lists

    Valid object types

    DISPLAY objectType objectName

    DB, TS

    DB, TS, FN 1 , PR 1

    START objectType objectName

    DB, TS, FN 1 2 , PR 1 2

    STOP objectType objectName

    DB, TS, FN 1 2 , PR 1 2

    1Part 1 of objectName cannot exceed 8 characters, and part 2 cannot exceed 18 characters.

    2Because of a Db2 restriction, you cannot issue the command for this object on a remote Db2 SSID.

  13. (optional for the HDDL command) For a database list, specify the name of a partitioned data set for output by adding PDS=dataSetName to the SYSIN input stream.
  14. Press END to return to the 0 Batch Job panel.
  15. In the Submit field, type Y to submit the JCL.

 

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