Implementing Siebel Business Applications on DB2 UDB for z/OS > Understanding Siebel Partitioning >

Partitioning and the Storage Control Files

Partitioning is defined in Siebel storage control files. You can use either of the following storage control file templates shipped with your Siebel Business Applications to partition tables:

• storage_p.ctl. This template is the database storage layout for the Siebel Schema with partitioning for ASCII 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 Database Layout.

Both 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 Business Applications' 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.