The check subscription command reports the status of a subscription at the Replication Server where you enter the command. The subscription status at the primary and replicate Replication Servers often differs while the subscription is being created, so you should enter check subscription at both sites. If the primary and replicate databases are managed by a single Replication Server, check subscription displays the status of the subscription for both the primary and replicate databases.
The syntax for the check subscription command is:
check subscription subscription
for { table_rep_def | function_rep_def | publication pub_name |
database replication definition db_repdef
with primary at data_server.db }
with replicate at data_server.db
where subscription is the name of the subscription to check, table_rep_def is the name of the table replication definition the subscription is for, function_rep_def is the name of the function replication definition the subscription is for, pub_name is the publication the subscription is for, db_repdef is the database replication definition the subscription is for, and data_server.db identifies the primary or replicate database.
The message returned by the command contains subscription status information. If the subscription had an error, the message directs you to the log where you should look for specific error messages.
Refer to Chapter 3, “Replication Server Commands,” in the Replication Server Reference Manual for a list of the messages check subscription can return.
