Clear partition copy pending state

Database Administration

Maintaining and Monitoring Your Database : Table-partitioned database : Managing partitions : Copying partition data : Step 4: Partition copy clean up : Clear partition copy pending state

The clear all option for PARTITIONMANAGE COPY removes all partition copy pending state from the all partitioned objects that have this object state. The clear all option is necessary only in the rare cases that your database needs to be used with a version of OpenEdge earlier than Release 11.6.0 and a PARTITIONMANAGE COPY operation terminated prior to completion.

To remove any indicators of a partition copy pending state, and to disable the ability to continue to executing PARTITIONMANAGE COPY on the database, use the clear all parameter to PARTITIONMANAGE COPY. Invoke the command line using the following syntax:

Syntax

proutil target-database -C partitionmanage copy clear all

For example, to clear a database named production_db, enter the following:

proutil production_db -C partitionmanage copy clear all

The results of executing a clear all are similar to the following:

Partition Copy is attempting to clear "in process partition copy" object state from all partitioned objects:(17927)
Index 1 of table 1 partition 1 in area 22 is no longer in the process of being copied by Partition Copy.(17936)
Lob 3 of table 1 partition 1 in area 22 is no longer in the process of being copied by Partition Copy. (17936)
Partition 1 of table 1 in area 22 is no longer in the process of being copied by partition copy.(17937)
Partition Copy has successfully cleared "in process partition copy" object state and has disabled the feature.(17930)