Example of a Table Space Definition

The definition for Tablespace object H0401000 follows:

[Object 3643]
Type       = Tablespace
Name       = H0401504
Database   = D0059504
LockSize   = Page
Bufferpool = BP16K1
Define     = No
Partitions = 10
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 partition or index objects. The number of Tspart objects is equal to the number of partitions.