|
|
The CREATE PARTITION statement defines a partition to be used for audit
logging purposes.
ISQL or Application Programs
CREATE PARTITION PartitionName WITH ID = PartitionNumber
- 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.
- 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.
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.
You must have DBA authority to use this statement.
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;
|