Home | Previous Page | Next Page

Contents

In This Introduction

About This Manual

Software Dependencies

Assumptions About Your Locale

Demonstration Databases

New Features in Dynamic Server, Version 10.0

Functionality Enhancements

Command-Line Changes

Configuration Parameter Changes

Documentation Conventions

Typographical Conventions

Feature, Product, and Platform Markup

Syntax Diagrams

Example Code Conventions

Additional Documentation

IBM Informix Information Center

Installation Guides

Informix Error Messages

IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set

Compliance with Industry Standards

IBM Welcomes Your Comments

Introducing Enterprise Replication

About IBM Informix Enterprise Replication

In This Chapter

IBM Informix Enterprise Replication

Asynchronous Data Replication

Log-Based Data Capture

High Performance

High Availability

Consistent Information Delivery

Repair and Initial Data Synchronization

Flexible Architecture

Centralized Administration

Ease of Implementation

Network Encryption

How Enterprise Replication Replicates Data

Capturing Transactions

Evaluating Data for Replication

Distributing Data

Applying Replicated Data

Overview of Enterprise Replication Administration

In This Chapter

Overview of Enterprise Replication Administration

Enterprise Replication Server Administrator

Enterprise Replication Terminology

Enterprise Replication Server

Master Replicate

Shadow Replicate

Enterprise Replication Considerations

Operational Considerations

Backup and Restore Considerations

Database and Table Design Considerations

Transaction Processing Considerations

Replication Environment Considerations

Enterprise Replication Data Types

Setting Up and Managing Enterprise Replication

Selecting the Enterprise Replication System and Network Topology

In This Chapter

Selecting the Enterprise Replication System

Primary-Target Replication System

Update-Anywhere Replication System

Conflict Resolution

Choosing a Replication Network Topology

Fully Connected Topology

Hierarchical Replication Topologies

Preparing the Replication Environment

In This Chapter

Preparing the Network Environment

Setting Up the Hosts File

Setting Up the Services File

Setting Up the Trusted Environment

Verifying SQLHOSTS

Testing the Network Environment

Preparing the Disk

Planning for Disk Space Requirements

Setting Up Send and Receive Queue Spool Areas

Setting Up the Grouper Paging File

Creating ATS and RIS Directories

Preparing the Database Server Environment

Setting Environment Variables

Setting Configuration Parameters

Preparing Data for Replication

Preparing Consistent Data

Blocking Replication

Preparing to Replicate User-Defined Types

Preparing to Replicate User-Defined Routines

Preparing Tables for Conflict Resolution

Preparing Logging Databases

Loading and Unloading Data

High-Performance Loader

onunload and onload Utilities

dbexport and dbimport Utilities

UNLOAD and LOAD Statements

Data Preparation Example

Using the cdr start replicate Command

Using LOAD, UNLOAD, and BEGIN WORK WITHOUT REPLICATION

Using High-Availability Data Replication with Enterprise Replication

In This Chapter

High-Availability Replication System

Using HDR in a Hierarchical Tree Topology

Using HDR in a Forest of Trees Topology

Preparing HDR Database Servers

HDR Requirements

Setting Up Database Server Groups

Preparing to Replicate UDTs, UDRs, and DataBlade Modules

Loading and Unloading Data

Managing Enterprise Replication with High-Availability Data Replication

Row Data Sbspace Logging

Performance Considerations

Defining Replication Servers, Replicates, Participants, and Replicate Sets

In This Chapter

Initializing Database Servers

Defining Replication Servers

Customizing the Replication Server Definition

Defining Replicates

Defining Participants

Defining Master Replicates

Defining Shadow Replicates

Specifying Conflict Resolution Rules and Scope

Specifying Replication Frequency

Setting Up Error Logging

Replicating Only Changed Columns

Using the IEEE Floating Point or Canonical Format

Enabling Triggers

Defining Replicate Sets

Exclusive Replicate Sets

Non-Exclusive Replicate Sets

Customizing the Replicate Set Definition

Initially Synchronizing Data Among Database Servers

Using Templates to Set Up Replication

Defining Templates

Realizing Templates

Managing Replication Servers and Replicates

In This Chapter

Managing Replication Servers

Modifying Replication Servers

Viewing Replication Server Attributes

Connecting to Another Replication Server

Stopping Replication on a Server

Restarting Replication on a Stopped Server

Suspending Replication for a Server

Resuming a Suspended Replication Server

Deleting a Replication Server

Managing Replicates

Modifying Replicates

Viewing Replicate Properties

Starting a Replicate

Stopping a Replicate

Suspending a Replicate

Resuming a Suspended Replicate

Deleting a Replicate

Managing Replicate Sets

Modifying Replicate Sets

Viewing Replicate Sets

Starting a Replicate Set

Stopping a Replicate Set

Suspending a Replicate Set

Resuming a Replicate Set

Deleting a Replicate Set

Managing Templates

Viewing Template Definitions

Deleting Templates

Managing Replication Server Network Connections

Viewing Network Connection Status

Dropping the Network Connection

Reestablishing the Network Connection

4 4

Resynchronizing Data Among Replication Servers

4 4

Performing Direct Synchronization

4 4

