Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
Enterprise ReplicationThe HCL OneDB™ Enterprise Replication Guide describes the concepts of data replication using HCL® OneDB® Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.
Setting up and managing Enterprise ReplicationAfter you design your replication system, you define it and start replication.
Managing Replication Servers and Replicates
Alter, rename, or truncate operations during replicationWhen Enterprise Replication is active and data replication is in progress, you can perform many types of alter, rename, or truncate operations on replicated tables and databases.
Attaching a New Fragment to a Replicated TableYou can attach a new fragment to a replication table while replication is active.

Attaching a New Fragment to a Replicated Table

You can attach a new fragment to a replication table while replication is active.

About this task

Enterprise Replication cannot automatically set alter mode for this operation because of an SQL restriction that requires attaching a fragment to be performed in multiple steps.

Procedure

To attach a new fragment to a replicated table:

Set alter mode on the replicate by running the cdr alter on command.
Drop the replication key of the table.
Attach the new fragment.
Re-create the replication key.
Unset alter mode by running the cdr alter off command.