Suspend DSI

Use alter replication definition, alter applied function replication definition, and alter request function replication definition with the with DSI_suspended option to suspend the standby DSI, if there is one, and each of the subscribing replicate DSI threads.

Replication Server suspends the DSI thread in the standby or replicate database after Replication Server applies all the data for the old replication definition version to the standby or replicate database.

After Replication Server suspends a DSI thread, you can make changes to the target schema or target stored procedures, and to any customized function strings.

When you resume the DSI thread, Replication Server replicates the primary updates using the altered replication definition.

This example shows how to instruct Replication Server to suspend the target DSI after primary data that exists before you execute alter replication definition is replicated to the target database:

alter replication definition pubs_rep
alter columns with pub_name as pub_name_set
with DSI_suspended

You do not need to use with DSI_suspended if:

There is no subscription to the replication definition.
You do not need to change customized function strings.
You do not need to change the replicate or standby database schema.

Note: If there is a subscription from a replicate Replication Server with a site version earlier than 1550, the replicate DSI threads for that Replication Server are not suspended.