PUBLIC
SAP Replication Server 16.0 SP03
Document Version: 1.0 – 2018-08-15
Replication Server Administration Guide Volume 1
© 2018 SAP SE or an SAP aliate company. All rights reserved.
THE BEST RUN
Content
1 Conventions...............................................................12
2 Introduction to SAP Replication Server...........................................15
2.1 About Replication Server.......................................................15
Asynchronous Transaction Replication...........................................16
Advantages of Replicating Local Data............................................17
2.2 Replication Server and Distributed Database Systems.................................. 17
Replication Server Basic Primary Copy Model......................................19
Other Distributed Data Models................................................22
SAP Replication Server and Non-SAP ASE Data Servers.............................. 27
2.3 Warm Standby Applications.....................................................28
2.4 Mixed-Version Replication Systems............................................... 28
Restrictions in Mixed-Version Systems...........................................29
Mixed Versions of SAP ASE...................................................29
2.5 Replication System Security....................................................30
Replication Server Security Features............................................30
Network-based Security Features.............................................. 31
2.6 Replication Server Roles and Responsibilities.........................................31
Replication System Administrator..............................................32
Database Administrator.....................................................32
Replication Server Tasks and Responsibilities......................................32
3 SAP Replication Server Technical Overview....................................... 35
3.1 Replication System Components.................................................35
SAP Replication Server......................................................37
Replication Server System Database (RSSD)......................................39
Adaptive Server or Other Data Server...........................................40
Replication Agent..........................................................41
ExpressConnect for HANA DB.................................................41
ExpressConnect for Oracle...................................................42
Enterprise Connect Data Access...............................................42
Client Applications.........................................................42
System Management Tools...................................................43
3.2 Specify Data for Replication.....................................................43
Replication Denitions and Subscriptions for Tables.................................44
Replication Denitions for Database Objects...................................... 45
Replication Denitions for Stored Procedures......................................45
2
P U B LI C
Replication Server Administration Guide Volume 1
Content
Publications .............................................................47
Overview of Replicating Tables................................................ 47
Commands for Managing Replicated Data........................................48
3.3 Establish Replication Server Connections...........................................49
Interfaces File............................................................49
Kerberos................................................................50
LDAP Server.............................................................53
Make Replication Server Connections........................................... 61
3.4 Specify Database Operations....................................................62
Function Strings.......................................................... 63
Function-string Classes.....................................................63
3.5 Transaction Handling with Replication Server........................................ 63
Stable Queues............................................................64
Distributed Concurrency Control...............................................72
Transaction Processing by the Replication Agent....................................73
4 Manage a Replication System..................................................75
4.1 Set Up a Replication System.................................................... 75
Create Connections and Routes............................................... 76
Set Permissions and Security.................................................76
Verify the Replication System.................................................77
Create Replication Denitions.................................................77
Create Subscriptions.......................................................78
4.2 Perform Replication Server Tasks.................................................78
Use rs_init .............................................................. 79
Manage Replication Server with SAP Control Center.................................79
Use isql.................................................................79
4.3 Starting Replication Server.....................................................82
Replication Server Executable Program..........................................83
Replication Server Conguration File............................................83
4.4 Stopping a Replication Server Using isql............................................83
4.5 Add a Replication Server.......................................................84
4.6 Add a Replication System Domain................................................85
Guidelines for Adding Replication System Domains..................................85
4.7 Set Replication Server Conguration Parameters......................................87
Replication Server Conguration Parameters......................................87
Change SAP Replication Server Parameters.......................................90
4.8 Manage the RSSD............................................................92
Enable Failover Support for an RSSD Connection...................................92
4.9 Manage the Embedded Replication Server System Database............................. 93
Obtain Information on ERSSD Settings..........................................94
ERSSD Conguration Parameters and Command...................................94
Replication Server Administration Guide Volume 1
Content
P U B LI C 3
Backup ERSSD...........................................................95
ERSSD Routing...........................................................96
Move ERSSD Files.........................................................97
ERSSD User Administration..................................................97
Reduce ERSSD File Size.....................................................97
ERSSD Recovery Procedures.................................................98
4.10 Quiesce Replication Server.....................................................102
Quiescing a Replication System...............................................102
4.11 Remove a Replication Server................................................... 103
Removing an Active Replication Server..........................................103
Removing an Inactive Replication Server........................................ 105
5 Manage RepAgent and Support SAP ASE........................................ 107
5.1 Set up RepAgent............................................................108
Conguring RepAgent Using Command Line Options............................... 109
5.2 Conguring RepAgent........................................................112
5.3 Master Key and rs password....................................................113
5.4 Starting RepAgent...........................................................113
5.5 Stopping RepAgent..........................................................114
5.6 Disable RepAgent........................................................... 115
5.7 Congure RepAgent for Network Security.......................................... 115
5.8 Manage Log Transfer Activity................................................... 116
Suspend Log Transfer......................................................117
Resume Log Transfer.......................................................118
Use alter connection and the set log transfer Option.................................118
5.9 Review RepAgent Status and Conguration Information................................ 119
View RepAgent Information..................................................119
View RepAgent Conguration Parameter Values...................................120
View RepAgent Thread Information............................................120
5.10 Check Log Files for RepAgent Information and Error Messages............................121
5.11 Use Counters to Monitor RepAgent Performance..................................... 121
Invoke sp_sysmon........................................................122
Sample Output from sp_sysmon of RepAgent Activity...............................122
Description of Sample Output of RepAgent Counter Activity .......................... 124
5.12 Use Monitoring Tables to Monitor RepAgent.........................................127
5.13 Support for Extended Limits....................................................129
5.14 Support for Longer Identiers...................................................129
5.15 Support for bigdatetime and bigtime Datatypes ..................................... 130
System Table Support for bigdatetime and bigtime.................................132
Mixed-Version Information for bigdatetime and bigtime..............................132
5.16 Adaptive Server Shared-disk Cluster Support....................................... 133
5.17 Deferred Name Resolution.....................................................134
4
P U B LI C
Replication Server Administration Guide Volume 1
Content
5.18 Adaptive Server Data Compression...............................................135
SAP Replication Server Support for Compressed Data...............................135
Maintaining Data Integrity...................................................138
5.19 Support for Incremental Data Transfer............................................ 139
5.20 Predicated Privileges.........................................................139
5.21 Granular Permissions........................................................ 140
Granular Permissions and Replication Server Conguration........................... 141
Granular Permissions and Adding a User Database.................................145
Granular Permissions and User Database Upgrade................................. 145
Granular Permissions and Master Database Replication..............................146
Granular Permissions and DDL Replication.......................................146
5.22 Stored Procedure Replication and the execute as Clause................................146
5.23 Precomputed Result Sets......................................................148
Enabling Precomputed Result Sets Replication for Earlier Versions of Replication Server.......149
5.24 Transfer of Database Object Ownership............................................150
Replication Server Support for Transferring Object Ownership......................... 151
5.25 Performance Enhancements for Adaptive Server Replication.............................155
5.26 In-Memory and Relaxed-Durability Databases.......................................156
In-Memory Databases as Primary Databases for Replication...........................157
In-Memory Databases as Replicate Databases for Replication......................... 160
Restoration of In-Memory and Relaxed-Durability Databases..........................162
Enable Autocorrection..................................................... 166
Minimal DML Logging and Replication..........................................166
5.27 Replication Server Unsupported Operations.........................................167
6 Manage Routes............................................................169
6.1 Routing Preparation..........................................................170
6.2 Routing Rules..............................................................170
6.3 Routing Schemes............................................................171
Direct Routes............................................................171
Indirect Routes...........................................................172
Dedicated Routes.........................................................174
Unsupported Routing Schemes...............................................175
6.4 Create Routes..............................................................175
create route Command.....................................................176
6.5 Conguring a Replication Server to Manage Primary Tables..............................180
6.6 Suspend and Resume Routes...................................................182
6.7 Change Routes.............................................................183
Change Route Topolgy..................................................... 183
Changing the Password for the RSI User for a Direct Route............................187
Changing Parameters Aecting Direct Routes.....................................187
Changing Conguration Parameters for All Routes................................. 188
Replication Server Administration Guide Volume 1
Content
P U B LI C 5
