Altering partition state

Database Administration

Maintaining and Monitoring Your Database : Table-partitioned database : Managing partitions : Altering partition state

As you manage a partitioned database, you may find that you may want to set a partition to a read-only state. Or you may want to change a read-only partition to a read-write state. You can use PARTITIONMANAGE ALTER to change the state of a partition.

A partition can be in one of two states:

read-only — The data of the partition can not be changed. Language clients can only read the data. Limited utility access is permitted.

read-write — Language clients can read, write, create, and delete data in the partition (provided that access is not restricted at a higher level, such as user-level security with a can-* permission in ABL).

The syntax for PARTITIONMANAGE ALTER is as follows:

proutil db-name -C partitionmanage alter table table-name
{ partition table-partition-name | composite initial }
state { read-only | read-write }

Note: Before you use PARTITIONMANAGE ALTER you must enable it with PROUTIL ENABLEREADONLYPARTITIONS. See the section, PROUTIL ENABLEREADONLYPARTITIONS qualifier.

For complete details on PARTITIONMANAGE RENAME, including all the details on the allowed and restricted utility access to a read-only partition, see the section, PROUTIL PARTITIONMANAGE ALTER qualifier.