Implementing Siebel Business Applications on DB2 for z/OS > Customizing a Development Environment >

Cloning a DB2 for z/OS Database

You can clone your existing Siebel database to a target database. The DB2 system cloning process involves the following steps:

1. Extracting a Storage Control File from the DB2 Catalog

   Extract a storage control file from the existing Siebel Schema.

2. Generating a DDL File from a Storage Control File

   Use the extracted storage control file to generate a DDL file, then apply the DDL file to the database to create a clone of the Siebel Schema.

Generating a DDL File from a Storage Control File

Use the following procedure to generate DDL from a storage control file.

To generate a 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 17).
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.

11. Apply the DDL files using either an optional process provided by Siebel Business Applications or any other tools used in your company for applying DDL.

    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.