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)
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)
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)
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)
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 does not display database replication definition. Use rs_helpdbrep to display database replication definition.
