Skip to Content

Using the BATCH command for a Catalog Manager list or search

Related topics

Generating JCL for a job in batch

You can use a batch command in a Catalog Manager list or search.

  1. On the Command line of a Primary Menu panel or a list panel, type BATCH, and press Enter.The Catalog Manager Batch Job panel is displayed.
  2. In the Build Job field, type Y to create the JCL.

  3. Near the bottom of the JCL, find the NO CATALOG MANAGER COMMANDS message in the SYSIN stream (the following table).

     File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help
    ------------------------------------------------------------------------------
    ISREDDE2   RDACRJ2.BMCCAT.JCL                              Columns 00001 00072
    Command ===>                                                  Scroll ===> CSR
    000098 //SYSIN    DD *
    000099 DSN=RDACRJ2.DEDK.HDDL
    000100 NO CATALOG MANAGER COMMANDS
    000101 //*--------------------------------------------------------------------
    000102 //* END OF JOBSTEP
    000103 //*--------------------------------------------------------------------
    000104 //*--------------------------------------------------------------------
    000105 //* END OF JOB
    000106 //*--------------------------------------------------------------------
    ****** **************************** Bottom of Data ****************************

  4. Type over the message with one or more of the following commands (each on a separate line):

    • DOPTS
    • DSNZPARM

    • ENVI

      If you are connected to a remote Db2 SSID, the ENVI command does not display the following information:

      • Catalog Manager plans
      • Collections other than the default collection
      • Catalog Manager table synonyms
      • Db2 catalog synonyms

    • LIST type qualifier

      The variable type is a two-character object type, and the qualifier is a character string.

    • LIST MX type qualifier

      The variable type is a two-character object type (DB, FK, PG, PL, PR, SG, TB, TR, TS, TT, XT, or VW), and qualifier is a fully qualified name.

    • SEARCH type savedSearchName

      The variable type is a two-character object type, and savedSearchName is the qualified name for the search variables.

    • SEARCH type whereExpression

      The variable type is a two-character object type, and whereExpression includes the search variables for a WHERE clause.

    Warning

    Important

    Do not include the WHERE operator in the whereExpression. The maximum number of characters permitted is 48.

  5. Press END to return to the Catalog Manager Batch Job panel.
  6. 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*

BMC AMI Catalog Manager for Db2 13.1