Bookshelf Home | Contents | Index | Search | PDF

Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS >

Configuring the Database Layout

---

This chapter describes the logic behind the storage control file templates that are shipped with Siebel eBusiness Applications for database schema configuration during the installation process. The primary audience for this chapter is the DB2 DBA.

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

DDL control file. The DDL control file contains the information about all Siebel tables and indexes for the current version of the Siebel eBusiness Application. The DDL control file (ddl.ctl) 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 UDB for OS/390 and z/OS.

Carefully review the storage control file (or the DDL 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.

CAUTION:  It is especially important that you review SEGSIZE, PRIQTY, and SECQTY for the table spaces that will contain the major tables for your implementation. Siebel Systems has appropriately sized the table spaces used for Siebel repository tables, but 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 eBusiness Applications with all the information necessary to create DDL for the Siebel schema in an output file (by default named schema.sql).

Bookshelf Home | Contents | Index | Search | PDF