Was this helpful?
Optimizing Replicator Catalogs and Support Tables
Once the initial configuration has been defined, or following any significant changes, consider optimizing the Ingres Replicator system catalogs.
Visual DBA: You purge records from shadow and archive tables by expanding the Databases branch in the Database Object Manager, expanding the branch of the desired database, and highlighting Replication. Choose the Arcclean command from the Operations menu. For more information, see the online help topic Arcclean Operation dialog.
You modify the replicated system database by expanding the Databases branch in the Database Object Manager, expanding the branch of the desired database, and highlighting Replication. Choose the Repmod command from the Operations menu. For more information, see the online help topic Repmod Operation dialog box.
Command Line: Use the Arcclean command to purge unneeded records from the shadow and archive tables. See the Command Reference Guide for detailed information and procedures.
Use the Repmod command to modify the replicated system database to predetermined storage structures. For more information, see the Command Reference Guide.
Note:  Arcclean remodifies the shadow and archive tables that it cleans up.
Last modified date: 01/30/2023