To display information about a publication and its articles, use the rs_helppub stored procedure at either the primary or replicate Replication Server’s 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.
