Database definition describes the physical storage of the database objects that are identified by the database design. CA Gen creates the database definition that is based on the information in the completed Data Store List and the Data Structure List stored in the Host Encyclopedia.
For DB2 users that omit the Storage Group option, CA Gen generates IDCAMS control statements to define the VSAM storage allocation for table spaces and index spaces. CA Gen also generates the JCL to execute the SQL DDL statements and IDCAMS control statements.
CA Gen uses the DBMS selected on the Target Environment panel to implement the databases, and uses SQL as the data definition language (DDL) to define the databases.
CA Gen allows you to select the objects for which to generate DDL:
You can generate the JCL and DDL for the entire database system, or for selected objects, as needed.
Use the ISPF Edit commands to review and make changes to the generated JCL and DDL. Use the SUBMIT command to submit the job that allocates the data sets and creates the database objects.
CA Gen does not automatically save the generated JCL and DDL. When you plan to submit the job later, save it. After the job executes successfully, delete it. If you regenerate the DDL for an object, CA Gen creates a job.
To open the database generation panels, select Option 4, Generate data base definition on the Application System Construction Menu.
As it creates the database definition, CA Gen moves through a series of panels. The section Database Definition Using DB2 describes the panels when your system uses a DB2 DBMS.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|