rs_helprep

Displays information about replication definitions.

Syntax

rs_helprep [replication_definition]

Parameters

replication_definition – A string of characters that corresponds to a replication definition name. The string must match an entire replication definition name or the first part of a name.

Examples

Example 1 – rs_helprep

Rep Def	PRS	Primary DS.DB	Primary Table	Replicate Table	Type
authors	cardhu_11	cardhu_10.pdb1	authors	ling.authors_r1	Tbl
authors1	cardhu_11	cardhu_10.pdb1	authors	authors_r2	Tbl
discounts	cardhu_11	cardhu_10.pdb1	discounts	discounts	Tbl
publishers	cardhu_11	cardhu_10.pdb1	publishers	ling.publishers_r1	Tbl
publishers1	cardhu_11	cardhu_10.pdb1	publishers	publishers_r2	Tbl
roysched	cardhu_11	cardhu_10.pdb1	roysched	roysched	Tbl
rs_classes	cardhu_11	cardhu_10.emb	rs_classes	Tbl
rs_columns	cardhu_11	cardhu_10.emb	rs_columns	Tbl
rs_databases	cardhu_11	cardhu_10.emb	rs_databases	Tbl
rs_erroractions	cardhu_11	cardhu_10.emb	rs_erroractions	Tbl
rs_funcstrings	cardhu_11	cardhu_10.emb	rs_functstrings	Tbl
rs_functions	cardhu_11	cardhu_10.emb	rs_functions	Tbl
rs_objects	cardhu_11	cardhu_10.emb	rs_objects	Tbl
rs_routes	cardhu_11	cardhu_10.emb	rs_routes	Tbl
rs_systext	cardhu_11	cardhu_10.emb	rs_systext	Tbl

Example 2 – Displays information about the authors replication definition which was created using create function replication definition:

rs_helprep authors

Replication Definition Name  PRS                  Type Creation Date
---------------------------- -------------------- ---- ------------------- 
authors                       primary_rs           Tbl  Nov 26, 2008 1:48PM

PDS.DB               Primary Owner        Primary Table
-------------------- -------------------- --------------------
pds.pdb                                   authors

Replicate Owner      Replicate Table
-------------------- --------------------
                     authors

Send Min Cols. Used by Standby Min Vers Dynamic SQL SQL Stmt.Rep.
-------------- --------------- -------- ----------- -------------
No             No               1000     On         UD

Col. Name   Rep. Col. Name   Datatype   Len.   Pri. Col.   Searchable
---------   --------------   --------   ----   ---------   ----------
au_id       au_id            varchar     11            1            1
au_lname    au_lname         varchar     40            0            1
au_fname    au_fname         varchar     20            0            1

Example 3 – Displays information about the R1_app replication definition which was created using create applied function replication definition:

rs_helprep R1_app

Replication Definition Name  PRS             Type  Creation Date
---------------------------  --------------  ----  -----------------------
R1_app                        ost_replnx4_12  Func  Feb 22 2008 12:15PM

PDS.DB    Primary Function  Replicate Function  Used by Standby  Func_type
--------  ----------------  ------------------  ---------------  -------
PDS.pdb1  R1                R1_rep              No                Applied

Parameter  Datatype  Length  Searchable
---------  --------  ------  ----------
a          int       4        0

Function Name  FString Class                FString Source  FString Name
-------------  ---------------------------  --------------  -------------
R1             rs_sqlserver_function_class  Class Default    R1

Subscriptions known at this Site 'ost_replnx4_12'.

Subscription Name    Replicate DS.DB   Owner   Creation Date
------------------   ---------------   -----   --------------

(return status = 0)

Example 4 – Displays information about the R1_req replication definition which was created using create request function replication definition:

rs_helprep R1_req

Replication Definition Name   PRS              Type   Creation Date
---------------------------   --------------   ----   -------------------
R1_req                        ost_replnx4_12   Func   Feb 22 2008 12:15PM

PDS.DB    Primary Function  Replicate Function  Used by Standby  Func_type
--------  ----------------  ------------------  ---------------  ---------
PDS.pdb1  R2                R2_rep              No               Request

