Attaching a New Fragment to a Replicated Table

You can attach a new fragment to a replicated 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:
  1. Set alter mode on the replicate by running the cdr alter on command.
  2. Drop the replication key of the table.
  3. Attach the new fragment.
  4. Re-create the replication key.
  5. Unset alter mode by running the cdr alter off command.
    Note: For a fragmented replicated table ( irrespective of the method used for attaching fragments to a replicated table), if an existing fragment contains the flag “Cascade Replication”, the same flag must be "inherited" for the new partitions being added. This should occur automatically and nothing is required to be done for this from user's side. oncheck -pt can be used to confirm that the flag is inherited in subsequent partitions. In the example given below, all the subsequent partitions of 'customer' table will inherit the flag 'Cascade Replication'.
    For example:
 % oncheck -pT storesdb:informix.customer

                  Table fragment partition p0 in DBspace dbs1

    Physical Address               3:5
    Creation date                     06/03/2023 01:03:58
    TBLspace Flags                809        Page Locking
                                              TBLspace flagged for replication
                                              TBLspace flagged for Cascade Replication
                                              TBLspace use 4 bit bit-maps