Implementing Siebel Business Applications on DB2 for z/OS > Installing the Siebel Database on the DB2 Host >

Performing a Custom Installation

This task is a step in Process of Performing a Custom Installation.

This topic describes how to perform a custom Siebel database installation using the Database Configuration Wizard.

When you select the Install Database option on the Database Configuration Wizard, you can choose the installation mechanism to use: either Run DDL Automatically or Generate DDL Into Files. If you select the Run DDL Automatically option, performing the steps in the following procedure completes the custom Siebel database installation.

If you select the Generate DDL Into Files option, after performing the procedure in this topic, you must also complete the tasks described in Completing the Siebel Schema Installation Using Generated DDL to complete your custom Siebel database installation.

To perform a custom installation

1. Launch the Database Configuration Wizard and follow the steps described in Performing a Standard Installation until the Select Installation Type screen appears (Step 17).
2. Select the Customized Install option, and click Next.
3. In the Storage Control File screen, enter the name of the customized storage control file that you want to use to configure storage on the DB2 host. You can use the Browse button to navigate to this file.

   To continue, click Next.

4. In the Select Installation Mechanism screen, indicate which installation mechanism you want to use:
   • Generate DDL into Files

     Select this option to generate the DDL required to create the Siebel Schema into a file. You must later use Siebel-provided scripts, your own FTP, or a similar file transfer program to transport the DDL (schema.sql and ddlview.sql) to the DB2 host, where the DBA executes it, using customary methods, for example, SPUFI.

     To continue, click Next and proceed to Step 5.

   • Run DDL Automatically

     Select this mechanism to apply the DDL and DML required to create the Siebel Schema directly against the database.

     The Siebel application uses ODBC to apply all necessary steps in this installation method.

     To continue, click Next and proceed to Step 7.

5. On the DDL Commit Frequency screen, choose the number of DDL statements to be run before a COMMIT statement is issued. Click Next.
6. In the Output Directory screen, specify the name of the directory where you want to save the Siebel Schema DDL files that are generated. The default directory is DBSRVR_ROOT\db2390\dboutput\install (Windows) or DBSRVR_ROOT/db2390/dboutput/install (UNIX).
7. On the Log Output Directory screen, indicate the directory where you want the install log files to be generated, and click Next.

   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 Upgrade Wizard is launched.
   • If you selected the Run DDL Automatically installation option, the Siebel Upgrade Wizard applies the DDL commands to create the Siebel Schema directly against the database on the z/OS host. When you receive a message stating that the configuration was applied successfully, click OK.

     This step completes the Run DDL Automatically installation option.

   • If you selected the Generate DDL Into Files installation option, click OK to continue, and the Siebel Upgrade Wizard generates the following files into the output directory that you designated in Step 6.
     • schema.sql and ddlview.sql files. These contain the DDL to create the Siebel tables and indexes.
     • instftp.bat. Use this batch file to run the Siebel-provided scripts, your own FTP, or a similar file transfer program to transport the DDL (schema.sql and ddlview.sql) to the DB2 host.
     • instftp.txt. Use this file to transfer files to the mainframe.
     • jobinstl.txt. Contains JCL and REXX execs to execute the DDL.

       To complete the installation process, you must now perform the steps in Completing the Siebel Schema Installation Using Generated DDL to apply the schema.sql and ddlview.sql files on the DB2 host.

When you have successfully completed the installation, you are ready to import the Siebel Repository. For further information, see Importing the Siebel Repository.