Parameter      Datatype      Length      Searchable
---------      ---------     ------      ----------
a              int                4      0

Function Name  FString Class                FString Source  FString Name
-------------  ---------------------------  --------------  -------------
R2             rs_sqlserver_function_class  Class Default   R2 

Subscriptions known at this Site 'ost_replnx4_12'.


Subscription Name       Replicate DS.DB     Owner    Creation Date
----------------------  ---------------     -----    --------------

(return status = 0)

Example 5 – Given this table and replication definition:

create table t1 (c1 int, c2 int)

create replication definition r1
   with primary at ost_wasatch_08.pdb1
   with all tables named t1
   (c1 int, "c2" int quoted)
    primary key (c1)

rs_helprep r1 displays c2 as a quoted identifier:

Replication Definition Name  PRS                  Type Creation Date
---------------------------- -------------------- ---- ------------------- 
r1                           ost_wasatch_09       Tbl  Nov 11, 2008 2:28PM

PDS.DB               Primary Owner        Primary Table
-------------------- -------------------- --------------------
ost_wasatch_08.pdb1                       t1

Replicate Owner      Replicate Table
-------------------- --------------------
                     t1

Send Min Cols. Used by Standby Min Vers Dynamic SQL SQL Stmt. Rep.
-------------- --------------- -------- ----------- --------------
No             No              1000     On          None

Col. Name   Rep. Col. Name   Datatype   Len.   Pri. Col.   Searchable
---------   --------------   --------   ----   ---------   ----------
c1          c1               int           4           1            0
"c2"        "c2"             int           4           0            0

Function Name   FString Class                 FString Source   FString Name
-------------   ---------------------------   --------------   ------------
rs_delete       rs_sqlserver_function_class   Class Default    rs_delete
rs_insert       rs_sqlserver_function_class   Class Default    rs_insert
rs_select       rs_sqlserver_function_class   Class Default    rs_select
rs_select_      rs_sqlserver_function_class   Class Default    rs_select_
with_lock                                                      with_lock
rs_truncate     rs_sqlserver_function_class   Class Default    rs_truncate
rs_update       rs_sqlserver_function_class   Class Default    rs_update

Subscriptions known at this Site 'ost_wasatch_09'.
Subscription Name   Replicate DS.DB   Owner   Creation Date
-----------------   ---------------   -----   -------------
(return status = 0)

Example 6 – Given the table and replication definition defined in the preceding example, when you define t1 as a quoted identifier:

alter replication definition r1
alter replicate table name "t1" quoted

rs_helprep r1 displays c2 and t1 as quoted identifiers:

Replication Definition Name  PRS                  Type Creation Date
---------------------------- -------------------- ---- ------------------- 
r1                           ost_wasatch_09       Tbl  Nov 11, 2008 2:28PM

PDS.DB               Primary Owner        Primary Table
-------------------- -------------------- --------------------
ost_wasatch_08.pdb1                       "t1"

Replicate Owner      Replicate Table
-------------------- --------------------
                     "t1"

Send Min Cols. Used by Standby Min Vers Dynamic SQL SQL Stmt. Rep.
-------------- --------------- -------- ----------- --------------
No             No              1000     On          None

Col. Name   Rep. Col. Name   Datatype   Len.   Pri. Col.   Searchable
---------   --------------   --------   ----   ---------   ----------
c1          c1               int           4           1            0
"c2"        "c2"             int           4           0            0

Function Name   FString Class                 FString Source   FString Name
-------------   ---------------------------   --------------   ------------
rs_delete       rs_sqlserver_function_class   Class Default    rs_delete
rs_insert       rs_sqlserver_function_class   Class Default    rs_insert
rs_select       rs_sqlserver_function_class   Class Default    rs_select
rs_select_      rs_sqlserver_function_class   Class Default    rs_select_
with_lock                                                      with_lock
rs_truncate     rs_sqlserver_function_class   Class Default    rs_truncate
rs_update       rs_sqlserver_function_class   Class Default    rs_update

