HP 3000 Manuals HP 3000 Manuals
Table of Contents
ALLBASE/Replicate User's Guide
ALLBASE/Replicate User's Guide : COPYRIGHT NOTICE
Ch 1. Introduction to ALLBASE/Replicate
Overview of ALLBASE/Replicate
Multiple ALLBASE/Replicate Configurations
Reasons for Using ALLBASE/Replicate
Components of ALLBASE/Replicate
Overview of Resynchronization
Hard Resynchronization
Soft Resynchronization
Third Party Resynchronization Applications
Ch 2. Basic Concepts of ALLBASE/Replicate
Partitions
Direct and Indirect Updates in Partition Design
Partition Types
NONE Partition
DEFAULT Partition
User-Defined Partitions
COMMENT Partition
Audit Log Records
Four Typical Partition Configurations
Configuration 1 - Entire DBEnvironment to a Dedicated Slave
Configuration 2 - Subset of a DBEnvironment to a Dedicated Slave
Configuration 3 - Multiple Master DBEnvironments to One Slave
Configuration 4 - Two-Way Replication
Configuration Design Issues
Audit Elements
CHECKPOINT
COMMENT
DATA
Synchronization Checkpoint Records (SCR)
SCR Array
Detailed Structure of SCR
How SCRs Maintain Synchronization
State 1 - Immediately after Hard Resynchronization
State 2 - Start of Soft Resynchronization
State 3 - Slave Even with Master
State 4 - Slave Ahead of Master
Audit Logging
Audit Log Records
Audit Log Record Structure for Non-DDL Statements
Audit Log Record Structure for DDL Statements and Log Comments
Using Audit Log Records
Viewing Audit Log Records
Setting Up the Master Enable Audit Logging
Setting Up the Slave to Use Audit Log Records
ALLBASE/SQL Statements that Support ALLBASE/Replicate
Brief Description of ALLBASE/Replicate Statements
Type of Resynchronization Used for a Specific Failure Mode
Short, Planned Interruptions of the Slave
Extended, Planned Interruptions of the Slave
Short, Unplanned Interruptions of the Slave
Extended, Unplanned Interruptions of the Slave
Failure of the Slave to Keep Up with the Master
Short, Planned Interruptions of the Master
Extended, Planned Interruptions of the Master
Short, Unplanned Interruptions of the Master
Extended, Unplanned Interruptions of the Master
Protecting Transactions in the Master Log Files from Being Overwritten
Error Messages during Soft Resynchronization
Using a Wrapper DBEnvironment
Recovering Orphaned Log Files
Selecting Usable Log Files
Creating a Dummy DBEnvironment
Using WRAPDBE to Rescue Orphaned Log Files
Replicating the Remaining Log Files
Database Design Issues
Design Issues for User Written Applications
Using the START DBE NEW Statement
Migrating ALLBASE/Replicate DBEnvironments
System Catalogs
SYSTEM.TABLE
SYSTEM.PARTITION
Ch 3. Soft Resynchronization
Setting Up Soft Resynchronization
Step 1 \ - Creating the Master DBEnvironment
Step 2 \ - Loading the Master
Step 3 \ - Starting the Master DBEnvironment
Enabling Audit Logging on the Master
Step 4 \ - Adding Log Files to the Master
Step 5 \ - Verifying Master Startup Parameters
Step 6 \ - Backing up the Master DBEnvironment
Step 7 \ - Making Preparations on the Master for Slave Creation
Step 8 \ - Creating the Slave DBEnvironment
Step 9 \ - Loading the Slave
Step 10 - Starting the Slave DBEnvironment
Enabling Audit Logging on the Slave
Step 11 - Adding Log Files to the Slave
Step 12 - Verifying Slave Startup Parameters
Step 13 - Backing up the Slave DBEnvironment
Step 14 - Setting Soft Resynchronization Options on the Slave
Step 15 - Starting the Soft Resynchronization Process on the Slave
Starting the Replicate Application on the Slave
Starting Slave Replication with DDL Partitions
Step 16 - Obtaining the Slave Nodename
Step 17 - Setting Soft Resynchronization Options on the Master
Step 18 - Starting the Soft Resynchronization Process on the Master
Establishing a Network Connection
Step 19 - Testing the Process on the Master
Step 20 - Testing the Process on the Slave
Step 21 - Removing Test Transactions from the Master
Step 22 - Verifying Removal of Test Transactions from the Slave
Step 23 - Terminating the Soft Resynchronization Process
Error Messages in Batch Mode
Effects of Operating System Priority
Using SQLAudit to Check if Slave is Keeping Up
Ch 4. Hard Resynchronization
ISQL UNLOAD/LOAD
Unloading Tables Using ISQL UNLOAD
Loading Tables Using ISQL LOAD
Starting the Application on the Slave
Starting the Application on the Master
Testing the Applications
SQLUtil Static STORE and RESTORE
Storing the Entire Master DBEnvironment Using SQLUtil STORE
Restoring to the Slave Using SQLUtil RESTORE
Starting the Application on the Slave
Starting the Application on the Master
Testing the Applications
SQLUtil STOREONLINE and Associated Restore Commands
Storing the Entire Master DBEnvironment Using STOREONLINE
Restoring to the Slave Using Dynamic Restore Commands
Starting the Application on the Slave
Starting the Application on the Master
Backing up the Slave DBEnvironment and Log Files
Testing the Applications
Ch 5. Hints and Suggestions
Introduction
Entire DBEnvironment to Dedicated Slave
Setting up Soft Resynchronization
Step 1 \ - Creating the Master DBEnvironment
Step 2 \ - Loading the Master
Step 3 \ - Starting the Master DBEnvironment
Step 4 \ - Adding Log Files to the Master
Step 5 \ - Verifying Master Startup Parameters
Step 6 \ - Backing up the Master DBEnvironment
Step 7 \ - Making Preparations on the Master for Slave Creation
Step 8 \ - Creating the Slave DBEnvironment
Step 9 \ - Loading the Slave
Step 10 - Starting the Slave DBEnvironment
Step 11 - Adding Log Files to the Slave
Step 12 - Verifying Slave Startup Parameters
Step 13 - Backing up the Slave DBEnvironment
Step 14 - Setting Soft Resynchronization Options on the Slave
Step 15 - Starting the Soft Resynchronization Process on the Slave
Step 16 - Obtaining the Slave Node Name for Starting the Master
Step 17 - Setting Soft Resynchronization Options on the Master
Step 18 - Starting the Soft Resynchronization Process on the Master
Step 19 - Testing the Soft Resynchronization Applications on the Master
Step 20 - Testing the Soft Resynchronization Applications on the Slave
Step 21 - Removing Test Transactions from the Master
Step 22 - Verifying Removal of Test Transactions from the Slave
Step 23 - Terminating the Soft Resynchronization Process
Recovering from Soft Resynchronization Interruptions
Using Soft Resynchronization to Recover the Slave
Using Soft Resynchronization to Recover the Master
Using Hard Resynchronization to Recover in a Static Environment
Using Hard Resynchronization to Recover in a Dynamic Environment
Switching Master and Slave Roles
Other Configurations
Subset of a DBEnvironment to a Dedicated Slave
Step 1 \ - Creating the Master DBEnvironment
Step 8 \ - Creating the Slave DBEnvironment
Step 10 - Starting the Slave DBEnvironment
Step 15 - Starting the Soft Resynchronization Process on the Slave
Multiple Masters to One Slave
Step 1 \ - Creating the Master DBEnvironment
Manually Replicated DDL Activities - Timing Issues
Step 3 \ - Starting the Master DBEnvironments
Step 10 - Starting the Slave DBEnvironment
Step 15 - Starting the Soft Resynchronization Process on the Slave
Step 18 - Starting the Soft Resynchronization Process on the Master
Using Soft Resynchronization to Recover the Master
Using Hard Resynchronization to Recover the Master
UNLOAD/LOAD
Two-Way Replication
Creating the DBEnvironments
Starting the Soft Resynchronization Process
Using Soft Resynchronization to Recover Tables Acting in the Master Role
Conversion of an Existing DBEnvironment for ALLBASE/Replicate
Step 1 \ - Creating the Master DBEnvironment
Step 3 \ - Starting the Master DBEnvironment
Step 8 \ - Creating Slave DBEnvironment
Step 10 - Starting the Slave DBEnvironment
Ch 6. ALLBASE/Replicate Statement Syntax Reference
ALLBASE/Replicate Statements
ALTER TABLE
CREATE PARTITION
CREATE TABLE
DISABLE AUDIT LOGGING
DROP PARTITION
ENABLE AUDIT LOGGING
LOG COMMENT
START DBE NEW
START DBE NEWLOG
Ap A. ALLBASE/Replicate Messages
GLOSSARY
INDEX
Index