ChapterA 7.A Database Replication

Revision History
Revision V7.1-00323 November 2023
Revision V7.1-00219 September 2023
Revision V7.1-00126 June 2023
Revision V7.0-00502 December 2022
Revision V7.0-00324 June 2022
Revision V7.0-00229 March 2022
Revision V7.0-00124 November 2021
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 a??Instance Freezea??, 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 a??Proceduresa??.

Revision V6.2-00127 February 2015

In a??Starting the Source Servera??, added the NOJNLFILEONLY qualifier.

Revision V6.1-000/104 September 2014

In a??Proceduresa??, corrected the downloadable scripts example (msr_proc2.tar.gz) for setting up an Aa??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 Aa??B replication configuration with empty databases
Setting up an Aa??Ba??C replication configuration with empty databases
Setting up an Aa??P replication configuration with empty databases
Replicating Instance Starts from Backup of Originating Instance (Aa??B and Aa??P )
Switchover possibilities in an Aa??B replication configuration
Switchover possibilities in a Ba??Aa??P replication configuration
Switchover possibilities in a Ba??Aa??Pa??Q replication configuration
Changing the global directory in an Aa??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 (Aa??B, Pa??Q, or Aa??P)
Replacing the replication instance file of a replicating instance (Aa??B and Pa??Q)
Replacing the replication instance file of a replicating instance (Aa??P)
Setting up a new replicating instance from a backup of the originating instance (Aa??P)
Setting up an Aa??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 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...