This chapter provides information on partitioning large tables in Siebel Business Applications. 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 Methods Used for Partitioning
• Example of Partitioning the S_ADDR_ORG Table
• Partitioning Strategies for Special Types of Tables
• About Prepartitioned Siebel Tables
• Partitioning Tables and Indexes Using the Database Storage Configurator