Database generation creates the databases that implement a data model from diagrams that are completed in the workstation toolsets. The host tool uses the completed Data Structure List (DSL) and Data Store List (DOL) to generate the data definition language (DDL) statements and JCL to create the database objects.
The Data Store List and Data Structure List are CA Gen workstation tools, which are based on the model's Data Model, that define databases. The Data Model is a conceptual representation of the information in the application. The Data Store List and Data Structure List are a physical representation of the information.
Transform the Data Model on the workstation to create the data structure. This provides a suggested database design that the Database Administrator (DBA) modifies.
Transformation uses a rule-based approach to examine the Data Model objects and determine appropriate implementation. CA Gen generates the objects, associations, and properties. Use the data structure tools to refine the lists the transformation process generates.
The database generation tool also generates the JCL for DB2 utilities. The utilities help maintain database integrity through backup and restore, and monitor and tune your DB2 databases. The tool supports the COPY, RECOVER, REORG, and RUNSTATS utilities.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|