Using the activate subscription command

Use activate subscription to activate a publication subscription and its subscription subset. Execute activate subscription at the Replication Server that manages the destination database.

Before you execute activate subscription, you must execute define subscription, and the publication subscription status must be DEFINED. Refer to “Display status information” for information about displaying subscription status.

All subscriptions in the publication subscription are activated at the same time.

The following example activates every subscription in the publication subscription pubs2_sub.

activate subscription sub for publication pub
    with primary at TOKYO_DS.pubs2
    with replicate at SYDNEY_DS.pubs2

Refer to Chapter 3, “Replication Server Commands,” in the Replication Server Reference Manual for complete syntax and usage guidelines.