Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Table-partitioned database : Managing partitions : Viewing partitions
 
Viewing partitions
To aid managing a partitioned database, you can use the PARTITIONMANAGE VIEW on the command line to view the state and status of the partitions of your database. One example where PARTITIONMANAGE VIEW can be helpful is gauging the progress of a split or merge operation.
PARTITIONMANAGE VIEW reports on the following:
*The current state of a partition or partitions
*The progress of a partition utility operation (such as split, merge, and truncate)
*A list of a table's partition definitions, partition by partition in adjacent order
The syntax for PARTITIONMANAGE VIEW is as follows:
proutil db-name -C partitionmanage view
[ table table-name
[ partition table-partition-name | composite initial ]]
{ list | state | status }
The options for PARTITIONMANAGE VIEW display different aspects of the queried table or partition, as follows:
*list — Lists partitions by partition definition order (adjacent definitions not by partition Id).
*state — Reports on the state of a partition. Partitions states are:
*No state reported (blank) — The partition has no special characteristics, and is readable and writable.
*Rebuilding — The partition is involved in a partition rebuild operation. The rebuilding type indicates the type of rebuild (split, merge, truncate, etc) and if the partition is the source or target.
*Read Only — The partition is set to read only.
*Deallocated — The partition is deallocated.
*status — Reports on the status of a partition that is in a rebuilding state. The number of rows in each partition is reported and can be used to measure progress of a partition operation such as split or merge.
For complete details on PARTITIONMANAGE VIEW, including sample output, see the section, PROUTIL PARTITIONMANAGE VIEW qualifier.