Bookshelf Home | Contents | Index | Search | PDF

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

Partitioning Strategy

---

Partitioning is defined in Siebel storage control files. The following sample storage control files contain definitions for partitioning of Siebel tables:

storage_p_1to1.ctl. one table per table space with partitioning for ASCII
storage_p_1to1_e.ctl. one table per table space with partitioning for EBCDIC
storage_p_group.ctl. multiple tables per table space with partitioning for ASCII
storage_p_group_e.ctl. multiple tables per table space with partitioning for EBCDIC

The default partitioning scheme is based on access from the Siebel Client. Storage control files are described in detail in Configuring the Database Layout.

Requirements for which Siebel tables to partition and how to partition them are determined by the use and the size of tables in your deployment. Careful planning, requirements analysis, and monitoring are necessary to achieve optimal partitioning. You also must monitor access path and data distribution, because changes might occur that require you to repartition tables.

There are no restrictions on when you can define partitioning. You can define partitioning during installation, or you can wait until you plan to use partitioning.

Partitioning Key

Siebel Systems supports the use of any column as the partitioning key. Based on data access and data distribution, you can choose which column is best for partitioning in your implementation. Likewise, you should determine the number of partitions required in your implementation.

NOTE:  When choosing a partitioning key for a Siebel table, follow all rules, restrictions, and concerns listed in IBM DB2 documentation. These considerations include data distribution and potential updates of partitioning keys.

Partitioning Index

The partitioning index is by definition the clustering index in DB2. Therefore, by optimizing your clustering order, you optimize performance. Make sure your partitioning strategy supports more than day-to-day online access to the Siebel tables. Consider processes such as EIM, Siebel Remote, Assignment Manager, and Workflow. See Strategies for Special Types of Tables.

Bookshelf Home | Contents | Index | Search | PDF