Empress Software Replication User's Guide
Empress v8.62
January 2003

ｩ 1983, 2003 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.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.7 Scenario F: Replication Table Switch
3.7.1 Description
3.7.2 Operations for Creating 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.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.4 Synchronization Algorithms

CHAPTER 6: Empress サーバー

6.1 はじめに
6.2 Empress サーバー管理ユーティリティ
6.2.1 Empress サーバーのスタート
6.2.2 クライアント接続のクローズ
6.2.3 Empress サーバーの情報取得
6.2.4 サービスサーバー数のリセット
6.2.5 Empressサーバーの停止
6.2.6 Empressサーバーのリフレッシュ
6.2.7 Empress サーバーの中断
6.2.8 Empress サーバー管理者のパスワードの変更
6.3 Empress サーバーおよびクライアントのコンフィグレーション
6.3.1 ネットワークコンフィグレーション
6.3.2 ユーザー認証
6.3.3 コンフィグレーションファイル群へのパス
6.4 Empress サーバーログ解析ユーティリティ
6.4.1 Empress サーバーログ解析ユーティリティempsvlogstatの使用法
6.4.2 例
6.5 パスワードファイルユーティリティ

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.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.6 Sample Empress Server status information output
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.3 Configuring and Starting Replication Master Server
D.4 Configuring Master Table to publish Data
D.5 Create Replicate Table
D.6 Synchronize Replication Replicate Table
D.7 View the Replication Table and Synchronization Status
D.8 Testing
D.9 Stop the Replication Master Server