Testing Host Encyclopedia Construction › Generate DB2 Objects

Generate DB2 Objects

This procedure creates the DDL and JCL statements that allocate and construct DB2 objects.

Follow these steps:

1. Select option 4 on the Application System Functions Menu and press Enter.

   The Data Base List screen displays.

2. Type A in the Opt column, next to the database name GENDB, and press Enter.

   The DDL statements and VSAM definitions for the database are generated and the DDL Options screen displays.

   The database name is used to generate JCL to create DB2 objects. You can change the name in the generated DDL without adverse effects on the application.

3. Type Y or N for the options on the DDL Options screen and press Enter.

   The Generated DDL Text screen displays the DB2 objects for which DDL is generated.

4. Type GO on the command line and press Enter.

   The JCL Job Statement Information Input screen displays.

5. (Optional) Type a job card for the JCL containing DDL for the CA Gen Sample Model, or change the default job card.
6. Press Enter to create the DDL and JCL to generate DB2 objects.

   The generated JCL displays in ISPF edit mode.

7. (Optional) On the JCL, you can change the following entities:
   • DB2 VSAM names
   • Volumes
   • Tablespace names
   • Index names

   Note: Do not change the table or column names here. Instead, check out the model and change the names in the model at your workstation.

   The JCL for DDL resides in a data set allocated as:

   <userid>.TICTEMP1.TIDDLJCL
   

   or

   <userid>.TICTEMP2.TIDDLJCL
   

   If the database is preallocated, delete the lines in the JCL for creating the database.

8. Submit the job to create database objects.
9. Verify the job that is completed successfully.
10. Continue pressing F3 until you return to the Application System Menu.