rs_helpdbsub

Displays information about database subscriptions associated with the replicate data server.

Syntax

rs_helpdbsub [db_sub[, data_server[, database]]]

Parameters

db_sub – Specifies the database subscription.
data_server – Specifies the data server name whose database subscription you want to display.
database – Specifies the database name whose database subscription you want to display.

Examples

Example 1 – In this example, Adaptive Server displays information about a single database subscription, db_sub1:

rs_helpdbsub db_sub1, RDS1, rdb1

DBSub.Name  ReplicateDS.DB  ReplicateRS  Status at RRS  DBRep.Def.Name
----------  --------------  -----------  -------------  ---------------
db_sub1     RDS1.rdb1       RRS1         Validate       db_rep

PrimaryDS.DB  PrimaryRS  Method       Trunc.Table     Creation Date
------------  ---------  -----------  -----------     -----------------
PDS.pdb1       PRS        Bulk Create  Yes              May 2 2003 3:38PM

Usage

If you do not specify any parameters, rs_helpdbsub lists database subscriptions defined in the Replication Server.
If you supply the db_sub parameter only, rs_helpdbsub lists all the database subscriptions defined in the Replication Server that have a database subscription name matching db_sub.
The parameters can contain the wildcard ‘%’. This wildcard represents any string. For example, if a string ‘abc%’ is assigned to db_sub, rs_helpdbsub will list all database subscriptions that have a database subscription name prefixed with ‘abc’.