|Bookshelf Home | Contents | Index | PDF|
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
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.
|Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390|