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. You should understand the contents of columns used to partition tables, and you should understand how ROW_IDs are used in partitioning.

This chapter consists of the following topics:

• About Siebel Partitioning
• Partitioning and the Storage Control Files
• Considerations in Partitioning Tables
• Methods Used for Partitioning
• Example of Partitioning: the S_ADDR_ORG Table
• Partitioning Strategies for Special Types of Tables
• Prepartitioned Siebel Tables