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

About Configuring Siebel Templates for Partitioning

Two of the storage control templates shipped with your Siebel eBusiness Applications are used for partitioning tables. 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.

You can identify the templates for partitioning by the characters _p in the name of the .ctl file name. (If the characters _e appear at the end of the file name, then the template is for the EBCDIC code page encoding scheme.) Both partitioning templates contain the same Siebel-recommended partitioning schema.

The Siebel partitioning scheme uses two approaches. The first approach is to partition a table based on existing columns in the Siebel schema; for example, S_OPTY is partitioned by columns in the U1 index.

The second approach partitions a table using an additional partitioning column (PARTITION_COLUMN). This column is populated with data using a BEFORE INSERT trigger option to generate the partitioning value for each row based on data from another column.