HP 3000 Manuals HP 3000 Manuals
CREATE PARTITION
The CREATE PARTITION statement defines a partition to be used for audit
logging purposes.
Scope
ISQL or Application Programs
SQL Syntax
CREATE PARTITION PartitionName WITH ID = PartitionNumber
Parameters
PartitionName specifies the logical name to be given to the new
partition. Two partitions in the same
DBEnvironment cannot have the same name.
PartitionName may not be DEFAULT or NONE.[REV
BEG]
PartitionNumber is an integer specifying the partition number.
It must be a positive integer in the range 1 to
32767. The partition number identifies the
partition in the audit log record.[REV END]
Description
* The CREATE PARTITION statement creates a new audit partition,
which is a unit of data logging for an audit DBEnvironment.
* The partition number may already be assigned to another partition,
including the default partition. For example, several partitions
with different partition names may have the same partition number
in the audit log file. This allows the Audit Tool to gather
statistics for all of these partitions as one unit while
preserving the ability to manipulate each partition separately.
* Creation of a partition does not cause a check against the maximum
number of partitions. Only creation of audit log records in a
partition checks if the maximum number of partitions is exceeded.
The process of determining the number of partitions in a
DBEnvironment is described under the START DBE NEW statement.
* One data partition can be defined with the START DBE NEW or START
DBE NEWLOG statements -- the DEFAULT partition. Before tables
are assigned to a particular partition, they are placed in the
DEFAULT partition.
* To put a table in a partition, use the CREATE TABLE or ALTER TABLE
SET PARTITION statement.
* To remove a table from a partition, or change the partition it is
in, use the ALTER TABLE SET PARTITION statement.
* To delete the definition of a partition, use the DROP PARTITION
statement.
* Partitions can be created and tables placed in them without audit
logging being enabled for a DBEnvironment. However, the partition
information is only used in audit log records. Thus, partition
information will not be utilized in logging until the
DBEnvironment has audit logging enabled.
* Data partition information (including the default partition)
appears in the system view SYSTEM.PARTITION. If the default
partition is set to NONE, or is never defined, no row appears in
SYSTEM.PARTITION for it.
* The DROP PARTITION and CREATE PARTITION statements are used to
change the partition number assigned to a partition other than the
default partition. The START DBE NEWLOG statement is used to
change the partition number of the default partition.
* The partition number, not the partition name, is used in audit
logging. A partition name is used in the CREATE TABLE and ALTER
TABLE statements to associate a table with a partition.
Authorization
You must have DBA authority to use this statement.
Example
To create a partition containing tables, first create the partition.
CREATE PARTITION PartsPart WITH ID = 10;
Then assign tables(s) to the partition.
ALTER TABLE PurchDB.Parts SET PARTITION PartsPart;
To drop a partition, first assign all tables in the partition to the NONE
partition.
ALTER TABLE PurchDB.Parts SET PARTITION NONE;
Then drop the partition.
DROP PARTITION PartsPart;