Check Publication and Article Subscription Status

Use check subscription at the primary Replication Server or the replicate Replication Server to check the status of a publication subscription and its article subscriptions or to check the status of an article subscription.

check subscription returns a status (such as VALID, MATERIALIZING, or ACTIVE) along with a descriptive message. See Replication Server Reference Manual > Replication Server Commands > check subscription for complete syntax and usage guidelines and a list of status messages.

This example displays the subscription status of the publication subscription pubs2_sub.
```
check subscription pubs2_sub 
			for publication pubs2_pub
    with primary at TOKYO_DS.pubs2
    with replicate at SYDNEY_DS.pubs2
```
If the publication subscription is valid, Replication Server also checks whether the subscription is current. When you alter a publication after the subscription is created, the publication subscription is out of sync with the publication. To create subscriptions for new articles and make the subscription current, refresh the subscription using create subscription or define subscription.

This example displays the subscription status of the article pubs2_art in the subscription pubs2_sub.

check subscription sub for article pubs2_art
    in pubs2_pub
    with primary at TOKYO_DS.pubs2
    with replicate at SYDNEY_DS.pubs2