Try OpenEdge Now
skip to main content
Database Administration
Reference : PROUTIL Utility : PROUTIL PARTITIONMANAGE ALTER qualifier
 

PROUTIL PARTITIONMANAGE ALTER qualifier

Partition management option to alter the state a partition of a partitioned table.

Syntax

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

Parameters

db-name
Specifies the database where you are performing partition management.
table table-name
Specifies the table for the PARTITIONMANAGE ALTER operation.
partition table-partition-name
Specifies the partition to alter.
composite initial
Specifies that the composite initial partition of the table is being altered.
state { read-only | read-write }
Specifies the new state for ALTER to change the partition to.
The 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. For a list of utility access permitted, see below.
*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).
PARTITIONMANAGE ALTER is used to change the state of a partition between read-write and read-only.
The following operations are permitted on a read-only partition:
*READ the data and indexes
*Perform table-level schema changes:
*Add fields
*Add indexes
*Add triggers
*Delete indexes
*Execute database utilities that perform physical location changes, for example, PARTITIONMANAGE SPLIT, PARTITIONMANAGE MERGE, and TABLEMOVE.
PARTITIONMANAGE SPLIT has the following restrictions:
*Read-Only source to Read-Only target(s) is allowed
*Read-Write source to Read-Only target(s) is allowed
*Read-Only source to Read-Write target(s) is not allowed
PARTITIONMANAGE MERGE has the following restrictions:
*Read-Only source(s) to Read-Only target is allowed
*Read-Write source(s) to Read-Only target is allowed
*Read-Only source(s) to Read-Write target is not allowed
*Execute database utilities that only perform read operation of the data, for example, BINARY DUMP, TABANALYS.
*Execute database utilities that only change the format of the data, but not the data itself. For example encrypting, decrypting, or changing the code page.
*Execute database utilities that only operate on indexes, for example, IDXBUILD, IDXCOMPACT, IDXCHECK, TPIDXBUILD. Operations within IDXFIX that operate on indexes only are also permitted.
*Execute rescue operations with DBTOOL.
*Restore from a backup (PROREST) and after-imaging roll forward (RFUTIL). A read-only partition can be overwritten by a restore operation. The final state of the partition depends on the information restored from the backup.

Notes

*PARTITIONMANAGE ALTER can be performed when the database is online or offline.