About Siebel Table Partitioning

This chapter provides information on partitioning large tables in Siebel CRM. Partitioning a DB2 table is not a complicated procedure, but to optimally partition Siebel tables, it is critical that you understand how partitioning works in DB2.

This chapter consists of the following topics:

• About Siebel Partitioning

• About Partitioning Keys

• Partitioning and the Storage Control Files

• Considerations in Partitioning Tables

• About Table Partitioning Methods

• Example of Partitioning the S_ADDR_ORG Table

• Partitioning Strategies for Special Types of Tables

• Prepartitioned Siebel Tables

• Partitioning Tables and Indexes Using the Database Storage Configurator