1. Implementing Siebel Business Applications on DB2 for z/OS
  2. Partitioning and the Storage Control Files

Partitioning and the Storage Control Files

Partitioning is defined in the Siebel storage control files. You can use one of the following storage control file templates provided with Siebel CRM to partition tables:

  • storage_p.ctl. This template is the database storage layout for the Siebel Schema with partitioning for ASCII encoding.

  • storage_p_u.ctl. This template is the database storage layout for the Siebel Schema with partitioning for Unicode encoding.

  • storage_p_e.ctl. This template is the database storage layout for the Siebel Schema with partitioning for EBCDIC encoding.

Storage control files are described in detail in Configuring the Siebel Database Layout.

Each of the partitioning storage control file templates contain the same Siebel-recommended partitioning schema. The templates provide a set of 17 partitioned base tables for the Horizontal product line and a set of 24 partitioned base tables for Siebel Industry Applications. The default partitioning scheme is optimized for online activities from the Siebel Client.

Siebel CRM’ partitioning templates provide 10 partitions for each partitioned table. You select the number of partitions for your implementation based on your business needs, and define partitioning keys based on the number of partitions.

If you want to customize the Siebel table-partitioning layout, you can do so by editing the appropriate storage control file template directly. Alternatively, you can use the Siebel Database Storage Configurator (dbconf.xls) to modify the template (recommended). For more information, see Partitioning Tables and Indexes Using the Database Storage Configurator.