IBM Books

Replication Guide and Reference




Note

Before using this information and the product it supports, be sure to read
the general information under Appendix C, Notices.


First Edition (June 1999)

This edition applies to the following releases and to all subsequent releases and modifications until otherwise indicated in new editions:

This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties and any statements provided in this manual should not be interpreted as such.

Order publications through your IBM representative or the IBM branch office serving your locality or by calling 1-800-879-2755 in U.S. or 1-800-IBM-4YOU in Canada.

When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you.

© Copyright International Business Machines Corporation 1994, 1999. All rights reserved.
Note to U.S. Government Users -- Documentation related to restricted rights -- Use, duplication or disclosure is subject to restrictions set forth in GSA ADP Schedule contract with IBM Corp.

Table of Contents

  • About this book
  • Who should read this book
  • How this book is structured
  • Conventions
  • How to read syntax diagrams
  • Road map
  • How to send your comments

  • What's new
  • DB2 Satellite Edition
  • Database currency
  • Performance features
  • Integration with DB2

    • Introduction

  • Overview of data replication
  • DB2 data replication components
  • Control tables
  • Logical servers
  • Administration interfaces
  • Change-capture mechanisms
  • Apply program
  • How the replication components communicate
  • DB2 data replication concepts
  • Replication sources
  • Subscription sets and subscription-set members
  • Apply qualifier
  • Data manipulation
  • Target tables
  • Schedule for applying updates

  • Data replication configurations
  • Overview of replication configurations
  • Data distribution
  • Data consolidation
  • Update anywhere
  • Occasionally connected
  • Examples of replication configurations
  • Archiving audit information
  • Consolidating data from distributed databases
  • Distributing data to remote sites
  • Distributing IMS data to remote sites
  • Accessing data continuously
  • Replicating operational data to decision support systems
  • Using target tables as sources of updates (update anywhere)
  • Updating data on occasionally connected systems

  • Data replication scenario
  • Before you begin
  • About this scenario
  • Replication source
  • Replication target
  • Replication options
  • Setting up the scenario replication environment
  • Step 1: Customize control tables
  • Step 2: Define a replication source
  • Step 3: Define a subscription set and a subscription-set member
  • Step 4: Configure the Capture program
  • Step 5: Bind the Capture and Apply programs
  • Step 6: Create a password file
  • Step 7: Replicate the scenario data
  • Operating in a replication environment
  • Step 1: Update the source table
  • Step 2: Prune the control tables
  • Step 3: Stop the Capture and Apply programs

  • Data replication tasks
  • Planning your replication requirements
  • Setting up your replication environment
  • Setting up the system
  • Setting up the replication criteria
  • Performing the initial replication
  • Adding to your replication environment
  • Copying your replication environment
  • Operating in your replication environment

    • Administration

  • Planning for replication
  • Capacity planning
  • Storage planning
  • Database log and journal data
  • Active log file size for Capture for VSE and VM and current receiver size for Capture for AS/400
  • Target tables and control tables
  • Spill files
  • Network planning
  • Connectivity
  • Where to run the Apply program: push or pull configuration
  • Data blocking for large volumes of changes
  • Deciding what to replicate
  • Subsetting columns and rows
  • Replicating joins using views
  • Replicating before and after images
  • Renaming columns
  • Creating computed columns
  • Using stored procedures for before and after run-time processing
  • Replicating large objects
  • Limits on column names for capturing before-image data
  • Data restrictions
  • Auditing data usage
  • Staging data
  • CD tables
  • CCD tables
  • Planning for migration

  • Setting up your replication environment
  • Using the DB2 Control Center to set up replication
  • Configuring the Control Center for host RDBMSs
  • Setting replication preferences in the DB2 Tools Settings notebook
  • Using the DB2 DataJoiner Replication Administration tool to set up replication
  • Defining replication control tables
  • Creating replication control tables using DJRA
  • Customizing and running replication SQL files
  • Setting up security for replication
  • Authorization requirements for administration
  • Authorization requirements for running the Capture program
  • Authorization requirements for running the Apply program
  • Defining replication sources
  • Defining replication sources for update-anywhere replication
  • Detecting conflicts
  • Defining join replication sources
  • Enabling replication logical-partitioning-key support
  • Defining replication subscriptions
  • Defining replication subscriptions for update-anywhere replication
  • Choosing a target-table type
  • Defining the target-table structure: columns and rows
  • Defining a subscription set with a user-defined table
  • Defining SQL statements or stored procedures for the subscription set
  • Data-sharing considerations
  • Specifying a data-blocking value
  • Data currency requirements
  • Data consistency requirements
  • Loading target tables offline using DJRA
  • Copying your replication configuration to another system
  • Setting up the Capture program
  • Specifying tuning parameters for the Capture program
  • Restrictions when running the Capture program
  • Setting up the Apply program
  • Refreshing target tables with the ASNLOAD exit routine
  • Using the ASNDONE exit routine

  • Operating DB2 DataPropagator
  • Operating the Capture program
  • Before you start the Capture program
  • Starting or restarting the Capture program
  • Stopping the Capture program with an event
  • Operating the Apply program
  • Performing regular database maintenance
  • Monitoring the replication environment
  • Resolving gaps between source and target tables
  • Modifying your replication configuration
  • Viewing or changing existing replication sources
  • Removing replication sources
  • Activating and deactivating subscription sets
  • Cloning a subscription set to another server
  • Viewing or changing an existing subscription set
  • Removing subscription sets
  • Troubleshooting

    • Operations

  • Capture and Apply for OS/390
  • Setting up the Capture and Apply programs
  • Operating Capture for OS/390
  • Restrictions for running the Capture program
  • Starting Capture for OS/390
  • Scheduling Capture for OS/390
  • Stopping Capture for OS/390
  • Suspending Capture for OS/390
  • Resuming Capture for OS/390
  • Reinitializing Capture for OS/390
  • Pruning the change data and unit-of-work tables
  • Displaying captured log progress
  • Operating Apply for OS/390
  • Starting Apply for OS/390
  • Scheduling Apply for OS/390
  • Stopping Apply for OS/390
  • Rules for index types
  • Using the DB2 ODBC Catalog
  • Setting up the DB2 ODBC Catalog
  • DB2 ODBC Catalog tables

  • Capture and Apply for AS/400
  • Setting up the Capture and Apply programs
  • Installing DPROPR/400
  • Verifying and customizing your DPROPR/400 installation
  • Specifying tuning parameters for Capture for AS/400
  • Authorization requirements for running the Capture and Apply programs
  • Granting authority
  • Revoking authority
  • Restrictions for running the Capture program
  • Keeping the Capture program running successfully
  • The Journal
  • Remote journal function
  • Creating journals for source tables
  • Managing journals and journal receivers
  • Determining the progress of the Capture program
  • Defining replication sources and subscription sets
  • Using a relative record number (RRN) as a primary key
  • Operating Capture for AS/400
  • Starting Capture for AS/400
  • Scheduling Capture for AS/400
  • Stopping Capture for AS/400
  • Reinitializing Capture for AS/400
  • Pruning the change data and unit-of-work tables
  • Warm and cold starts
  • How the Capture program processes journal entry types
  • Operating Apply for AS/400
  • Creating DPROPR/400 packages to use with remote systems
  • Before you start the Apply program
  • Starting Apply for AS/400
  • Scheduling Apply for AS/400
  • Stopping Apply for AS/400
  • Additional Apply program operations
  • Using the ASNDONE exit routine for AS/400
  • Refreshing target tables with the ASNLOAD exit routine for AS/400

  • Capture and Apply for UNIX platforms
  • User ID requirements for running the Capture and Apply programs
  • Setting up the Capture and Apply programs
  • Configuring the Capture program for UNIX platforms
  • Configuring the Apply program for UNIX platforms
  • Other configuration considerations for UNIX-based components
  • Providing end-user authentication at the source server
  • Operating Capture for UNIX platforms
  • Restrictions for running the Capture program
  • Starting Capture for UNIX platforms
  • Scheduling Capture for UNIX platforms
  • Stopping Capture for UNIX platforms
  • Suspending Capture for UNIX platforms
  • Resuming Capture for UNIX platforms
  • Reinitializing Capture for UNIX platforms
  • Pruning the change data and unit-of-work tables
  • Displaying captured log progress
  • Operating Apply for UNIX platforms
  • Before you start the Apply program
  • Starting Apply for UNIX platforms
  • Scheduling Apply for UNIX platforms
  • Stopping Apply for UNIX platforms

  • Capture and Apply for Windows and OS/2
  • User ID requirements for running the Capture and Apply programs
  • Setting up the Capture and Apply programs
  • Configuring Capture for Windows and OS/2
  • Configuring Apply for Windows and OS/2
  • Providing end-user authentication at the source server
  • Setting up the NT Service Control Manager
  • Operating Capture for Windows and Capture for OS/2
  • Restrictions for running the Capture program
  • Starting Capture for Windows and OS/2
  • Scheduling Capture for Windows and OS/2
  • Stopping Capture for Windows and OS/2
  • Suspending Capture for Windows and OS/2
  • Resuming Capture for Windows and OS/2
  • Reinitializing Capture for Windows and OS/2
  • Pruning the change data and unit-of-work tables
  • Displaying captured log progress
  • Operating Apply for Windows and OS/2
  • Before you start the Apply program
  • Starting Apply for Windows and OS/2
  • Scheduling Apply for Windows and OS/2
  • Stopping Apply for Windows and OS/2

  • Capture for VM and Capture for VSE
  • Setting up the Capture program
  • Operating Capture for VM and Capture for VSE
  • Restrictions for running the Capture program
  • Starting Capture for VM and VSE
  • Stopping Capture for VM and VSE
  • Suspending Capture for VM and VSE
  • Resuming Capture for VM and VSE
  • Reinitializing Capture for VM and VSE
  • Pruning the change data and unit-of-work tables
  • Displaying captured log progress

    • Occasionally connected environments

  • Satellite replication
  • Restrictions for satellites
  • Setting up replication for the satellite environment
  • Creating the replication environment
  • Setting up the satellite environment
  • Starting replication on a satellite

  • Mobile replication using DB2 DataPropagator for Microsoft Jet
  • What is DataPropagator for Microsoft Jet?
  • The advantages of mobile replication using DataPropagator for Microsoft Jet
  • Data integrity considerations
  • Terminology for DataPropagator for Microsoft Jet replication
  • Setting up DataPropagator for Microsoft Jet replication
  • Preparing the replication source and control servers
  • Preparing the client environment
  • Operating DataPropagator for Microsoft Jet
  • Starting the Capture program at the source server
  • Starting DataPropagator for Microsoft Jet
  • Stopping DataPropagator for Microsoft Jet
  • Troubleshooting DataPropagator for Microsoft Jet
  • Returning control to users with the ASNJDONE exit routine
  • Parameters
  • Error recovery
  • DataPropagator for Microsoft Jet control tables
  • Control server tables
  • Target server tables

  • Mobile replication for DB2
  • An overview of mobile replication
  • How mobile replication works
  • Mobile replication restrictions
  • Planning mobile replication
  • Software and hardware requirements
  • Communication program requirements
  • Setting up the mobile client
  • Configuring the mobile client for Windows NT and Windows 95
  • Configuring the mobile client for OS/2
  • Defining the control server for your mobile client
  • Mobile replication processing cycle
  • Starting the mobile-replication-enabler using the ASNCOPY command
  • Starting the mobile-replication-enabler using the mobile interface
  • Selecting subscription sets
  • Selecting an Apply qualifier

    • The DB2 DataJoiner Replication Administration tool

  • DJRA overview
  • DJRA and DB2 DataJoiner
  • Capture triggers for non-IBM sources
  • How the Capture triggers capture the data changes
  • Capture Triggers and pre-existing triggers
  • Improving Apply performance for Sybase or Microsoft SQL Server on AIX

  • Setting up the DB2 DataJoiner environment for replication
  • Seting up DataJoiner for AIX
  • Installing DataJoiner
  • Setting up an instance
  • Configuring database connections
  • Connecting clients to DataJoiner
  • What to do next
  • Setting up DataJoiner for Windows NT
  • Installing DataJoiner
  • Setting up an instance
  • Configuring database connections
  • Connecting clients to DataJoiner
  • What to do next

  • Installing DJRA and connecting all databases
  • Installing DJRA
  • Configuring access from DJRA to DataJoiner and DB2
  • Setting DB2CODEPAGE for DataJoiner for AIX access
  • Setting administrative preferences
  • Binding to source, target, and control servers
  • Binding the Capture and Apply programs in DB2 systems

  • Starting and using DJRA
  • Starting DJRA
  • General steps for setting up replication
  • Editing DJRA logic
  • Editing DJRA-generated SQL
  • Running DJRA-generated SQL
  • Running the Capture and Apply programs

  • DB2 DataJoiner with DJRA: data typing
  • DB2-to-Oracle replication
  • DB2-to-Informix replication
  • DB2 to Microsoft SQL Server, Sybase, or Sybase SQL Anywhere replication
  • DB2 to Microsoft Jet replication

    • Reference information

  • Table structures
  • Tables at a glance
  • List of tables used at the source server
  • List of tables used at the control server
  • List of tables used at the target server
  • Tables used at the source server
  • Register table
  • Register extension table for AS/400
  • Pruning control table
  • Tuning parameters table
  • Capture enqueue table (VM and VSE specific)
  • Warm start table
  • Critical section table
  • Prune lock table
  • Trace table
  • Apply-qualifier-cross-reference table (AS/400 specific)
  • Register synchronization table
  • Unit-of-work table
  • Change data table
  • Tables used at the control server
  • Subscription set table
  • Subscription-targets-member table
  • Subscription columns table
  • Subscription statements table
  • Row-replica-target-list table (Microsoft Jet specific)
  • Subscription-schema-changes table (Microsoft Jet specific)
  • Subscription events table
  • Apply trail table
  • Apply job table (AS/400 specific)
  • Tables used at the target server
  • User copy table
  • Point-in-time table
  • Consistent-change-data table
  • Replica table
  • Base aggregate table
  • Change aggregate table
  • Row-replica table (Microsoft Jet specific)
  • Conflict table (Microsoft Jet specific)
  • Error information table (Microsoft Jet specific)
  • Error messages table (Microsoft Jet specific)
  • Error-side-information table (Microsoft Jet specific)
  • Key string table (Microsoft Jet specific)
  • Synchronization generations table (Microsoft Jet specific)

  • Problem determination facilities
  • Replication diagnosis resources
  • Errors encountered during replication administration
  • Errors encountered while running the Capture and Apply programs
  • Apply program problem determination facilities
  • The Apply trail table
  • Apply program trace file
  • The Apply program log file
  • Capture program problem determination facilities
  • Capture program trace table
  • Capture program trace file
  • Capture program log
  • Capture for OS/390 problem determination facilities
  • Capture for VM and VSE problem determination facilities
  • Capture for AS/400 problem determination facilities
  • Problem determination scenario
  • Problem source identification questions

  • Capture and Apply messages
  • Capture program messages
  • Apply program messages
  • Capture for AS/400 messages

    • Appendixes

  • Appendix A. How the DB2 library is structured
  • Completing tasks with SmartGuides
  • Accessing online help
  • DB2 information - hardcopy and online
  • Viewing online information
  • Accessing information with the Information Center
  • Setting up a document server
  • Searching online information
  • Printing the PostScript books
  • Ordering the printed books

  • Appendix B. Education and services for DB2 data replication
  • Services
  • Education

  • Appendix C. Notices
  • Programming interface information
  • Trademarks
  • Trademarks of other companies

  • Glossary

  • Index

  • Contacting IBM

    • [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

    [ DB2 List of Books | Search the DB2 Books ]