Chapter 7. Database Replication

Revision History
Revision V6.3-008 24 April 2019
Revision V6.3-007 04 February 2019
Revision V6.3-006 26 October 2018
Revision V6.3-005 03 July 2018
Revision V6.3-004 23 March 2018
Revision V6.3-003 12 December 2017
Revision V6.3-002 22 August 2017
  • In “Instance Freeze”, add that MUPIP REPLICATE -SOURCE -JNLPOOL -SHOW displays the load status of the custom errors file.

Revision V6.3-001 20 March 2017
Revision V6.2-002

Added examples and improved the instructions in “Procedures”.

Revision V6.2-001 27 February 2015

In Starting the Source Server”, added the NOJNLFILEONLY qualifier.

Revision V6.1-000/1 04 September 2014

In “Procedures”, corrected the downloadable scripts example (msr_proc2.tar.gz) for setting up an A→P replication configuration.

Revision V6.1-000 01 August 2014
Revision V6.0-003/1 19 February 2014
Revision V6.0-003 27 January 2014
Revision V6.0-001/1 22 March 1013

Improved the formatting of all command syntaxes and corrected the description of the -helper qualifier.

Revision V6.0-001 27 February 2013
Revision V6.0-000/1 21 November 2012
Revision V6.0-000 19 October 2012

Table of Contents

Introduction
Database Transaction Number
Journal Sequence Number
Stream Sequence Number
Using Multiple Instances in the same Process
Examples
Limitations - SI Replication
Replication Architecture
Implementing Replication and Recovery
Application Architecture
System Requirements
Switchover
Instance Freeze
TLS/SSL Replication
Network Link between Systems
Choosing between BEFORE_IMAGE and NOBEFORE_IMAGE journaling
Database Repair
Procedures
Download Replication Examples
Setting up an A→B replication configuration with empty databases
Setting up an A→B→C replication configuration with empty databases
Setting up an A→P replication configuration with empty databases
Replicating Instance Starts from Backup of Originating Instance (A→B and A→P )
Switchover possibilities in an A→B replication configuration
Switchover possibilities in a B←A→P replication configuration
Switchover possibilities in a B←A→P→Q replication configuration
Changing the global directory in an A→B replication configuration
Rolling Software Upgrade
Shutting down an instance
Creating a new Replication Instance File
Setting up a secured TLS replication connection
Schema Change Filters
Recovering from the replication WAS_ON state
Rollback data from crashed (idle) regions
Setting up a new replicating instance of an originating instance (A→B, P→Q, or A→P)
Replacing the replication instance file of a replicating instance (A→B and P→Q)
Replacing the replication instance file of a replicating instance (A→P)
Setting up a new replicating instance from a backup of the originating instance (A→P)
Setting up an A→P configuration for the first time if P is an existing instance (having its own set of updates)
Commands and Qualifiers
Turning Replication On/Off
Creating the Replication Instance File
Displaying/Changing the attributes of Replication Instance File and Journal Pool
Starting the Source Server
Shutting down the Source Server
Activating a Passive Source Server
Deactivating an Active Source Server
Stopping the Source Filter
Checking Server Health
Changing the Log File
Enabling/Disabling Detailed Logging
Stopping a Source Server
Reporting the Current Backlog of Journal Records
Processing Lost Transactions File
Starting the Receiver Server
Starting the Update Process
Stopping the Update Process and/or the Receiver Server
Checking Server Health
Changing the Log File
Enabling/Disabling Detailed Logging
Reporting the Current Backlog of Journal Records
Rolling Back a Replicated Database