CICS VSAM Transparency for z/OS, Version 1.2


Step 3 - Design and create the DB2 objects

The SQL data definition language (DDL) for the DB2® tables and indexes must be produced in this step. This can be done manually or by using the automated mapping facility. In most cases, your DB2 table will look similar to your file copybook, based on the outcome of the file analysis step.

However, there might be characteristics of the file that influence your ultimate table layout. For example, it is best practice to group together those columns that are most frequently updated to optimize DB2 performance and logging.

The relative position of a field in your copybook does not dictate the position of the column within the DB2 table. You can arrange the columns in your DB2 table to optimize DB2 . Every CICS® VT DB2 table must have a primary key that must be the first column or columns in the table, and a primary index must be created. This is normally designated as the clustering index.





Last updated: May 25, 2012 20:44:10