Description
This object represents a collection of DB2OS390TablePartition objects.
Object Model
Remarks
This is the collection of partitions of an DB2 OS/390 table for O3/390 V8 and later.
The Manager managing this collection also manages the Partition Key. Each partition can have different physical attributes, such as High values and Inclusive. However, each Partition of a table must have the same logical attributes, such as column names, datatypes, and constraints. Those are determined by the columns in the partition key.
The partition key is a set of one or more columns (ordered list) that determines the partition for each row. DB2 OS/390 supports only Range partition. RANGE partitioning partitions the data into ranges. Each partition defines an ENDING AT clause that specifies an inclusive/non-inclusive upper bound called High Value. You can define a MAXVALUE literal for the highest partition.