rs_helpsub

Displays information about subscriptions.

Syntax

rs_helpsub
 [subscription_name [, replication_definition
	[, data_server, database]]]

Parameters

subscription_name – 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.
replication_definition – The replication definition subscribed to.
data_server – The data server with the database containing the subscription’s data.
database – The database containing the subscription’s data.

Examples

Example 1 – 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)

Example 2 – 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)

Usage

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.