To modify an existing subscription
You can change an existing subscription using Classic Data Architect. For example, you can change the description, apply attributes, apply or capture cache size, and persistency for a subscription.
Procedure
- Ensure you are in the Replication perspective (if not, select Window > Open Perspective > Replication).
- Stop replication for the subscription
you want to modify. Only inactive subscriptions can be modified. To
stop replication, from the Subscriptions view, right-click the actively
replicating subscription and select one of the following actions:
Option Description Stop Replication (Controlled) Select this option if you want all transactions that are in process to finish before replication stops. Stop Replication (Immediate) Select this option if you want to stop all transactions immediately, rolling back any that are unfinished. - Right-click the subscription you want to modify from the Subscriptions view and select Modify Subscription.
- Modify any of the attributes
on the Subscription Properties dialog. Fields that are read-only and
cannot be changed. To change any of the disabled fields, you must
create a new subscription instead. Attention: Replication can only be started for a subscription that has at least one active replication mapping.
- Click Advanced Settings to
set the following attributes:
- Mark subscriptions as persistent (auto-restart) If enabled, replication will be automatically restarted for this subscription once the server is restarted. This can occur after a normal shutdown and restart, or after a failure that does not require operator interaction to restart.
- Capture cache size A value from 64 to 2048 MB.
- Apply cache size A value from 64 to 2048 MB.
- Parallel apply enabled Consider disabling parallel apply if the units of recovery (UORs) for the subscription must be applied in a strict order.
Click OK to close the Advanced Subscriptions Settings dialog to save your changes and return to the Subscriptions Properties dialog. - Click OK to save your changes and close the Subscription Properties dialog.
- Modify the replication mappings associated with this subscription on the Replications Mappings view. Right-click on the subscription in the Subscriptions view and select Show Replication Mappings.
- Select the replication mapping to modify by right-clicking on it in the Replication Mappings view.
- Use the Change
Apply Type option to switch between the following options:
- Standard - the standard apply type maintains an updated copy of the source database content in the target database
- Adaptive - the adaptive apply type manages data conflicts that can arise between the source and target databases
- Change the state of the replication
mapping with either of the following options:
- Parked - will not replicate when replication is started for the subscription
- Active - include this mapping in the list of active mappings that will replicate when replication is started for the subscription. The Activate Replication Mappings window is displayed where you can either use the system's default log position (the current time) or specify a specific log position from which to start replication. Click OK to save the log position setting.