HP 3000 Manuals HP 3000 Manuals
System Catalogs
Partition values are stored in the system catalogs. You can verify the
attributes of table partitions by examining the SYSTEM.TABLE and
SYSTEM.PARTITION views.
SYSTEM.TABLE
A PARTITION column is added to SYSTEM.TABLE as shown in Table 2-1 .
Table 2-1. SYSTEM.TABLE
-------------------------------------------------------------------------------------------------
| | | | |
| Column Name | Type | Length | Description |
| | | | |
-------------------------------------------------------------------------------------------------
| | | | |
| NAME | CHAR | 20 | Name of the table or view |
| | | | |
-------------------------------------------------------------------------------------------------
| | | | |
| OWNER | CHAR | 20 | Owner of the table or view |
| | | | |
-------------------------------------------------------------------------------------------------
| | | | |
| DBEFILESET | CHAR | 20 | Name of the DBEFileSet containing the table |
| | | | or view |
| | | | |
-------------------------------------------------------------------------------------------------
| | | | |
| : | : | : | : |
| | | | |
-------------------------------------------------------------------------------------------------
| | | | |
| PARTITION | CHAR | 20 | Name of the partition this table is |
| | | | assigned to. Views (including system |
| | | | views) are in no partition, so they use |
| | | | partition name NONE. |
| | | | |
-------------------------------------------------------------------------------------------------
SYSTEM.PARTITION
The SYSTEM.PARTITION view is used to describe each partition. This table
is only accessed when a CREATE PARTITION, DROP PARTITION, CREATE TABLE,
or ALTER TABLE statement is executed.
The SYSTEM.PARTITION view initially specifies the DEFAULT partition. 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.
The PARTITION table format is shown in Table 2-2 .
Table 2-2. SYSTEM.PARTITION
-------------------------------------------------------------------------------------------------
| | | | |
| Column Name | Type | Length | Description |
| | | | |
-------------------------------------------------------------------------------------------------
| | | | |
| PARTITIONNAME | CHAR | 20 | Name of the Partition |
| | | | |
-------------------------------------------------------------------------------------------------
| | | | |
| PARTITIONID | INTEGER | 4 | Number of the partition. |
| | | | |
-------------------------------------------------------------------------------------------------