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

Siebel Storage Control File Templates

The storage control file is unique to the DB2 for z/OS platform for Siebel Business Applications. The storage control file contains storage information (for example, partitioning indexes, table spaces, and storage groups) that is used as the basis for the storage layout of your Siebel database. Even if you are using a preconfigured storage layout, make sure that the layout is valid for your Siebel Schema.

Starting with release 7.7, the Siebel Schema layout consists of one table per table space and one table space per database. This layout reduces logging, removes concurrency issues, and allows for more databases to be used to achieve high database parallelism.

The Siebel application installation process installs three storage control file templates in the \dbsrvr\db2390 directory (Windows) or the /dbsrvr/db2390 directory (UNIX). Select one of the following templates, based on your partitioning needs, if you are using partitioning, and your encoding scheme:

• storage_np.ctl

  This template contains a database storage layout for the Siebel Schema with one table per table space, and one table space per database. No partitioned table spaces are provided.

• storage_p.ctl

  This template is the database storage layout for the Siebel Schema with partitioning for ASCII encoding. Every nonpartitioned table resides in its own segmented table space. Each table space resides in its own database.

• storage_p_e.ctl

  This template is the database storage layout for the Siebel Schema with partitioning for EBCDIC encoding. Every nonpartitioned table resides in its own segmented table space. Each table space resides in its own database.

The layouts of the storage control file templates are generic; your DBA must customize them to suit the needs of your enterprise, for example, to change the default space allocation for Siebel objects, seed data, and views.

Although Siebel-provided templates might be sufficient for your development environment without any changes, your DBA should review and modify the database storage layout to best fit the needs of your deployment in a production environment.

The storage control file templates are the starting point for your customization process. Before you select a Siebel storage control file template, you should understand how Siebel objects are grouped, and you should understand object naming conventions.