Skip to Content
Information
Space announcement: 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.

Generating REBIND JCL and DSN subcommand statements

Automatic generation of JCL and DSN subcommand statements save you significant time when performing DBA tasks such as binding application plans. All utility work and output data set space requirements are automatically calculated.

You no longer need to remember syntax or which DD statements are required. You still, however, have complete control over all processing options.

In this section, you learn how File-AID for Db2 Object Administration accumulates generated JCL in the JCL work buffer during your File-AID for Db2 Object Administration session. This JCL can then be submitted as one job or as multiple jobs. These instructions accumulate JCL for a batch REBIND. At the end of the section, you execute the work buffer contents.

What’s in this section

This section provides step-by-step instructions for generating and executing JCL and DSN subcommand statements. While performing the instructions, you learn the following techniques:

  • Excluding objects from the display and from statement generation
  • Moving statements from the DSN subcommand work buffer to the JCL work buffer

At the end of this section is information about interfacing with ISPF.

Introducing the JCL work buffer

File-AID for Db2 Object Administration places automatically generated JCL statements into a work buffer. Each time you generate a command statement, it’s appended to the work buffer and the work buffer window opens. The JCL work buffer has the same choices as the Db2 command work buffer. See About the Work Buffers.

Please read Guidelines for the Work Buffers before using the JCL work buffer.

Step-by-step instructions

These instructions generate REBIND DSN subcommand statements. The steps use the sample database provided by IBM named DSN8D11A. You can substitute any database.

An allocated PDS is required if you want to save the JCL. The JCL in this section uses the default units from your profile. Instructions for changing your default units are in Editing Your User Profiles.

The instructions in this section require BIND authority for the listed packages.

Generating the REBIND DSN subcommand statements

To get started with the navigation, follow the instructions in Displaying the Sample Database. Your window should look similar to the following figure before you continue.

Database Display. This window is maximized.

image2021-5-10_15-20-17.png

  1. Enter the TB (table detail) row command in the sequence area next to DSN8D91A.

    A window opens with a display of tables related to the database.

    Table Display Generated from Database. Objects to be excluded from REBIND PACKAGES are excluded from this display. This window is maximized.

    image2021-5-10_15-20-57.png

  2. Optional: Exclude objects from display.
    You may wish to omit a table from the REBIND PACKAGES statement generation. File-AID for Db2 Object Administration includes only those objects which are displayed. The preceding figure has several tables excluded.

  3. Execute the PACKAGES primary command in the table display window.

    The PACKAGES command displays all packages for the tables in the display list that have not been excluded. A window opens that displays dependent packages (see the following figure).

    Dependent packages List

    image2021-5-10_15-22-30.png

  4. Execute the REBIND primary command in the packages display window.

    Two parameter windows open (see the following figure):

    • Edit Package Rebind Parms (outer window)

      In this window, you can specify the REBIND parameters for File-AID for Db2 Object Administration to use. Use the Help Facility for information about any parameter.

      This window also has specific commands to open windows with information on package locations and system lists. Access Primary Command Help for information.

    • Additional Package Parms (inner window)

      The fields in this window indicate if the packages have associated package systems.

      REBIND Parameters

      image2021-5-10_15-24-20.png

  5. Press <Go> to generate the REBIND statements.

    File-AID for Db2 Object Administration opens the DSN subcommand work buffer (see the following figure). To execute an online rebind, you could press <Go> now. However, it’s more convenient to execute the REBIND statements in batch.

    DSN Subcommand Work Buffer

    image2021-5-10_15-25-45.png

  6. Execute the BATCH primary command in the work buffer.

    This command copies the statements from the DSN subcommand work buffer into the JCL work buffer with appropriate JCL statements.File-AID for Db2 Object Administration opens the work buffer (see the following figure) with the new statements appended after any previously statements. You have to scroll down to view the REBIND statements.

    Current Contents of the JCL Work Buffer. The REBIND JCL is appended to the work buffer behind any previously statements. This window is maximized.

    image2021-5-10_15-26-45.png

  7. Edit the JCL:

    1. Delete the extra job statements (rows 44 to 46 in the preceding figure).
    2. Make other changes as necessary.

    Remember that you are always responsible for the accuracy of any submitted statements. You must review each statement carefully before submitting the job.

  8. Execute the SUBMIT primary command in the JCL work buffer window.

    You receive a TSO message. You can use ISPF facilities to check on your submitted job. See ISPF Interface.

Deleting work buffer contents

Since you executed the work buffer contents in the last section, you would normally delete those statements.

The JCL work buffer window must be showing before you continue.

  1. Delete the JCL work buffer contents.

    Use the CLEAR primary command or D+ row command. You cannot use <Cancel> to delete the contents because you saved the JCL in an earlier step.

  2. Return to the DSN subcommand work buffer by pressing <End> again.
  3. Delete the DSN subcommand work buffer contents.
  4. Press <Exit> to return to the Main Menu.

ISPF interface

You can access an ISPF function or session from a File-AID for Db2 Object Administration session. You can use ISPF facilities to monitor your jobs without exiting your File-AID for Db2 Object Administration session. Use the appropriate ISPF interfacing command:

BROWSE

Invokes an ISPF Browse session.

EDIT

Invokes an ISPF Edit session.

HOLD

Invokes an ISPF session.

SPF

Displays the ISPF COMMAND field.

SPLIT

Invokes an ISPF session and splits the screen. The default <Split> key is PF2.

SWAP

Swaps session windows if both ISPF and File-AID for Db2 Object Administration are invoked. The default <Swap> key is PF9.

TSO

Executes a TSO command specified as a parameter.

 

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

BMC Compuware File-AID for Db2 21.01