Empress Software Replication User's Guide
Empress v8.62
May 2006

© 1983, 2006 Empress Software Inc.

All rights reserved. Reproduction of this document in whole or part, by electronic or any other means, is prohibited without written consent from Empress Software Inc.

RESTRICTED RIGHTS LEGEND

Use, duplication, or disclosure by the Government is subject to restrictions as set forth in
subparagraph (c) (1) (ii) of the Rights in Technical Data and Computer Software clause at 52.227-7013.

01/00

This manual is the user's guide for Empress Replication. It introduces Empress Replication, its usage and concepts.

Table of Contents

CHAPTER 1: Outline

CHAPTER 2: Introduction

2.1 Introduction
2.2 What is Empress Replication
2.3 Why to use Empress Replication

CHAPTER 3: Empress Replication Scenarios

3.1 Introduction
3.1.1 The Company XYZ
3.1.2 Format of each Scenario
3.2 Scenario A: Basic Replication
3.2.1 Description
3.2.2 Operations for Creating the Scenario
3.2.3 Other possible Operations in the Scenario
3.3 Scenario B: Cascaded Replication
3.3.1 Description
3.3.2 Operations for Creating the Scenario
3.4 Scenario C: RMT Switch (Selecting an Alternative Source of Data)
3.4.1 Description
3.4.2 Operations for Creating the Scenario
3.5 Scenario D: Changing Order of RMT
3.5.1 Description
3.5.2 Operations for Creating the Scenario
3.6 Scenario E: Disabling RMT
3.6.1 Description
3.6.2 Operations for Creating the Scenario
3.6.3 Other Possible Operations in the Scenario
3.7 Scenario F: Replication Table Switch
3.7.1 Description
3.7.2 Operations for Creating the Scenario
3.7.3 Other Possible Operations in the Scenario
3.8 Scenario G: Subset Replication
3.8.1 Description
3.8.2 Operations for Creating the Scenario

CHAPTER 4: Empress Replication Details

4.1 Introduction
4.2 Replication Tables
4.2.1 Master Table
4.2.2 Replicate Table
4.2.3 Original Master Table
4.2.4 Replication Table Switch
4.3 Replication Relation
4.3.1 Replication World
4.3.2 RMT-Side and RRT-Side
4.3.3 Replication Replicate Entry
4.3.4 Replication Master Entry
4.3.5 Replication Master Order
4.3.6 RMT Switch
4.4 Operations on Replication Tables
4.4.1 Defining a Master Table
4.4.2 Defining a Replicate Table
4.4.2.1 Creating a Replicate Table
4.4.2.2 Switching a Master Table to a Replicate Table
4.4.3 Undefining a Master Table or a Replicate Table
4.4.4 Dropping a Master Table or a Replicate Table
4.5 Operations on Replication Relation
4.5.1 Creating Replication Replicate
4.5.2 Dropping Replication Replicate
4.5.3 Creating Replication Master
4.5.4 Dropping Replication Master
4.5.5 Changing Replication Master Order
4.5.6. Enabling and Disabling Replication Masters
4.6 Overriding Regular Empress Replication Controls
4.7 Viewing Replication tables and Synchronization Status
4.8 Subset Replication
4.9 System Attributes and System tables related to Replication
4.9.1 New System Attributes
4.9.2 New System Tables for Replication Tables, Replication Relations and Synchronization Status

CHAPTER 5: Synchronization in Empress Replication

5.1 Introduction
5.2 Replication Master Server and Replication Synchronization Client
5.2.1 Connection between a Master-Side and a Replicate-Side
5.2.2 Setting up a Replication Master Server
5.2.3 Setting up a Synchronization Client
5.3 Synchronization Utility
5.4 Synchronization
5.4.1 Table Timestamp and Recovery Timestamp
5.4.2 Choosing Replication Master
5.4.3 Synchronization Requirements
5.4.3.1 Algorithm 1: Forward algorithm
5.4.3.2 Algorithm 2: Backward algorithm
5.4.3.3 Algorithm 3: Recovery algorithm
5.4.4 Synchronization Algorithms

CHAPTER 6: Empress Servers

