Chapter 7. Database Replication
 

In “Setting up an A→P replication configuration with empty databases”, clarify the instuctions

In “Instance Bound Global Directories ”, Describe use of second argument for JNLPOOL

In “Starting the Source Server”, journal extract delimiter is backslash

In “Instance Freeze”, Note StatDB non-participation in Instance Freeze

In “Starting the Source Server”, Clarify renegotiation for inter-version replication

In “Starting the Receiver Server ”, document {SEND|RECV}BUFFSIZE qualifiers for receiver

In “Starting the Source Server”, document the new -[NO]{SEND|RECV}BUFFSIZE qualifier to specify TCP buffer sizing

In “Starting the Source Server”, add information about the importance of the size of the Receiver Pool

In “Stopping the Receiver Server and/or the Update Process”, fixed a typo in the title

In “Introduction”, add minor note about bandwidth consideration

In “Starting the Source Server”, remove information about compiling zlib. Warn about TLSv1.3 and renegotiation vs key update

In “Starting the Source Server”, correct formatting

In “Starting the Source Server”, improve the description of -RENEGOTIATE_INTERVAL.

In “Starting the Receiver Server ”, Connection restarts with -updateresync

In “Starting the Update Process”, Starting replication with no helper processes

In “Reporting the Current Backlog of Journal Records”, add information about the acknowledgement sequence number and examples

In “Shutting down the Source Server”, add information about -ZEROBACKLOG and -TIMEOUT.

In “Creating the Replication Instance File”, add reference to gtm_repl_instname and gtm_repl_instance.

In “Switchover possibilities in an A→B replication configuration”, fixed default wait period to 30 seconds

In “Shutting down the Source Server”, added the default and max value of -timeout and information about the internal max wait time.

In “Starting the Source Server”, add -CONNECTPARAMS information and adjust the maximum -BUFFSIZE

In “Setting up an A→B→C replication configuration with empty databases”, Minor formatting adjustment

In “Setting up an A→B replication configuration with empty databases”, Minor formatting adjustment

In “Setting up an A→P replication configuration with empty databases”, formatting adjustment of the note.

In “Starting the Source Server”, Adjust replication -buffsize maximum

In “Instance Bound Global Directories ”, simplify the content to encourage the use of replication and instance bound global directories.

In “Introduction”, content improvement

In “Replication Architecture ”, add more information about the purpose of a passive Source Server and general content improvements.

In “Freezing an Instance”, add new section.

In “Replication Instance File”, add a reference to autorollback

In “Starting the Source Server”, specify the default value for -connectparams; content improvements; organize qualifiers by relevance.

In “Stopping the Receiver Filter”, add new section.

In “Stopping the Source Filter”, add -instsecondary qualifier to specify the Source Server target for stopping the Source filter.

In “Starting the Receiver Server ”, organize qualifiers by relevance.

In “Checking Server Health”, source -checkhealth does not accept -helpers option

In “Checking Server Health”, receiver -checkhealth supports -helpers option

In “Download Replication Examples”, remove redundant material.

In “Starting the Source Server”, specify that MUPIP ignores the -BUFFSIZE qualifier when the Journal Pool is already set up.

In “TLS/SSL Replication”, remove redundant material.

In “Setting up a secured TLS replication connection”, remove redundant material.

In “Replicating Instance Starts from Backup of Originating Instance (A→B and A→P )”, Use PREVLINK when taking a backup to be used exclusively for replication.

In “Rolling Back a Replicated Database ”, correct the description of -FETCHRESYNC.

In “Starting the Receiver Server ”, improve the description of -AUTOROLLBACK.

In “Displaying/Changing the attributes of Replication Instance File and Journal Pool”, add information about the -cleanslot qualifier.

In “Introduction”, correct the alignment of bc_repl.svg.

In “Setting up a secured TLS replication connection”, make corrections and add clarification about openssl.conf

In “Why do we need a $gtmcrypt_config file?”, Disable SSLv3

In “Download Replication Examples”, adjust formatting to fix a PDF rendering issue

In “Instance Bound Global Directories ”, fix a typo.

In “Rollback data from crashed (idle) regions”, add procedure to rollback data from crashed (idle) regions

In “Starting the Source Server”, specify that the Source Server directs errors to the log file, add fixes for the filter example

