rs_helprep
Displays information about replication definitions.
rs_helprep [<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.
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
- 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
- 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)
- 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)
- Given this table and replication definition:
create table t1 (c1 int, c2 int)
rs_helprep r1 displays <c2> as a quoted identifier:create replication definition r1 with primary at ost_wasatch_08.pdb1 with all tables named t1 (c1 int, "c2" int quoted) primary key (c1)
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)
- Given the table and replication definition defined in the preceding example, when you define <t1> as a quoted identifier:rs_helprep r1 displays <c2> and <t1> as quoted identifiers:
alter replication definition r1 alter replicate table name "t1" quoted
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)
- Given the replication definition defined in the preceding example, when you define <c2> as not quoted:rs_helprep r1 displays <t1> as the only quoted identifier:
alter replication definition r1 alter columns c2 not quoted
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)
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
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.