After a period of time managing a partitioned database, particularly after a split or merge operation, you may find that the partition name is no longer representative of its contents. You can rename a partition with PARTITIONMANAGE RENAME.

The syntax for PARTITIONMANAGE RENAME is as follows:

proutil db-name -C partitionmanage rename partition table-partition-name
  partition new-table-partition-name

When you use PARTITIONMANAGE RENAME to rename a partition, the following rules apply:

  • You can not rename the composite initial partition of a table.
  • You can not rename a partition that is the source of merge operation.
  • The new-table-partition-name must follow the standard rules for partition naming. The name:
    • Must be unique; it cannot already exist in the database
    • Must be 32 or fewer characters
    • Can only contain the following characters: a-z, A-Z, 0-9 (ASCII) , and the special characters::# $ % & - (dash) _ (underscore)
    • Is not blocked from using reserved words (as the database does for table names)

For complete details on PARTITIONMANAGE RENAME, see the section, PROUTIL PARTITIONMANAGE RENAME qualifier.