rs_helpsub

Description

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 last 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 'SYDNEY_RS' **
                                                         Status at
 Subscription Name Rep. Def. Name  Replicate DS.DB  A/C RRS      PRS
 ----------------- --------------- ---------------- --- -------- ------
 authors_sub       authors_rep     SYDNEY_DS.pubs2  0   Defined  Unknown
 titles_sub        titles_rep      SYDNEY_DS.pubs2  0   Valid    Unknown

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     SYDNEY_DS.pubs2  0   Defined  Unknown

Owner                 Creation Date
--------------------  -------------
sa                    Sep 22 1995

Subscription  Text
---------------------------------------------------------------------
 create subscription authors_sub
   for authors_rep
   with replicate at SYDNEY_DS.pubs2
   where
   state = "CA"

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.