The SYSTEM.PARTITION view is used to describe each partition.
The base table (which is HPRDBSS.PARTITION) is locked with
an exclusive lock if you execute a CREATE PARTITION or DROP
PARTITION statement.
HPRDBSS.PARTITION is locked with a share lock
if you execute a CREATE TABLE statement that specifies a
partition or an ALTER TABLE statement that modifies a partition.
The SYSTEM.PARTITION table initially specifies
the DEFAULT partition for all tables, if they are
created when the DBEnvironment is
configured. A row is added, updated, or deleted from SYSTEM.PARTITION whenever
one of the following occurs:
A CREATE PARTITION or DROP PARTITION statement is processed.
A START DBE NEWLOG statement defining or altering the DEFAULT partition is
processed.
A CREATE TABLE or ALTER TABLE statement specifying a partition is processed.
The PARTITION table format is shown in Table 8-22 “SYSTEM.PARTITION”.
Table 8-22 SYSTEM.PARTITION
| Column Name | Type | Length | Description |
|---|
| PARTITIONNAME | CHAR | 20 | Name of the Partition |
| PARTITIONID | INTEGER | 4 | Number of the partition this
table is assigned to. 0 if default, -1 if none. This column
is not exposed in the system view, and is used to minimize
table accesses.
|
