Use validate subscription to set the subscription status to VALID for the publication subscription, and its subscription subset. Execute validate subscription at the Replication Server that manages the replicate database.
Before you execute validate subscription, you must execute activate subscription and the publication subscription status must be ACTIVE. Refer to “Display status information” for information about displaying subscription status.
All subscriptions in the publication subscription are validated at the same time.
The following example validates every subscription in the publication subscription pubs2_sub.
validate 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.
