Chapter 7. Database Replication

Revision History
Revision V7.0-00012 February 2021
Revision V6.3-01406 October 2020
Revision V6.3-01330 June 2020
Revision V6.3-01120 December 2019
Revision V6.3-00927 June 2019
Revision V6.3-00824 April 2019
Revision V6.3-00704 February 2019
Revision V6.3-00626 October 2018
Revision V6.3-00503 July 2018
Revision V6.3-00423 March 2018
Revision V6.3-00312 December 2017
Revision V6.3-00222 August 2017
  • In “Instance Freeze”, add that MUPIP REPLICATE -SOURCE -JNLPOOL -SHOW displays the load status of the custom errors file.

Revision V6.3-00120 March 2017
Revision V6.2-002

Added examples and improved the instructions in “Procedures”.

Revision V6.2-00127 February 2015

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

Revision V6.1-000/104 September 2014

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

Revision V6.1-00001 August 2014
Revision V6.0-003/119 February 2014
Revision V6.0-00327 January 2014
Revision V6.0-001/122 March 1013

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

Revision V6.0-00127 February 2013
Revision V6.0-000/121 November 2012
Revision V6.0-00019 October 2012

Contents

Introduction
LMS Group
Database Transaction Number
Journal Sequence Number
Stream Sequence Number
Instance Bound Global Directories
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
Stopping the Receiver Filter
Freezing an Instance
Checking Server Health
Changing the Log File
Enabling/Disabling Detailed Logging
Reporting the Current Backlog of Journal Records
Processing Lost Transactions File
Starting the Receiver Server
Starting the Update Process
Stopping the the Receiver Server and/or the Update Process
Checking Server Health
Changing the Log File
Enabling/Disabling Detailed Logging
Reporting the Current Backlog of Journal Records
Rolling Back a Replicated Database
loading table of contents...