6.1 Introduction
6.2 Empress Server Administration Utility
6.2.1 Starting an Empress Server
6.2.2 Closing a Client Connection
6.2.3 Getting information on an Empress Server
6.2.4 Resetting Number of Service Servers
6.2.5 Stopping an Empress Server
6.2.6 Refreshing the Empress Server
6.2.7 Interrupting the Empress Server
6.2.8 Changing the Login Password of the User
6.3 Configuring Empress Server and its Clients
6.3.1 Network Configuration
6.3.1.1 Network Type Configuration File
6.3.1.2 Network Server Configuration File
6.3.1.3 Common Attributes in Network Configuration Files
6.3.2 User Authorization
6.3.2.1 User Authorization Configuration File
6.3.3 Path for Configuration Files
6.4 Empress Server Log Analyzer Utility
6.4.1 Empress Server Log Analyzer Utility empsvlogstat Usage
6.4.2 Examples
6.4.2.1 Display Unique User Information
6.4.2.2 Display Number of Servers Started Up
6.4.2.3 Display Number of Idle Servers
6.4.2.4 Display Number of Servers in Use
6.4.2.5 Display Number of Connections
6.4.2.6 Display Connection Duration
6.4.2.7 Display Number of Rejected Connections Due to Insufficient Licenses
6.5 Password File Utility
6.5.1 Creating a password file
6.5.2 Adding Users
6.5.3 Deleting Users
6.5.4 Listing the User Information
6.5.5 Updating User Information
6.5.6 Options of the commands

CHAPTER 7: Manual Pages

Appendix A. Glossary

Appendix B. Scenario Scripts

Appendix C. References

C.1 Introduction
C.2 Empress Replication SQL Commands
C.2.1 CREATE REPLICATION MASTER
C.2.2 DROP REPLICATION MASTER
C.2.3 CREATE REPLICATION REPLICATE
C.2.4 DROP REPLICATION REPLICATE
C.2.5 CREATE REPLICATE TABLE
C.2.6 DROP TABLE
C.2.7 Change Replication Master Order
C.2.8 Change Table Type
C.2.9 Enable/Disable Replication Master Table
C.2.10 Enable/Disable All Replication Masters
C.3 Empress Server Environment Variables
C.3.1 Network Configuration Files
C.3.1.1 Default contents for network server configuration file
C.3.1.2 Default contents for network type configuration file
C.3.2 User Authorization Configuration File
C.3.3 Configuration Files Path: MSCONFIGFILEPATH
C.4 System Tables Related to Replication
C.4.1 Table sys_rep_tables
C.4.2 Table sys_rep_masters
C.4.3 Table sys_rep_replicates
C.5 Replication Utilities
C.5.1 Empress Server Administration Utility empsvadm
C.5.2 Replication Synchronization Utlity emprepsync
C.5.3 Empress Server Log Analyzer empsvlogstat
C.5.4 Empress Server Log File
C.5.5 Server Start Configuration File
C.5.5.1 Replication Master Server Start Configuration File
C.5.5.2 Empress Connectivity (ODBC) Server Configuration File
C.5.6 Sample Empress Server status information output
C.5.6.1 Sample Replication Master Server status information
C.5.6.2 Sample Connectivity (ODBC) Server status information
C.6 Restrictions on DDL and DML commands for Replication
C.7 Examples of Viewing Replication Tables and Synchronization Status
C.7.1 Example 1: Viewing information of a Master Table
C.7.2 Example 2: Viewing information of a Replicate Table

Appendix D. Quick Start Tutorial

D.1 Introduction
D.2 Defining Master Table
D.2.1 Create a Database
D.2.2 Create a Table in the Database
D.2.3 Defining Master table
D.2.4 Insert data into Master Table
D.3 Configuring and Starting Replication Master Server
D.3.1 Configure a Replication Master Server
D.3.2 Start the Replication Server Process
D.4 Configuring Master Table to publish Data
D.5 Create Replicate Table
D.5.1 Create a Database
D.5.2 Create Replicate Table
D.6 Synchronize Replication Replicate Table
D.7 View the Replication Table and Synchronization Status
D.7.1 View Synchronization Status
D.7.2 Check the contents of Replication Table
D.8 Testing
D.9 Stop the Replication Master Server