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

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 under Windows

1. Launch the Database Server Configuration utility and follow the steps in Performing a Standard Installation Under Windows until the Select Installation Type screen is displayed (Step 12).
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. 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.
8. The runnow screen appears, giving you the choice of applying the configuration now or later.

   To apply the configuration later, navigate to the SIEBSRVR_ROOT\bin directory and enter the following from the command line:

   siebupg.exe /m master_install_mf.ucf

   Click Ok to continue and the Configuration Parameter Review screen appears.

9. Review the parameters, and then click Finish.

   When the Siebel Upgrade Wizard launches, click OK to continue.

10. When the DDL file is 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

11. Select Yes.

    The following schema 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.

    • schema.sql
    • ddlview.sql

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

To generate the DDL file under UNIX

1. Launch the Database Server Configuration utility and follow the steps in Performing a Standard Installation Under UNIX until the Select Installation Type screen is displayed (Step 16).
2. Select option 2- Customized Install.
3. In the Storage File screen, specify the storage control file you want to use to generate the DDL.
4. Select the option 1- Generate DDL Into a File installation mechanism.
5. In the DDL Commit Frequency screen, choose the number of DDL statements that can be run before a COMMIT statement is issued.
6. Specify the DDL output directory, for example, $DBSRVR_ROOT/db2390/dboutput/install.
7. Specify where you want the log files to be created on the Common Parameters screen.
8. Review the configuration parameters and then enter 1 (Yes) to launch the Siebel Upgrade Wizard (srvrupgwiz).
9. When the DDL files are created, a message appears stating that the schema.sql and ddlview.sql files have been generated in the DDL Output Directory.
10. Exit from srvrupgwiz. You can now apply the schema.sql and ddlview.sql files on the DB2 host to create a clone of the Siebel Schema.

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