Displays information about subscriptions.
rs_helpsub [subscription_name [, replication_definition [, data_server, database]]]
A string of characters that corresponds to a subscription name. The string must match an entire subscription name or the first part of a name.
The replication definition subscribed to.
The data server with the database containing the subscription’s data.
The database containing the subscription’s data.
Displays summary information about all available subscriptions. The “Unknown” status in the RRS column reflects the fact that the current Replication Server has no knowledge of the subscription status at the listed Replication Server (the primary Replication Server):
rs_helpsub
** This Site is primary_rs ** Status at Subscription Name Rep. Def. Name Replicate DS.DB A/C RRS PRS ----------------- --------------- ---------------- --- -------- ------ authors_1 authors RDS.rdb 0 Unknown Valid many_rows_1 many_rows RDS.rdb 0 Unknown Valid publishers_1 publishers RDS.rdb 0 Unknown Valid titleauthor_1 titleauthor RDS.rdb 0 Unknown Valid titles_1 titles RDS.rdb 0 Unknown Valid Dynamic SQL ----------- On On On On On (return status = 0)
Displays detailed information about the authors_sub subscription:
rs_helpsub authors_sub
Subscription Name Rep. Def. Name Replicate DS.DB A/C RRS PRS ----------------- --------------- ---------------- --- -------- ------ authors_sub authors_rep RDS.rdb 0 Defined Unknown Dynamic SQL Owner Creation Date ----------- -------------------- ------------- On sa Oct 2 2007 Subscription Text --------------------------------------------------------------------- create subscription authors_sub for authors_rep with replicate at RDS.rdb where state = "CA" (return status = 0)
If you do not specify any parameters, rs_helpsub lists summary information about all subscriptions defined in the Replication Server. Information include replication definitions, replicate data server and database, autocorrection status, and subscription materialization status at the replicate and primary Replication Server.
If you supply a subscription_name string, rs_helpsub displays information about any subscription whose name matches subscription_name.
If the subscription_name string matches exactly one subscription name, the owner, creation date, and text of the subscription also display.
If the subscription_name string does not match exactly one subscription name, summary information displays for any subscriptions whose names match subscription_name.
If you also supply a replication_definition, rs_helpsub displays information only for subscriptions to that replication definition.
rs_helpsub does not display subscription replication definition. Use rs_helpdbsub to display subscription replication definition.
