Implementing Siebel Business Applications on DB2 for z/OS > Configuring the Siebel Database Layout >

Control Files Used in the Siebel Installation

The Siebel Database Schema installation process uses two types of Siebel control files:

• DDL control file

  The DDL control file contains the logical definitions for all Siebel tables and indexes for the current version of Siebel Business Applications. The DDL control file (ddl.ctl or schema.ddl) is read-only to protect the integrity of the Siebel data model.

• Storage control file

  The storage control file contains the physical database layout. The storage control file is specific to DB2 for z/OS.

  Carefully review the storage control file (or the resulting schema.sql file that is based on the storage control file) and adjust the database layout to satisfy your database requirements. You can modify any option available for each database object, for example, by fine-tuning FREEPAGE and PCTFREE for a particular table space or a group of table spaces.

  NOTE:  It is especially important that you review SEGSIZE, PRIQTY, and SECQTY for the table spaces that are to contain the major tables for your implementation. The table spaces used for Siebel Repository tables are appropriately sized. However, because sizing requirements for base Siebel tables vary from deployment to deployment, it is your responsibility to set storage parameters capable of accommodating your installation.

Together, the DDL control file and the storage control file provide Siebel Business Applications with all the information necessary to create DDL for the Siebel Schema in an output file (by default named schema.sql).

You can choose either of two methods to execute the SQL files from a designated Siebel Server:

• Automatic execution from the Siebel Server using an ODBC utility (such as odbcsql) or a version control tool for file execution. To use this method, review Configuration Options for DB2 Connect to determine the configuration appropriate to the Client your enterprise supports, and then follow the instructions in About the Required IBM Fix Packs.
• Direct execution on the DB2 host using Siebel-provided scripts, your own FTP, or any other file transfer program to transfer files to the DB2 host, and then use a native IBM utility, such as SPUFI for file execution.

  NOTE:  If you want to execute SQL using mainframe native tools, refer to the IBM documentation.