Kbase P124589: How do I run proutil -C tablemove while Replication is running?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/7/2010 |
|
Status: Verified
GOAL:
How do I run proutil <dbname> -C tablemove while Replication is running?
GOAL:
If Replication is running, can proutil <dbname> -C tablemove be run?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge Replication
CAUSE:
Bug# OE00154383
FIX:
The proutil tablemove utility ( proutil <dbname> -C tablemove table-name table-area [ index-area ] ) may be used with a OpenEdge Replication database under the following conditions.
1. Any area added to the source database must also be added manually to the target database using prostrct add utility prior to executing the tablemove. The new area will not be added via the Replication ai notes.
When areas are added online, the dsrutil <source> -C restart server must be run and the target database must be stopped and restarted.
2. Bi file extents must be large enough to manage the single transaction tablemove operation on the source and target databases.
3. While you can move tables online, no access to the table or its indexes is recommended during the move.
4. When the move has completed and all ai notes have been written to the target database, the target database must be restarted in order to see the records in the relocated table.
5. Run dsrutil <source> -C restart server.