Subscriptions known at this Site 'ost_wasatch_09'.
Subscription Name   Replicate DS.DB   Owner   Creation Date
-----------------   ---------------   -----   -------------
(return status = 0)

Example 7 – Given the replication definition defined in the preceding example, when you define c2 as not quoted:

alter replication definition r1
alter columns c2 not quoted

rs_helprep r1 displays t1 as the only quoted identifier:

Replication Definition Name  PRS                  Type Creation Date
---------------------------- -------------------- ---- ------------------- 
r1                           ost_wasatch_09       Tbl  Nov 11, 2008 2:28PM

PDS.DB               Primary Owner        Primary Table
-------------------- -------------------- --------------------
ost_wasatch_08.pdb1                       "t1"

Replicate Owner      Replicate Table
-------------------- --------------------
                     "t1"

Send Min Cols. Used by Standby Min Vers Dynamic SQL SQL Stmt. Rep.
-------------- --------------- -------- ----------- --------------
No             No              1000     On          None

Col. Name   Rep. Col. Name   Datatype   Len.   Pri. Col.   Searchable
---------   --------------   --------   ----   ---------   ----------
c1          c1               int           4           1            0
c2          c2               int           4           0            0

Function Name   FString Class                 FString Source   FString Name
-------------   ---------------------------   --------------   ------------
rs_delete       rs_sqlserver_function_class   Class Default    rs_delete
rs_insert       rs_sqlserver_function_class   Class Default    rs_insert
rs_select       rs_sqlserver_function_class   Class Default    rs_select
rs_select_      rs_sqlserver_function_class   Class Default    rs_select_
with_lock                                                      with_lock
rs_truncate     rs_sqlserver_function_class   Class Default    rs_truncate
rs_update       rs_sqlserver_function_class   Class Default    rs_update

Subscriptions known at this Site 'ost_wasatch_09'.
Subscription Name   Replicate DS.DB   Owner   Creation Date
-----------------   ---------------   -----   -------------
(return status = 0)

Example 8 – To display information about the “authors” replication definition created using create function replication definition, enter:

rs_helprep authors

See the Ref Objowner and Ref Objname columns in the Output:

Replication Definition Name  PRS                  Type Creation Date
---------------------------- -------------------- ---- ------------------- 
authors                      primary_rs           Tbl  Nov 26, 2008 1:48PM

PDS.DB               Primary Owner        Primary Table
-------------------- -------------------- --------------------
pds.pdb                                   authors

Replicate Owner      Replicate Table
-------------------- --------------------
                     authors

Send Min Cols. Used by Standby Min Vers Dynamic SQL SQL Stmt.Rep.
-------------- --------------- -------- ----------- -------------
No             No               1000     On         UD

Col. Name   Rep. Col. Name   Datatype   Len.   Pri. Col.   Searchable
---------   --------------   --------   ----   ---------   ----------
au_id       au_id            varchar     11            1            1
au_lname    au_lname         varchar     40            0            1
au_fname    au_fname         varchar     20            0            1

Ref. Objowner   Ref. Objname
-------------   ------------


table2

Usage

Unless you enter parameters, rs_helprep lists summary information for all replication definitions in the Replication Server.
If you supply a replication_definition string, rs_helprep displays information about any replication definition whose name matches replication_definition.
If the replication_definition string matches exactly one replication definition name, detailed information about that replication definition displays. Information includes the primary Replication Server, data server and database, replication definition columns, functions defined for the replication definition, and subscriptions for the replication definition known by the Replication Server.
The detailed information displayed is slightly different for table replication definitions, function replication definitions, and system table replication definitions.
If the replication_definition string does not match exactly one replication definition name, summary information is displayed for any replication definitions that match replication_definition.
Quoted identifiers are displayed enclosed in double quote characters.
rs_helprep displays information about table references for real-time loading (RTL) and high volume adaptive replication (HVAR).
rs_helprep does not display database replication definition. Use rs_helpdbrep to display database replication definition.