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

About Partitioning Indexes and Keys


When a table is created on a partitioned table space, the table is assigned a partitioning key that is composed of one or more columns. Value ranges are assigned to each partition based on value ranges within the partitioning key. The value ranges determine which partition a particular row is assigned to.

The partitioning index specifies the key values that determine how data is partitioned. You can divide a large table such as S_ORG_EXT (which holds a list of new accounts) to store records of names beginning with letters A-L in one partition and records of names beginning with letters M-Z in another partition, as shown in Figure 2. The partitioning index defines the key ranges for the partitioning column. A key range must be specified for each partition.

Figure 2. Partitioning S_ORG_EXT Table on DB2 for z/OS
Click for full size image

NOTE:  For more information about partitioning table spaces on DB2, consult your IBM documentation.

Implementing Siebel Business Applications on DB2 UDB for z/OS