Implementing Siebel Business Applications on DB2 UDB for z/OS > Understanding Siebel Partitioning >

Example of Partitioning: the S_ADDR_ORG Table

This topic gives one example of partitioning a table and a table space. The example definitions in this topic reflect a partitioning scenario for the S_ADDR_ORG table, which resides in the H0401000 partitioned table space. The Siebel partitioning template used for this scenario is the storage_p.ctl storage control file.

In a storage control file, the partitioned table space is defined with two types of storage control file objects: Tablespace and Tspart (table space partitions). The storage control file objects related to partitioning are:

• Table
• Tablespace
• Tspart (table space partitions)
• IndexBase (base definition of a partitioning index)
• IndexPart (index partitions)

A table definition always includes the same options, whether the corresponding table space is partitioned or not. However, the table space and index include different options, depending on whether the table space is partitioned or nonpartitioned.

NOTE:  The object numbers that identify the objects in this example might differ in your implementation.