Create a DB2 z/OS Table Partition › Perform Transformation

Perform Transformation

Transformation converts the logical data model into a physical data model referred to as the Technical Design (TD).

Important! Transformation deletes the existing TD and creates a TD based on the data model and technical design defaults.

Perform a transformation to create general and DBMS-specific TD objects from data model objects.

A Technical Design defines the physical model where logical objects are implemented. During Transformation, CA Gen builds a general TD for each supported DBMS and a specialized DBMS-specific TD for the target DBMS for the entire model.

CA Gen represents the implemented technical design in the Data Structure List and Data Store List. Data Structure List contains tables that can be expanded into columns, indexes, and constraints. Data Store List contains databases that expand into Tables, Tablespaces, Indexes, and Identifiers. Together the Data Structure List, and Data Store List make up the physical representation of the data model and collectively they are referred to as the Technical Design.

Follow these steps:

1. Navigate to the location of the model and open it.
2. Select Design, Technical Design.

   The Technical Design window opens.

3. Select Technical Design DB2 z/OS and click Diagram, Open.
4. Technical Design DB2 z/OS has two '*' beside it indicating that DB2 z/OS is the default option.
5. Click Tool, Design, Transformation.

   The Transformation (DB2 z/OS) dialog opens.

6. Click Proceed.

   The Transformation completes and the status information is displayed.

7. Click OK to close the Note dialog.