Implementing Siebel Business Applications on DB2 UDB for z/OS > Understanding Siebel Partitioning > Example of Partitioning: the S_ADDR_ORG Table >

Example of a Tablespace Definition

The definition for Tablespace object H0401000 is shown in the example for object 3197:

[Object 3197]
Type = Tablespace
Name = H0401000
Database = SIDB0401
Define = No
Partitions = 10
Bufferpool = BP1
LockSize = Page
Lockpart = Yes

You can easily identify a partitioned table space by reviewing the Partitions option in the Tablespace object in the storage control file. If the Partitions option is greater than zero, then the table space is partitioned and requires additional objects, such as Tableparts (Tspart) and a partitioning index. The number of Tspart objects is equal to the number of partitions.