| Acknowledgments |
|
xx | |
| Introduction |
|
xxi | |
|
|
|
1 | (6) |
|
|
|
1 | (1) |
|
Advantages of Data Replication |
|
|
2 | (2) |
|
Data Replication and Failover Methods |
|
|
4 | (3) |
|
Hardware Data Replication |
|
|
4 | (1) |
|
Software Data Replication |
|
|
5 | (1) |
|
Software/Hardware Replication System |
|
|
5 | (2) |
|
The Replication Server Architecture |
|
|
7 | (20) |
|
|
|
7 | (2) |
|
Replication System Domain |
|
|
9 | (3) |
|
|
|
12 | (1) |
|
|
|
12 | (1) |
|
|
|
12 | (1) |
|
|
|
13 | (1) |
|
Replication Server Threads |
|
|
13 | (9) |
|
|
|
13 | (1) |
|
Stable Queue Manager (SQM) |
|
|
14 | (1) |
|
Stable Queue Transaction (SQT) |
|
|
15 | (2) |
|
|
|
17 | (1) |
|
|
|
17 | (1) |
|
Subscription Resolution Engine (SRE) |
|
|
18 | (1) |
|
Transaction Delivery Module (TD) |
|
|
18 | (1) |
|
Message Delivery Module (MD) |
|
|
18 | (1) |
|
Data Server Interface (DSI) |
|
|
19 | (1) |
|
|
|
20 | (1) |
|
|
|
20 | (1) |
|
Replication Server Interface (RSI) |
|
|
21 | (1) |
|
Replication Server Daemons |
|
|
22 | (5) |
|
|
|
22 | (1) |
|
|
|
23 | (1) |
|
Connection Manager Daemon (dCM) |
|
|
23 | (1) |
|
|
|
24 | (1) |
|
Subscription Retry Daemon (dSUB) |
|
|
24 | (1) |
|
|
|
25 | (2) |
|
Replication Design and Implementation Strategies |
|
|
27 | (24) |
|
Replication Design Terminology |
|
|
27 | (4) |
|
Distributed Data vs. Replicated Data |
|
|
27 | (1) |
|
|
|
28 | (1) |
|
Tight Consistency vs. Loose Consistency |
|
|
28 | (1) |
|
|
|
29 | (2) |
|
Replication Server Process Flow |
|
|
31 | (1) |
|
A Simplified Replication Model |
|
|
32 | (1) |
|
Application Types for Replication |
|
|
32 | (1) |
|
|
|
33 | (12) |
|
One-to-Many Regular Replication Model |
|
|
34 | (1) |
|
Multi-Site Availability Model with Warm Standby |
|
|
35 | (1) |
|
Peer-to-Peer Replication Model |
|
|
36 | (5) |
|
One-to-Many Peer-to-Peer Replication Model |
|
|
41 | (1) |
|
Many-to-Many Peer-to-Peer Replication Model |
|
|
42 | (2) |
|
A Peer-to-Peer Replication Model with Warm Standby |
|
|
44 | (1) |
|
Replication Design Strategies |
|
|
45 | (4) |
|
Replication Strategy for Backup |
|
|
46 | (1) |
|
Replication for Application Partitioning |
|
|
47 | (1) |
|
|
|
48 | (1) |
|
Managing Intersite Update Conflicts |
|
|
49 | (2) |
|
Replication Server Installation and Upgrade |
|
|
51 | (48) |
|
|
|
52 | (1) |
|
Replication Server Installation |
|
|
53 | (30) |
|
Software Extraction Using InstallShield |
|
|
53 | (1) |
|
Replication Server Installation Using Console Mode |
|
|
54 | (12) |
|
Generating a Reusable Resource File |
|
|
66 | (6) |
|
Preparing a Resource File or Response File |
|
|
72 | (8) |
|
Installing Replication Server Using rs_init Utility with the Response File |
|
|
80 | (1) |
|
|
|
80 | (1) |
|
|
|
81 | (2) |
|
|
|
83 | (5) |
|
Replication Server Initial Configuration |
|
|
84 | (1) |
|
Adding a Database to the Replication System |
|
|
84 | (4) |
|
Replication Server Upgrade |
|
|
88 | (11) |
|
Installing the New Replication Server Software |
|
|
89 | (1) |
|
Upgrading the Replication Server RSSD |
|
|
89 | (5) |
|
Post RSSD Upgrade Process |
|
|
94 | (2) |
|
Upgrading a User Database |
|
|
96 | (1) |
|
|
|
97 | (2) |
|
|
|
99 | (42) |
|
Configuring Replication Server |
|
|
101 | (14) |
|
|
|
103 | (1) |
|
|
|
103 | (1) |
|
|
|
104 | (1) |
|
|
|
104 | (1) |
|
|
|
104 | (1) |
|
|
|
105 | (1) |
|
|
|
105 | (1) |
|
|
|
106 | (1) |
|
|
|
106 | (1) |
|
|
|
106 | (1) |
|
|
|
106 | (1) |
|
|
|
107 | (1) |
|
|
|
107 | (1) |
|
|
|
107 | (1) |
|
|
|
108 | (1) |
|
|
|
108 | (1) |
|
|
|
108 | (1) |
|
|
|
108 | (1) |
|
|
|
109 | (1) |
|
|
|
109 | (1) |
|
|
|
109 | (1) |
|
|
|
109 | (1) |
|
|
|
110 | (1) |
|
|
|
110 | (1) |
|
|
|
110 | (1) |
|
|
|
111 | (1) |
|
|
|
111 | (1) |
|
|
|
111 | (1) |
|
|
|
112 | (1) |
|
|
|
112 | (1) |
|
sts_full_cache_rssd_system_table |
|
|
112 | (2) |
|
|
|
114 | (1) |
|
|
|
114 | (1) |
|
|
|
114 | (1) |
|
|
|
114 | (1) |
|
|
|
115 | (1) |
|
Configuration Parameters for Both Database Connection and Route |
|
|
115 | (3) |
|
|
|
115 | (1) |
|
|
|
115 | (1) |
|
|
|
116 | (1) |
|
|
|
116 | (1) |
|
|
|
116 | (1) |
|
|
|
116 | (1) |
|
|
|
117 | (1) |
|
|
|
117 | (1) |
|
|
|
117 | (1) |
|
|
|
118 | (1) |
|
Configuration Parameters Unique to Database Connection (DSI) |
|
|
118 | (16) |
|
|
|
118 | (1) |
|
|
|
119 | (1) |
|
|
|
119 | (1) |
|
|
|
120 | (1) |
|
|
|
120 | (1) |
|
|
|
121 | (1) |
|
dsi_commit_check_locks_intrvl |
|
|
121 | (1) |
|
dsi_commit_check_locks_log |
|
|
121 | (1) |
|
dsi_commit_check_locks_max |
|
|
122 | (1) |
|
|
|
122 | (1) |
|
|
|
122 | (1) |
|
|
|
122 | (1) |
|
dsi_ignore_underscore_name |
|
|
123 | (1) |
|
|
|
123 | (1) |
|
|
|
124 | (1) |
|
|
|
124 | (1) |
|
|
|
124 | (1) |
|
|
|
125 | (1) |
|
|
|
125 | (1) |
|
dsi_num_large_xact_threads |
|
|
125 | (1) |
|
|
|
125 | (1) |
|
|
|
125 | (1) |
|
|
|
126 | (1) |
|
|
|
126 | (1) |
|
|
|
127 | (1) |
|
|
|
127 | (1) |
|
|
|
128 | (1) |
|
|
|
128 | (1) |
|
dsi_text_convert_multiplier |
|
|
129 | (1) |
|
|
|
129 | (1) |
|
|
|
130 | (1) |
|
|
|
130 | (1) |
|
dynamic_sql_cache_management |
|
|
130 | (1) |
|
|
|
131 | (1) |
|
|
|
132 | (1) |
|
exec_sqm_write_request_limit |
|
|
132 | (1) |
|
md_sqm_write_request_limit |
|
|
132 | (1) |
|
|
|
133 | (1) |
|
|
|
133 | (1) |
|
sub_sqm_write_request_limit |
|
|
133 | (1) |
|
Configuration Parameters Unique to Replication Server Route |
|
|
134 | (1) |
|
|
|
134 | (1) |
|
|
|
134 | (1) |
|
|
|
135 | (1) |
|
|
|
135 | |
|
Configuration Parameters Unique to Replication Server Route |
|
|
134 | (2) |
|
|
|
134 | (1) |
|
|
|
134 | (1) |
|
|
|
135 | (1) |
|
|
|
135 | (1) |
|
Security Configuration Parameters for Connecting to the ID Server |
|
|
136 | (2) |
|
|
|
136 | (1) |
|
|
|
136 | (1) |
|
|
|
136 | (1) |
|
|
|
136 | (1) |
|
|
|
137 | (1) |
|
|
|
137 | (1) |
|
|
|
137 | (1) |
|
|
|
137 | (1) |
|
|
|
137 | (1) |
|
Other Valid Replication Server Configuration Parameters |
|
|
138 | (1) |
|
|
|
138 | (1) |
|
|
|
138 | (1) |
|
|
|
138 | (1) |
|
|
|
138 | (1) |
|
Embedded RSSD Configuration Parameters |
|
|
139 | (2) |
|
|
|
139 | (1) |
|
|
|
139 | (1) |
|
|
|
139 | (1) |
|
|
|
139 | (1) |
|
|
|
140 | (1) |
|
|
|
141 | (14) |
|
|
|
142 | (1) |
|
|
|
142 | (1) |
|
|
|
142 | (1) |
|
Microsoft SQL Server 2005 Support |
|
|
143 | (1) |
|
Sybase Adaptive Server Enterprise 15.0 Support |
|
|
143 | (1) |
|
Common Installation Requirements for Replication Agent 15.0 |
|
|
143 | (2) |
|
Replication Agent Configuration |
|
|
145 | (3) |
|
Replication Agent Installation for Sybase Databases |
|
|
148 | (3) |
|
Add Replication Agent for Sybase Databases |
|
|
149 | (1) |
|
Configure RepAgent for the Database |
|
|
150 | (1) |
|
Replication Agent Installation for Non-Sybase Databases |
|
|
151 | (4) |
|
Pre-installation Requirements |
|
|
151 | (1) |
|
|
|
152 | (2) |
|
Post-installation Administration |
|
|
154 | (1) |
|
|
|
155 | (16) |
|
Creating Connections Using Create Connection |
|
|
157 | (9) |
|
|
|
166 | (1) |
|
|
|
167 | (1) |
|
|
|
168 | (3) |
|
|
|
171 | (28) |
|
|
|
172 | (3) |
|
|
|
172 | (1) |
|
|
|
173 | (1) |
|
|
|
174 | (1) |
|
|
|
175 | (8) |
|
|
|
183 | (6) |
|
Altering RSI User Password |
|
|
184 | (1) |
|
Changing an Indirect Route to a Direct Route |
|
|
185 | (1) |
|
Changing a Direct Route to an Indirect Route |
|
|
186 | (1) |
|
Changing the Next Site (Intermediate Site) for an Indirect Route |
|
|
186 | (2) |
|
Changing Route Parameters |
|
|
188 | (1) |
|
Suspending and Resuming Routes |
|
|
189 | (1) |
|
|
|
190 | (2) |
|
|
|
192 | (3) |
|
|
|
195 | (4) |
|
Managing Replicated Tables and Stored Procedures |
|
|
199 | (32) |
|
Replication Definitions and Subscription Definitions |
|
|
201 | (15) |
|
Create a Replication Definition |
|
|
202 | (8) |
|
Altering a Replication Definition |
|
|
210 | (1) |
|
Marking Tables for Replication |
|
|
211 | (1) |
|
Replicating Tables with text, unitext, image, and rawobject Datatypes |
|
|
212 | (1) |
|
Replicating Tables with Computed Columns |
|
|
213 | (1) |
|
Replicating Tables with Encrypted Columns |
|
|
214 | (1) |
|
Replicating Tables with Different Ownership |
|
|
214 | (1) |
|
Creating Replication Definition for Java Columns |
|
|
214 | (2) |
|
Managing Replicated Stored Procedures |
|
|
216 | (7) |
|
|
|
216 | (1) |
|
|
|
217 | (1) |
|
Setting Up Function Replication |
|
|
218 | (1) |
|
Setting Up Applied Function Replication |
|
|
218 | (3) |
|
Setting Up Request Function Replication |
|
|
221 | (2) |
|
|
|
223 | (6) |
|
|
|
227 | (1) |
|
|
|
228 | (1) |
|
Disabling Replication for a User Object |
|
|
228 | (1) |
|
Dropping Replication Definitions |
|
|
229 | (2) |
|
|
|
231 | (18) |
|
Subscription Coordination Process |
|
|
232 | (2) |
|
|
|
234 | (3) |
|
|
|
235 | (1) |
|
Nonatomic Materialization |
|
|
235 | (1) |
|
|
|
236 | (1) |
|
|
|
236 | (1) |
|
Subscription Dematerialization |
|
|
237 | (1) |
|
Creating Subscriptions Using Atomic Materialization |
|
|
238 | (4) |
|
Creating Subscriptions Using Bulk Materialization |
|
|
242 | (5) |
|
Subscriptions and Autocorrection |
|
|
247 | (1) |
|
Materializing text, unitext, image, and rawobject Data |
|
|
248 | (1) |
|
Functions and Function Strings |
|
|
249 | (22) |
|
DSI Thread and Function Strings |
|
|
256 | (1) |
|
Managing Function Strings |
|
|
256 | (1) |
|
Creating a User-defined Function |
|
|
257 | (1) |
|
Creating a Function-String Class |
|
|
258 | (2) |
|
Creating a Function String |
|
|
260 | (6) |
|
Assigning a Function-String Class to a Connection |
|
|
266 | (1) |
|
Dropping a Function String |
|
|
266 | (2) |
|
|
|
268 | (1) |
|
Dropping a Function-String Class |
|
|
269 | (2) |
|
|
|
271 | (58) |
|
Warm Standby vs. Hot Standby System |
|
|
271 | (2) |
|
|
|
273 | (2) |
|
Regular Replication vs. Warm Standby |
|
|
275 | (4) |
|
Data Modification Language (DML) |
|
|
276 | (1) |
|
Data Definition Language (DDL) |
|
|
276 | (3) |
|
Enabling Replication to Standby Database |
|
|
279 | (3) |
|
|
|
282 | (19) |
|
Creating a Logical Connection |
|
|
282 | (1) |
|
Adding the Active Database |
|
|
283 | (3) |
|
Enabling Replication in Active Database |
|
|
286 | (2) |
|
Adding the Standby Database |
|
|
288 | (1) |
|
|
|
289 | (1) |
|
Adding the Maintenance User to the Standby Database |
|
|
289 | (1) |
|
Initializing the Standby Database |
|
|
290 | (3) |
|
Adding the Standby Database to the Replication System |
|
|
293 | (3) |
|
Maintenance User Permissions |
|
|
296 | (1) |
|
Enabling Replication in the Standby Database |
|
|
297 | (1) |
|
Altering the Warm Standby Connections |
|
|
297 | (1) |
|
Altering the Logical Connection |
|
|
297 | (3) |
|
Replicating truncate table to the Standby Database |
|
|
300 | (1) |
|
Altering the Physical Connections |
|
|
300 | (1) |
|
|
|
301 | (2) |
|
Warm Standby as Replicate Database |
|
|
303 | (4) |
|
System Tables and System Stored Procedures for Warm Standby Setup |
|
|
307 | (4) |
|
|
|
307 | (2) |
|
|
|
309 | (1) |
|
|
|
309 | (1) |
|
|
|
310 | (1) |
|
Using Replication Definitions and Subscriptions |
|
|
311 | (7) |
|
|
|
318 | (11) |
|
|
|
329 | (22) |
|
RSSD System Tables Relevant to MSA |
|
|
331 | (1) |
|
|
|
332 | (18) |
|
Setting Up Multiple Replicate Databases |
|
|
336 | (1) |
|
|
|
336 | (7) |
|
|
|
343 | (1) |
|
Dropping a Database Subscription |
|
|
343 | (1) |
|
Dropping Database Replication Definition |
|
|
344 | (1) |
|
Altering a Database Replication Definition |
|
|
344 | (6) |
|
|
|
350 | (1) |
|
|
|
350 | (1) |
|
Performance Monitoring and Tuning |
|
|
351 | (134) |
|
|
|
352 | (8) |
|
Monitoring with admin who |
|
|
353 | (3) |
|
Improper Replication Server Configuration |
|
|
356 | (1) |
|
Ignoring the Replicate DBMS |
|
|
357 | (1) |
|
Application Design Issues |
|
|
358 | (1) |
|
|
|
359 | (1) |
|
Performance Monitoring Tools |
|
|
360 | (23) |
|
|
|
360 | (1) |
|
|
|
361 | (3) |
|
|
|
364 | (3) |
|
|
|
367 | (2) |
|
|
|
369 | (3) |
|
|
|
372 | (1) |
|
|
|
373 | (4) |
|
Run-time/Client Statistics Viewing |
|
|
377 | (2) |
|
|
|
379 | (1) |
|
|
|
379 | (3) |
|
|
|
382 | (1) |
|
|
|
383 | (1) |
|
Analyzing Performance Metrics |
|
|
383 | (9) |
|
|
|
384 | (1) |
|
|
|
384 | (4) |
|
|
|
388 | (1) |
|
|
|
388 | (1) |
|
|
|
389 | (1) |
|
|
|
390 | (2) |
|
Replication Agent User (EXEC) |
|
|
392 | (10) |
|
|
|
393 | (1) |
|
|
|
394 | (3) |
|
|
|
397 | (5) |
|
Stable Queue Manager (SQM) |
|
|
402 | (12) |
|
|
|
403 | (1) |
|
|
|
404 | (4) |
|
|
|
408 | (6) |
|
Stable Queue Transaction (SQT) |
|
|
414 | (14) |
|
|
|
417 | (1) |
|
|
|
417 | (10) |
|
|
|
427 | (1) |
|
|
|
428 | (11) |
|
|
|
430 | (1) |
|
|
|
431 | (4) |
|
|
|
435 | (4) |
|
Data Server Interface (DSI) |
|
|
439 | (11) |
|
|
|
440 | (1) |
|
|
|
440 | (9) |
|
|
|
449 | (1) |
|
|
|
450 | (24) |
|
|
|
452 | (1) |
|
|
|
453 | (7) |
|
|
|
460 | (14) |
|
Replication Server Interface (RSI) and RSI User |
|
|
474 | (8) |
|
|
|
474 | (1) |
|
|
|
475 | (5) |
|
|
|
480 | (2) |
|
|
|
482 | (3) |
|
|
|
482 | (1) |
|
Collecting Replication Server Monitor Counters |
|
|
482 | (1) |
|
Primary and Replicate DBMS |
|
|
483 | (2) |
|
|
|
485 | (72) |
|
|
|
485 | (1) |
|
Short Duration Transient Failures |
|
|
485 | (1) |
|
Long Duration Transient Failures |
|
|
486 | (1) |
|
Failures Causing Data Loss |
|
|
486 | (1) |
|
Disaster Recovery Fundamentals |
|
|
486 | (1) |
|
Functionality of Adaptive Server Enterprise Transaction Log |
|
|
487 | (2) |
|
Secondary Truncation Point Issues |
|
|
489 | (3) |
|
|
|
492 | (4) |
|
Creating a Coordinated Dump |
|
|
492 | (3) |
|
Up-to-the-Minute Recovery |
|
|
495 | (1) |
|
|
|
496 | (1) |
|
Configuring Replication Server for HA Failover |
|
|
496 | (1) |
|
Save Interval and Recovery |
|
|
497 | (2) |
|
The Origin Queue ID and the Generation ID |
|
|
499 | (15) |
|
|
|
499 | (1) |
|
rs_subcmp to Reconcile Data and Schema |
|
|
500 | (14) |
|
Recovering the Primary Database |
|
|
514 | (9) |
|
Recovery with Coordinated Dumps |
|
|
515 | (2) |
|
Loading Primary Database from Dumps |
|
|
517 | (2) |
|
Recovering from Truncated Primary Database Transaction Log |
|
|
519 | (4) |
|
Recovering the RSSD Database |
|
|
523 | (20) |
|
Recovering the RSSD Database with Up-to-the-Minute Backup |
|
|
524 | (1) |
|
Basic Recovery of an RSSD Database |
|
|
525 | (3) |
|
Subscription Comparison Procedure for Failed RSSD Database |
|
|
528 | (3) |
|
Sample rs_subcmp Select Statements |
|
|
531 | (6) |
|
Subscription Recreation for a Failed RSSD |
|
|
537 | (6) |
|
Deintegration/Reintegration Procedure |
|
|
543 | (1) |
|
Removing Replication Server from the Replication System |
|
|
543 | (1) |
|
Recovering from a Damaged Partition |
|
|
544 | (10) |
|
RSSD System Tables that Store Partition Information |
|
|
545 | (5) |
|
Recovering from a Failed or Lost Partition |
|
|
550 | (1) |
|
Message Recovery from the Online Database Transaction Log |
|
|
551 | (1) |
|
Message Recovery from the Offline Database Transaction Log |
|
|
552 | (2) |
|
Summary Plan for Recovery |
|
|
554 | (3) |
|
|
|
557 | (138) |
|
Sybase Replication System for Non-Sybase Data Servers |
|
|
557 | (9) |
|
|
|
558 | (1) |
|
Types of Replication Agents |
|
|
558 | (1) |
|
Sybase Enterprise Connect Data Access |
|
|
559 | (1) |
|
|
|
559 | (7) |
|
Replication Agent Installation |
|
|
566 | (2) |
|
Configuring DirectConnect for Oracle |
|
|
568 | (9) |
|
Creating Maintenance User in Oracle |
|
|
569 | (1) |
|
Creating DDL User in Oracle |
|
|
569 | (1) |
|
Creating Objects and Public Synonyms in Oracle SID |
|
|
570 | (2) |
|
Checking Current Archiving Settings of Redo Logs |
|
|
572 | (1) |
|
Disabling Automatic Archiving |
|
|
573 | (1) |
|
Forced Logging of All Database Changes |
|
|
574 | (2) |
|
|
|
576 | (1) |
|
Configuring Replication Server |
|
|
577 | (30) |
|
Configuring a Replication Agent Instance |
|
|
583 | (9) |
|
Creating a Replication Agent Instance |
|
|
592 | (8) |
|
Starting a Replication Agent Instance |
|
|
600 | (3) |
|
Stopping a Replication Agent Instance |
|
|
603 | (1) |
|
Quiescing a Replication Agent Instance |
|
|
604 | (1) |
|
Initializing a Replication Agent Instance |
|
|
604 | (2) |
|
Suspending a Replication Agent Instance |
|
|
606 | (1) |
|
Creating Administrator User Login |
|
|
607 | (1) |
|
Configuring Replication Agent Connection Configuration Parameters |
|
|
607 | (12) |
|
Configuring Connection Parameters for Oracle SID (Primary Data Server) |
|
|
608 | (3) |
|
New Replication Agent Configuration Parameters for Oracle RAC in Replication Agent 15.1 |
|
|
611 | (2) |
|
Configuring Connection Parameters for the Replication Server |
|
|
613 | (3) |
|
Configuring Replication Agent Instance Connection Parameters for the RSSD (or ERSSD) |
|
|
616 | (3) |
|
Replication Agent Transaction Log Management |
|
|
619 | (6) |
|
Removing the Replication Agent Transaction Log |
|
|
619 | (3) |
|
Truncating the Replication Agent Transaction Log |
|
|
622 | (1) |
|
|
|
622 | (2) |
|
|
|
624 | (1) |
|
Marking Objects for Replication in the Primary Database |
|
|
625 | (4) |
|
Enabling and Disabling Replication for User Objects |
|
|
625 | (1) |
|
Enabling and Disabling DDL Replication |
|
|
626 | (1) |
|
Enabling and Disabling Stored Procedure Replication |
|
|
627 | (1) |
|
Enabling and Disabling Sequence Replication |
|
|
627 | (2) |
|
Oracle Database Specific Issues |
|
|
629 | (13) |
|
Character Case of Database Object Names |
|
|
629 | (1) |
|
Datatype Compatibility Issues |
|
|
630 | (4) |
|
Oracle Large Object (LOB) Datatype Support |
|
|
634 | (1) |
|
Oracle User-Defined Datatypes |
|
|
635 | (7) |
|
Configuring and Tuning Replication Agent for Oracle |
|
|
642 | (14) |
|
Parameters for Tuning Replication Agent Throughput |
|
|
651 | (3) |
|
Parameters for Tuning Replication Agent Latency |
|
|
654 | (2) |
|
Tuning the Size of the Replication Agent Instance System Log |
|
|
656 | (1) |
|
Troubleshooting Replication Agent |
|
|
656 | (21) |
|
Troubleshooting Replication Agent System Database (RASD) |
|
|
677 | (10) |
|
|
|
682 | (1) |
|
Updating the Log Device Repository in RASD |
|
|
683 | (2) |
|
Recovering from Corrupted RASD |
|
|
685 | (1) |
|
Restoring RASD from Backup |
|
|
686 | (1) |
|
Typical Topology of Heterogeneous Replication |
|
|
687 | (8) |
|
One-way Replication from Oracle to Sybase Adaptive Server Enterprise |
|
|
687 | (1) |
|
Replicating from Sybase Adaptive Server Enterprise to Oracle |
|
|
688 | (2) |
|
Replicating from Non-Sybase Primary to Non-Sybase Replicate Database |
|
|
690 | (2) |
|
Bidirectional Replication with Non-Sybase Primary and Non-Sybase Replicate Databases |
|
|
692 | (3) |
|
|
|
695 | (16) |
|
Login Names and Password Management |
|
|
695 | (5) |
|
Primary User and Maintenance User |
|
|
697 | (1) |
|
|
|
697 | (1) |
|
|
|
697 | (1) |
|
|
|
698 | (1) |
|
|
|
698 | (1) |
|
|
|
698 | (1) |
|
ID Server Login and Password |
|
|
699 | (1) |
|
Replication Server Interface (RSI) Login and Password |
|
|
699 | (1) |
|
Adaptive Server Maintenance User Login and Password |
|
|
700 | (1) |
|
Client Connections and Encrypted Passwords |
|
|
700 | (1) |
|
Encrypting Existing Passwords |
|
|
701 | (1) |
|
Disabling Password Encryption |
|
|
702 | (1) |
|
RSSD System Tables and Password Encryption |
|
|
703 | (2) |
|
|
|
705 | (6) |
|
Setting Up Network-based Security |
|
|
706 | (1) |
|
Changing the Configuration Parameters |
|
|
706 | (2) |
|
Identifying the Replication Server Principal User |
|
|
708 | (1) |
|
Activating Network-based Security |
|
|
709 | (2) |
|
|
|
711 | (14) |
|
|
|
711 | (2) |
|
|
|
713 | (3) |
|
|
|
716 | (2) |
|
|
|
717 | (1) |
|
|
|
717 | (1) |
|
|
|
717 | (1) |
|
|
|
718 | (3) |
|
|
|
720 | (1) |
|
Changing the Character Set and Sort Order |
|
|
721 | (4) |
|
|
|
725 | (20) |
|
Installing ERSSD Using rs_init |
|
|
726 | (1) |
|
Special Features of ERSSD and Replication Server 15.0 Enhancements |
|
|
727 | (1) |
|
|
|
728 | (1) |
|
|
|
729 | (5) |
|
|
|
730 | (1) |
|
Reconfiguring the ERSSD Backup Settings |
|
|
731 | (1) |
|
Relocating the ERSSD Backup Files |
|
|
732 | (2) |
|
|
|
734 | (2) |
|
|
|
736 | (1) |
|
|
|
737 | (8) |
|
|
|
737 | (1) |
|
|
|
738 | (7) |
|
|
|
745 | (50) |
|
|
|
745 | (19) |
|
|
|
745 | (1) |
|
Missing Replication Server Name in Interfaces |
|
|
746 | (1) |
|
|
|
747 | (1) |
|
Misconfigured Replication Agent |
|
|
747 | (1) |
|
|
|
748 | (1) |
|
|
|
748 | (3) |
|
Primary Database Transaction Log Full |
|
|
751 | (3) |
|
Standby Database Transaction Log Full |
|
|
754 | (1) |
|
|
|
755 | (1) |
|
Replication Status Inconsistency of text, unitext, or image Columns |
|
|
756 | (2) |
|
|
|
758 | (1) |
|
|
|
759 | (1) |
|
|
|
760 | (1) |
|
|
|
761 | (1) |
|
|
|
761 | (1) |
|
|
|
761 | (1) |
|
|
|
762 | (1) |
|
|
|
762 | (1) |
|
|
|
763 | (1) |
|
|
|
764 | (11) |
|
States of DSI Scheduler Thread |
|
|
767 | (1) |
|
States of DSI Executor Thread |
|
|
768 | (1) |
|
Creating an Error Class for Duplicate Key |
|
|
769 | (1) |
|
Turning On DSI Trace Flags |
|
|
769 | (1) |
|
Turning Off DSI Trace Flags |
|
|
770 | (1) |
|
|
|
771 | (1) |
|
|
|
772 | (1) |
|
|
|
772 | (1) |
|
|
|
773 | (1) |
|
Connection Failures with Asynchronous Transaction and DDL Replication |
|
|
773 | (2) |
|
|
|
775 | (6) |
|
|
|
777 | (1) |
|
|
|
778 | (1) |
|
text/image Column Replication Status and the Null Property |
|
|
779 | (1) |
|
Missing Column in Replication Definition |
|
|
780 | (1) |
|
|
|
780 | (1) |
|
Replication Server Errors |
|
|
781 | (1) |
|
|
|
782 | (1) |
|
|
|
782 | (8) |
|
Queues Are Full, They Are Not Getting Truncated |
|
|
783 | (2) |
|
Open Transaction in the Inbound Queue |
|
|
785 | (2) |
|
|
|
787 | (3) |
|
Data Not Being Replicated |
|
|
790 | (4) |
|
|
|
791 | (1) |
|
|
|
792 | (1) |
|
|
|
793 | (1) |
|
|
|
794 | (1) |
| Appendix A Origin Queue ID |
|
795 | (2) |
| Appendix B Removing the Active Replication Server from the Replication System |
|
797 | (4) |
| Appendix C Useful Queries |
|
801 | (4) |
| Index |
|
805 | |
