Implementing Siebel Business Applications on DB2 UDB for z/OS > Customizing a Development Environment > Process of Cloning a DB2 for z/OS Database >

Generating a DDL File from a Storage Control File

This task is a step in Process of Cloning a DB2 for z/OS Database.

When you have extracted a storage control file from the existing Siebel database, use this storage control file to generate a DDL file. You can then apply the DDL file to the database to create a Siebel Schema clone.

To generate the DDL file

1. Launch the Database Configuration Wizard and follow the steps in Performing a Standard Installation until the Select Installation Type screen is displayed (Step 15).
2. Select the Customized Install option, and then click Next.
3. Specify the storage control file you want to use to create the DDL, and click Next.
4. In the Select Installation Mechanism screen, select the Generate DDL Into Files option, and click Next.
5. On the DDL Commit Frequency screen, choose the number of DDL statements that can be run before a COMMIT statement is issued, and click Next.
6. In the Output Directory screen, specify the location of the directory in which the DDL is to be created, for example, DBSRVR_ROOT\db2390\dboutput\install (Windows) or DBSRVR_ROOT/db2390/dboutput/install (UNIX). Click Next.
7. In the Log Output screen, specify the directory where log files are to be created or accept the default. Click Next to continue.

   By default, the files are created in SIEBSRVR_ROOT\log\install_mf (Windows) or SIEBSRVR_ROOT/log/install_mf (UNIX).

8. Save the configuration information you have entered and launch the Siebel Upgrade wizard as described in the following topics:
   • Running the Database Configuration Wizard Under Windows
   • Running the Database Configuration Wizard Under UNIX
9. Press Ok and the Wizard generates DDL from the storage control file you specified in Step 3 into the output directory that you designated in Step 6.

   When the DDL files are created, the following message appears.

   Files schema.sql and ddlview.sql with the Siebel Schema modifications have been generated in the DDL Output Directory. Please select Yes to exit now and apply the files

10. Select Yes.

    The schema.sql and ddlview.sql files are created and can be applied using either an optional process provided by Siebel or any other tools used in your company for applying DDL.

NOTE:  If you want to clone the Siebel Schema into more than one database, copy the generated DDL files, replace the schema qualifier in the DDL files, and then save the files under a new name.