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

Performing a Custom Installation

Perform the steps in the following procedure to complete a custom Siebel Database installation.

This task is a step in Process of Performing a Custom 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 15).
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 apply the schema.sql and ddlview.sql files on the DB2 host, validate the schema, install user-defined functions, and populate the Siebel Schema with seed data.

       For information on performing these tasks, see Completing the Siebel Schema Installation Using Generated DDL.

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