Partitioned tables use a data organization scheme in which
table data is divided across multiple storage objects called data
partitions according to values in one or more table partitioning
key columns of the table. The ranges specified for each data partition
can be generated automatically or manually when creating a table.
Data partitions are referred to in various ways throughout the DB2® library. The following list
represents the most common references:
- DATAPARTITIONNAME is the permanent name assigned to a data partition
for a given table at create time. This column value is stored in
the SYSCAT.DATAPARTITIONS catalog view. This name is not preserved
on an attach or detach operation.
- DATAPARTITIONID is the permanent identifier assigned to a data
partition for a given table at create time. It is used to uniquely
identify a particular data partition in a given table. This identifier
is not preserved on an attach or detach operation. This value is system-generated
and might appear in output from various utilities.
- SEQNO indicates the order of a particular data partition range
with regards to other data partition ranges in the table, with detached
data partitions sorting after all visible and attached data partitions.