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:
|