Database Generation in HE › Generation Steps

Generation Steps

The following procedure shows a typical activity sequence to generate a database definition for a model:

Follow these steps:

1. Generate the JCL and DDL for the entire database system or the required database objects.
2. Review and edit the generated DDL.
3. Save the job if you do not intend to submit it immediately. CA Gen does not save the job for you.
4. Use the SUBMIT command to submit the job that creates the database objects.

CA Gen allows you to generate any or all of the subordinates from the object level.

The DB2 database objects and the subordinates at each level are:

Database

Table Spaces, Tables, Index Spaces, Indexes

Table Space

Tables, Index Spaces, Indexes

Table

Index Spaces, Indexes

Index Space and Index

No subordinates

Complete the Data Store List and Data Structure List before creating the database because Database generation uses these lists as its primary source of information about the databases.