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 Oct 2, 2007 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 -------------- --------------- -------- ----------- No No 1000 On 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)
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.
rs_helprep does not display database replication definition. Use rs_helpdbrep to display database replication definition.