In “Comparison other than Recovery”, correct incomplete statement

In “Download Replication Examples”, changing script title to env and spell change

In “Instance Bound Global Directories ”, add new section

In “Replication Instance File”, instance reconnect on the basis of most recent shared journal seq number

In “Recovery”, corrections and improvements

In “Starting the Source Server”, correct the quoting of the -filter qualifier and remove -replicate

In “Introduction”, add information about using extended global references or SET $ZGBLDIR to update another source instance.

In “Creating a new Replication Instance File”, Updated GTM version

In “Instance Freeze”, add that MUPIP REPLICATE -SOURCE -JNLPOOL -SHOW displays the load status of the custom errors file.

In “A and P require rollback”, used capitals for keywords

In “Why do we need a $gtmcrypt_config file?”, fixed a minor typo

In “Creating the Replication Instance File”, added the description of the -noqdbrundown qualifier.

In “Displaying/Changing the attributes of Replication Instance File and Journal Pool”, added the description of the -noqdbrundown qualifier.

In “Changing the global directory in an A→B replication configuration”, added a new procedures for changing global directory settings in an A->B replication configuration; minor tweak to wording

In “Helper Processes”, specified that Helper Processes increase replication throughput, decrease backlog, and improve manageability.

In “Instance Freeze”, removed the reference to the Instance Freeze as field test grade implementation. The Instance Freeze facility became production grade in V6.0-001.

In “Procedures”, rewrote most sections and added downloadable replication example scripts.

In “Switchover possibilities in a B←A→P→Q replication configuration ”, updated for V6.3-000A

In “Replication Instance File”, used caps for keywords

In “Recovery”, used capitals for keywords and leading delimiters for qualifiers

In “Replicating Instance Starts from Backup of Originating Instance (A→B and A→P )”, followed convention of capitalizing key words when they are outside of examples

In “Limitations - SI Replication”, removed reference to OpenVMS

In “Shutting down the Source Server”, added the description of the -zerobacklog qualifier.

In “Examples”, used capitals for keywords outside of examples

In “Starting the Source Server”, removed references to Solaris, HP-UX, and OpenVMS; specified that pool limit is 4GiB - 8; specified that GT.M supports the use of IBM provided zlib library for AIX.

In “Stopping the Receiver Server and/or the Update Process”, added information about the -shutdown qualifier; alphabetized the qualifiers after -shutdown.

In “Introduction”, language cleanup - intermediate save

In “Setting up a secured TLS replication connection”, Changed Helen and Phil to Alice and Bob.

In “Creating a new Replication Instance File”, changed 4.5-000 to 5.4-000

In “Setting up a new replicating instance of an originating instance (A→B, P→Q, or A→P)”, changed on -> one\n

In “Starting the Source Server”, added the description of -TLSID, -[NO]PLAINTEXTFALLBACK, and -RENEGOTIATE_INTERVAL qualifiers.

In “Starting the Receiver Server ”, added the descriptions of -TLSID, -START, and -LOG qualifiers..

In “Procedures”, added a new topic called “Setting up a secured TLS replication connection”. This topic includes a downloadable example that creates two databases and sets up TLS replication between them.

Added a new section called “TLS/SSL Replication”.

In “Starting the Source Server”, added information about the use of the gtm_ipv4_only environment variable.

In “REORG ”, added a caution note about running successive reorgs.

In “Procedures”, added downloadable script examples for A→B and A→P replication scenarios.

In “Activating a Passive Source Server”, added information about the ACTIVE_REQUESTED mode.

In “Deactivating an Active Source Server”, added information about the PASSIVE_REQUESTED mode.

In “Starting the Source Server”, added information about the IPv6 support.

In “Instance Freeze”, added a note about the behavior when a process configured for instance freeze encounters an error with journaling.

Improved the description of -UPDATERESYNC.

In “Procedures”, added the following topics:

In “Displaying/Changing the attributes of Replication Instance File and Journal Pool”, corrected the description of the -offset and -size qualifiers of -EDITINSTANCE.

In “Commands and Qualifiers”, added the description of the -log_interval qualifier.

In “Starting the Receiver Server ”, added the description of the -initialize qualifier and updated the description of -updateresync for V6.0-000.

In “Starting the Source Server”, added the description of the -freeze qualifier.

Added a new section called “Instance Freeze”.