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

About Installing the Siebel Schema


When you choose the Install Database option on the Database Server Configuration utility to install the Siebel Schema, the program:

  • Creates Siebel tables and indexes in a specified database storage layout
  • Installs Siebel triggers (optional) and views
  • Installs Siebel seed data specific to your database

If you are installing to multiple environments, you must repeat the installation of Database Server components for each environment.

Installation Modes

You can create the Siebel Schema using one of two modes—standard or customized.

  • Standard Install

    If you choose the standard installation option, you perform all installation tasks using the Database Server Configuration utility. A standard install creates a Siebel preconfigured database layout.

  • Customized Install

    If you choose the custom installation option, you provide a storage control file, which you create and validate prior to performing the installation using the Database Server Configuration utility, to create the custom database layout that is most suitable for your Siebel deployment.

Installation Mechanisms

You can choose whether the DDL used to create the Siebel Schema is automatically applied against the DB2 host or is applied manually. You can execute the DDL directly against the database by choosing the Run DDL Automatically option. Alternatively, by choosing the Generate DDL Into Files option, you can assign the DDL to an output file for later transfer to the DB2 host (using Siebel-provided scripts, your own FTP, or another file transport program) where the DBA applies the DDL using customary tools.

NOTE:  The Upgrade Wizard is the Siebel utility used for database server installation, upgrade, and database manipulations. The utility is launched by the Database Server Configuration utility. In Windows, the Siebel Upgrade Wizard is designated as siebupg.exe. In UNIX, it is designated as srvrupgwiz and is located in the $SIEBSRVR_ROOT/bin directory.

Installing a New Database Language

Each time you install a new database language, you must reinstall the Siebel Database Server components by launching the Database Server Configuration utility and choosing Siebel Database Server Options > Install Database> Add a language to an existing database.

CAUTION:  If you add a new language after completing your initial installation, when the Database Server Configuration wizard launches and you are prompted to enter the Gateway Name Server Address and the Enterprise Server Name, leave these fields blank. If you enter values in these fields, an error occurs.

Implementing Siebel Business Applications on DB2 UDB for z/OS