Bookshelf Home | Contents | Index | Search | PDF

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

About Configuring Siebel Templates for Partitioning

---

Four of the storage control templates shipped with your Siebel eBusiness Applications are used for partitioning tables. The templates provide a set of 17 partitioned tables for the Horizontal product line, a set of 24 partitioned tables for Financial Services, and 18 partitioned tables for Siebel Industry Applications.

You can identify the templates for partitioning by the characters _p_ in the middle 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.) All partitioning templates contain the same Siebel-recommended partitioning schema; the difference between the files is how nonpartitioned tables are stored.

storage_p_1to1.ctl. Contains a partitioning scheme for a set of Siebel tables that use the ASCII encoding scheme. It also contains other nonpartitioned Siebel tables defined as one table per table space.
storage_p_1to1_e.ctl. Contains a partitioning scheme for a set of Siebel tables that use the EBCDIC encoding scheme. It also contains other nonpartitioned Siebel tables defined as one table per table space.
storage_p_group.ctl. Contains a partitioning scheme for a set of Siebel tables that use the ASCII encoding scheme. Most of the nonpartitioned tables are defined as multiple tables per table space.
storage_p_group_e.ctl. Contains a partitioning scheme for a set of Siebel tables that use the EBCDIC encoding scheme. Most of the nonpartitioned tables are defined as multiple tables per table space.

NOTE:  Table spaces that contain groups of tables are segmented.

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 a new 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.

Bookshelf Home | Contents | Index | Search | PDF