rs_helpdbrep

Displays information about database replication definitions associated with the current Replication Server.

Syntax

rs_helpdbrep [db_repdef[, data_server[, database]]]

Parameters

db_repdef – Specifies the name of the database replication definition.
data_server – Specifies the name of the data server whose database replication definition you want to display.
database – Specifies the name of the database whose database replication definition you want to display.

Examples

Example 1 – In this example, Adaptive Server displays the information of all the database replication definitions found in the current Replication Server:

rs_helpdbrep

DB Rep.Def.Name Primary DS.DB Primary RS Rep.DDL Rep.Sys. Rep.Tab Rep.Func.
--------------- ------------- ---------- ------ -------- ------- ---------
db_rep1         PDS.pdb1      PRS        Yes    Out-List  All     All
db_rep2         PDS.pdb2      PRS        Yes    Out-List  All     All

Rep.Tran. Rep.Upd. Rep.Del. Rep.Ins. Rep.Sel. Creation Date
--------- -------- -------- -------- -------- -------------------
All       All      All      All      All      Nov 26 2008 6:58AM
All       All      All       All      All       Dec 2 2008 6:12PM

Example 2 – In this example, Adaptive Server displays information about a single database replication definition, db_rep1:

rs_helpdbrep db_rep1

DB Rep.Def.Name Primary DS.DB Primary RS  Rep.DDL  Rep.Sys. Rep.Tab Rep.Func.
--------------- ------------  ---------  ------- -------  ------- --------
db_rep1         PDS.pdb1      PRS         Yes     Out-List  All    All

Rep.Tran. Rep.Upd. Rep.Del. Rep.Ins. Rep.Sel. Creation Date
--------- -------- -------- -------- -------- -------------------
All       All      All      All      All      Nov 26 2008 6:58AM


Rep.Type      Owner     Name
------------  --------  -------------
Not Rep.Sys.  .         sp_setrepproc

DBRep.Def.Name DBSub.Name ReplicationDS.DB ReplicateRS Creation Date
-------------- ---------- ---------------- ----------- ------------------
db_rep1        db_sub1    RDS1.rdb1        RRS1        Nov 26 2008 6:58AM
db_rep1        db_sub2    RDS2.rdb2        RRS2        Nov 26 2008 6:59AM

Usage

Adaptive Server only displays detail information about named database replication definitions.
The parameters can contain the wildcard ‘%’. This wildcard represents any string. For example, if a string ‘abc%’ is assigned to db_repdef, rs_helpdbrep will list all database replication definitions that have a database replication definition name prefixed with ‘abc’.