Database Generation in HE › Database Definition › Database Definition Using DB2

Database Definition Using DB2

When your system uses DB2, and you select Generate data base definition in the Application System Construction Menu, CA Gen opens this Data Base List panel.

Although this panel identifies the business system, the database function applies to all business systems in the model.

The Data Base List panel supports these action codes:

U

Opens the DB2 Utilities panel to create JCL for DB2 utilities. Use the DB2 Utilities window to generate the JCL to execute one of these DB2 Utilities:

COPY

Creates an image of the selected table spaces in the database.

RECOVER

Restores the previous version of selected table spaces and indexes in the database.

REORG

Reorganizes selected table spaces or indexes to improve performance.

RUNSTATS

Updates the information DB2 uses to select index usage and improve performance.

G

Type G next to an object in the Data Base List panel to open the JCL Job Statement Information Input panel.

A

Type A as the action code next to an object Data Base List panel to open the DDL Options panel. Use the DDL Options panel to generate all the DDL and JCL to create the storage group and the database and its subordinate objects, including tables, table spaces, indexes, and index spaces.

After typing Y or N for each option, press Enter. The system opens the Generated DDL Text panel with the DDL the system generated based on your choices.

Type Go and press Enter to open the JCL Job Statement Information Input panel.

E

Type E as the action code next to a database name in the Data Base List panel to expand to table spaces. CA Gen opens the Table Space List panel.

The Table Space List panel supports these action codes:

G

Type G as the action code next to a table space name to open the JCL Job Statement Information Input panel.

A

Type A as the action code next to a table space name to open the DDL Options panel to generate DDL and JCL for the table space and its subordinate objects, including indexes and index spaces.

E

Type E as the action code next to a table space name to expand the Table List to a panel.

More information:

Set Table List Options

JCL Job Statement Information Input

Set DDL Options for a DB2 Database