You can view information about publications and articles with the check publication command and the rs_helppub stored procedure.
To display the number of articles in a publication and its current status, use check publication.
Any user can execute check publication at either the primary or replicate Replication Server. If you execute check publication at the replicate Replication Server, you must have the same login and password at the primary and replicate servers.
The following example displays the status and number of articles in the pubs2_pub publication.
check publication pubs2_pub with primary at TOKYO_DS.pubs2
Refer to Chapter 3, “Replication Server Commands,” in the Replication Server Reference Manual for complete syntax and usage guidelines and sample output.
To display information about a publication and its articles, use the rs_helppub stored procedure at either the primary or replicate Replication Server RSSD.
Although you can execute rs_helppub at
the primary or replicate site, rs_helppub only
displays publication information stored at the site at which it is
executed. For example, if you execute rs_helppub at
the primary site, rs_helppub displays
information about all publications created at that site. If, however,
you execute rs_helppub at the replicate
site, rs_helppub only displays information
about publications for which subscriptions have been created at that
site.
Here are some examples of using rs_helppub:
To list all publications at a site, enter:
rs_helppub
The display output includes publication name, status, the primary Replication Server and database names, the number of articles, and the date of the latest change to the publication.
To display detailed information about a particular publication, enter:
rs_helppub publication_name, primary_dataserver, primary_db
The display output includes the above information and the names of associated articles, replication definitions, and primary and replicate tables. If subscriptions have been created for the publication, the display includes names of the subscriptions, replicate databases, owners, and the date of the latest change to the subscription.
To display information about a particular article, enter:
rs_helppub publication_name, primary_dataserver, primary_db, article_name
The output display includes the name of the publication to which the article belongs, associated replication definitions, status information, and where clauses and subscriptions, if any.
Refer to the Replication Server Reference Manual for complete syntax and usage guidelines and sample output.
