DB2 Utilities › Creating Database Utility JCL › Submit Generated JCL › Generating JCL for a DB2 Utility

Generating JCL for a DB2 Utility

Follow these steps:

1. Access the Application System Construction panel for specifying the model and business system.
2. Type the Host Encyclopedia name of the model.

   You can also use the Tab key to position the cursor at the field and press the Prompt key for a list of valid choices. Select a model name from the list by typing any character except a period (.) or a space character next to one name and press Enter again.

3. Type the Host Encyclopedia name of the business system.

   You can also use the Tab key to position the cursor at the field and press the Prompt key for a list of valid choices. Select a business system from the list by typing any character except a period (.) or a space character next to one name and press Enter again.

4. Press Enter. The Application System Construction Menu displays.

   CA Gen automatically retrieves the construction library and target environment specifications that are stored in the Host Encyclopedia for the selected business system.

5. Select 4 for Generate Database Definition and press Enter.

   The Database List panel displays.

6. Type U next to the required database and press Enter.

   The DB2 Utilities panel displays.

7. Select the utility:
   • COPY
   • RECOVER
   • REORG
   • RUNSTATS
8. If a Creator ID is required to make index names in the generated JCL fully qualified, press the Tab key to position the cursor to the Creator ID field and type the DB2 Authority Code of the creator of the DB2 object.

   If you do not know whether the Creator ID is required for the utility you want to run, contact your DBA.

9. Press Enter.

   The object selection panel for the requested utility displays.

10. Type an S next to the name of each object you want processed by the selected utility. You can select more than one object at a time. CA Gen generates the required JCL for all selected objects.
11. Press Enter.

    The Specify DDL Job Statement Information panel displays. The information displays previously specified entries.

12. Type the changes to the job statement information for the JCL.
    1. To save changes and exit the panel, press End. CA Gen generates the JCL.

       The generated JCL is displayed in an ISPF Edit session (if the auto-submit option is set to No on the Generation Options panel). Review the JCL and edit it if necessary.

       If you do not intend to submit the job immediately, save it so that it can be submitted later. CA Gen does not save the job for you.

    2. To cancel changes to the job statement information and exit the panel, type Cancel on the COMMAND line and press Enter or press Cancel.
13. Type SUBMIT on the COMMAND line and press Enter to submit the job. The job runs the requested DB2 utility.