PROUTIL PARTITIONMANAGE COPY qualifier

Partition management option to copy (restore) data into a partitioned table in the destination database from a temporary source database.

Caution: Both the source and target databases must be enabled and configured for table partitioning. The source database must be in restricted mode for PARTITIONMANAGE COPY to execute. See PROUTILDBRESTRICT qualifier for details on restricting access to your source database.

Syntax

proutil db-name -C partitionmanage copy
[ source source-db
[ partition table-partition-name |
composite initial table table-name ]
[recs n] ] |
clear all

Parameters

Specifies the table partitioned database where you are performing partition management. This is the destination database of the PARTITIONMANAGE COPY operation.

Specifies the source database for the PARTITIONMANAGE COPY operation. The source database must be enabled for table partitioning.

Specifies the partition name of the data to copy with the PARTITIONMANAGE COPY operation.

Specifies that the composite initial partition of the table table-name is being copied by the PARTITIONMANAGE COPY operation.

Removes all partition copy pending state information from all partitioned objects in db-name. The clear all option is only used if db-name needs to be used with a version of OpenEdge earlier than Release 11.6.0, and a PARTITIONMANAGE COPY operation terminated prior to completion.

Specifies the number of records to restore (copy) in a transaction. The default is 100.

PARTITIONMANAGE COPY copies data, local indexes, lobs and updates global indexes for the specified partition in the destination database (db-name). The following conditions must be met before PARTITIONMANAGE COPY can execute:

The source and destination databases must have identical schema.

The source database must be in partitioncopy restricted mode.

Indexes (local and global) of the specified partition must be active. If any index is inactive, the utility exits with an error.

The source and destination databases must be enabled for Table Partitioning.

If only destination (db-name) and source (source source-db) databases are specified on the command line, PARTITIONMANAGE COPY invokes a menu-driven user interface as shown:

Progress OpenEdge Partition Copy utility

Source Database : temp_source_db
Destination Database: production_db

1. Copy Table instance by Partition
2. Quit

Enter your selection:

The user interface can be used to select multiple partitions to copy at once.

Notes

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

PARTITIONMANAGE COPY will not operate on read-only partitions.