Checking Consistency and Repairing Inconsistent Rows

4 4

Performing a Repair Job

4 4

Repairing Failed Transactions with ATS and RIS Files

4 4

Resynchronizing Data Manually

Performing Alter Operations on Replicated Tables

Adding a Replicated Column

Dropping a Replicated Column

Modifying a Replicated Column

Attaching a New Fragment to a Replicated Table

Remastering a Replicate

Monitoring and Troubleshooting Enterprise Replication

In This Chapter

Aborted Transaction Spooling Files

Preparing to Use ATS

About ATS Filenames

About ATS File Information

BYTE and TEXT Information in ATS Files

Changed Column Information in ATS Files

BLOB and CLOB Information in ATS Files

UDT Information in ATS Files

Suppressing Datasync Errors and Warnings in ATS Files

Row Information Spooling Files

Preparing to Use RIS

About RIS Filenames

BYTE and TEXT Information in RIS Files

Changed Column Information in RIS Files

BLOB and CLOB Information in RIS Files

UDT Information in RIS Files

Suppressing Datasync Errors and Warnings in RIS Files

Preventing Memory Queues from Overflowing

Preventing DDRBLOCK Mode

Monitoring Disk Usage for Send and Receive Queue Spool

Increasing the Sizes of Storage Spaces

Recovering when Storage Spaces Fill

Solving Common Configuration Problems

Troubleshooting Tips for Alter Operations

Enterprise Replication Event Alarms

Appendix A. Command-Line Utility Reference

Command Summary

cdr change replicate

cdr change replicateset

4 4

cdr check replicate

4 4

cdr check replicateset

cdr connect server

cdr define repair

cdr define replicate

cdr define replicateset

cdr define server

cdr define template

cdr delete repair

cdr delete replicate

cdr delete replicateset

cdr delete server

cdr delete template

cdr disconnect server

cdr list repair

cdr list replicate

Displaying Information About Replicates

cdr list replicateset

cdr list server

Listing All Enterprise Replication Servers

Displaying Details about a Single Replication Server

cdr list template

Generated Replicate and Replicate Set Names

cdr modify replicate

cdr modify replicateset

cdr modify server

cdr realize template

cdr resume replicate

cdr resume replicateset

cdr resume server

cdr start repair

cdr start replicate

cdr start replicateset

3 3

3 3

cdr stop repair

cdr stop replicate

cdr stop replicateset

cdr suspend replicate

cdr suspend replicateset

cdr suspend server

cdr swap shadow

4 4

cdr sync replicate

4 4

cdr sync replicateset

Interpreting the Command-Line Utility Syntax

Command Abbreviations

Option Abbreviations

Long Command-Line Examples

Long Identifiers

Frequency Options

Appendix B. Configuration Parameter and Environment Variable Reference

CDR_DBSPACE Configuration Parameter

CDR_DSLOCKWAIT Configuration Parameter

CDR_ENV Configuration Parameter

CDR_EVALTHREADS Configuration Parameter

CDR_MAX_DYNAMIC_LOGS Configuration Parameter

CDR_NIFCOMPRESS Configuration Parameter

CDR_QDATA_SBSPACE Configuration Parameter

CDR_QHDR_DBSPACE Configuration Parameter

CDR_QUEUEMEM Configuration Parameter

CDR_SERIAL Configuration Parameter

CDR_SUPPRESS_ATSRISWARN Configuration Parameter

ENCRYPT_CDR Configuration Parameter

ENCRYPT_CIPHERS Configuration Parameter

ENCRYPT_MAC Configuration Parameter

ENCRYPT_MACFILE Configuration Parameter

ENCRYPT_SWITCH Configuration Parameter

Environment Variables

CDR_LOGDELTA Environment Variable

CDR_PERFLOG Environment Variable

CDR_RMSCALEFACT Environment Variable

CDR_ROUTER Environment Variable

CDRSITES_731 Environment Variable

CDRSITES_92X Environment Variable

Appendix C. onstat Command Reference

onstat -g Command Summary

4 4

4 4

4 4

Appendix D. SMI Table Reference

SMI Table Summary

SMI Tables for Enterprise Replication

syscdrrecv_stats

Enterprise Replication Queues

Columns of the Transaction Tables

Columns of the Buffer Tables

Appendix E. Replication Examples

Replication Example Environment

Primary-Target Example

Preparing for a Primary-Target Replication

Cause a Replication

To Not Cause a Replication

Update-Anywhere Example

Preparing for an Update-Anywhere Replication

Cause a Replication

Hierarchy Example

Preparing for a Hierarchy Example

Defining a Hierarchy

Appendix F. SQLHOSTS Registry Key (Windows)

The Location of the SQLHOSTS Registry Key

Local SQLHOSTS Registry Key

Shared SQLHOSTS Registry Key

Preparing the SQLHOSTS Connectivity Information

Setting up the SQLHOSTS Registry with ISA

Setting up the SQLHOSTS Registry Key with regedt32

Setting Up the Database Server Group Registry Key

Setting up the Registry Keys on All Computers

Verifying the services Files on All Computers

Appendix G. Datasync Warning and Error Messages

Appendix H. Accessibility

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]