IBM Books

Replication Guide and Reference

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, 1997. 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

  • Welcome to Replication
  • Conventions
  • Terminology
  • How to Read the Syntax Diagrams
  • Road Map

    • Part 1. Introduction to IBM Replication

  • Chapter 1. The IBM Complete Data Replication Solution
  • Support of Replication Environments
  • Replication Solution and Product Environment
  • Legacy Data Sources
  • Multivendor Data Sources and Targets
  • Interoperability with Lotus Notes and ODBC Accessible Data Stores
  • Services
  • IBM Replication Education

  • Chapter 2. Introduction to IBM Replication: Tools and Concepts
  • The Replication Tools
  • The Control Center
  • The Capture Program
  • The Apply Program
  • Advanced Replication Concepts
  • Replication Subscriptions: Ensuring Data Consistency
  • Before-Image and After-Image Columns
  • More about the Target Table Types
  • Auto-Registration
  • SQL Statements and Stored Procedures
  • Data Blocking: Using MAX_SYNCH_MINUTES for Large Jobs
  • Replication Subscription Timing
  • Staging Changed Data
  • How the Apply Program Selects a Source Table
  • Using Changed Data to Update Condensed Copies
  • Pull Versus Push Apply Design
  • Update-Anywhere Replication
  • Views for Replication Sources and Targets
  • Mobile Replication Enabler
  • How the Capture and Apply Programs Coordinate Pruning
  • Gaps Between Source and Target Tables

  • Chapter 3. Getting Started
  • Performing a Replication Scenario
  • Defining a Replication Source
  • Defining a Subscription
  • Configuring the Capture and Apply Programs
  • Configuring the Capture Program
  • Configuring the Apply Program
  • Providing End-User Authentication at the Source Server
  • Starting the Capture and Apply Programs
  • Stopping the Capture and Apply Programs

    • Part 2. Planning for Replication

  • Chapter 4. Replication Usage Scenarios
  • Recommended Usage Scenarios
  • Operational to Decision Support System Data Replication
  • Distributed Database Systems
  • Improved Network Load Balancing
  • Data Consolidation and Distribution
  • Improved Application Availability
  • Data Archive
  • Building Audit Trails
  • Mobile Replication
  • Potential Usage Scenarios
  • Update-Anywhere Replication
  • Logical Recovery
  • Extending IBM Replication
  • Usage Scenarios Not Recommended for Replication
  • Synchronous Replication
  • Hot-Site Recovery

  • Chapter 5. System Planning
  • Replication Products
  • Software and Hardware Requirements
  • The Capture and Apply Programs on the DB2 Universal Database
  • The Capture and Apply Programs for DB2 for MVS, DB2 for VSE, or DB2 for VM
  • Hardware Requirements
  • Software Requirements
  • Storage Requirements
  • DBMS Logging
  • New Tables
  • The Apply Spill File
  • Data Blocking for Large Volumes of Changes
  • The Active Log File Size for Capture for MVS on DB2 for MVS 3.1 and Capture for VSE and VM 5.1
  • General Storage Considerations
  • Capacity Requirements Analysis
  • The Capture Program
  • The Apply Program
  • Administration
  • Network Requirements
  • Connectivity Possibilities
  • Bandwidth Impact Analysis
  • Throughput Capacity
  • Security and Authorization Requirements
  • Authorization Requirements for Administration
  • Authorization Requirements for the Capture Program
  • Authorization Requirements for the Apply Program
  • Customization Requirements

  • Chapter 6. Application Planning
  • Data Transformation Requirements
  • Basic Data Enhancement
  • Advanced Data Enhancement
  • Auditing Requirements
  • Mobile Replication Requirements
  • Replication Logical Partitioning Key Considerations
  • Data Sharing Considerations
  • Extended Enterprise Edition Considerations
  • Data Restrictions
  • Data Currency Requirements
  • Data Consistency Requirements
  • Update-Anywhere Replication
  • Conflict Detection
  • Recovering from Conflicts
  • CCD Tables
  • Recommended Usage
  • Restrictions
  • Minimizing Contention between Capture and Apply for MVS 3.1 Sources and Targets
  • How Locking Affects Contention on Platforms without ISOLATION (UR) Support

    • Part 3. Administering Your Replication System

  • Chapter 7. Administration Overview
  • Overview of Replication Administration Steps
  • Navigating to Your Replication Objects with the Control Center
  • Replication Restrictions for Extended Enterprise Edition
  • Configuring the Control Center for Non-DB2 Universal Database RDBMs
  • Setting Replication Preferences in the DB2 Tools Settings Notebook
  • Working with Customized Replication Control Tables
  • Customizing and Running Replication SQL Files
  • Ordinary and Delimited Identifiers

  • Chapter 8. Working with Replication Sources
  • What Is a Replication Source?
  • Defining Replication Sources
  • Defining a Replication Source with the Default Values (Quick)
  • Defining a Custom Replication Source
  • Defining an External CCD Table as a Replication Sources
  • Defining Join Replication Sources
  • Viewing or Changing Existing Replication Sources
  • Removing Replication Sources

  • Chapter 9. Working with Replication Targets
  • What Are Replication Subscriptions?
  • Defining Replication Subscriptions
  • Defining Replication Sources: Advanced Tasks
  • Choosing a Target Table Type
  • Defining the Target Table Structure: Columns and Rows
  • Setting the Copying Schedule: Time or Event Based
  • Specifying Mini-Cycles for the Apply Program to Copy Committed Data
  • Defining SQL Statements or CALL Procedures for the Replication Subscription
  • Defining a Replication Subscription with a User-Defined Target Table
  • Restrictions
  • Maintaining a User-Defined Target Table
  • Activating and Deactivating Replication Subscriptions
  • Cloning a Replication Subscription to Another Server
  • Viewing or Changing an Existing Replication Subscription
  • Removing Replication Subscriptions

    • Part 4. IBM Replication Capture and Apply

  • Chapter 10. Capture and Apply for MVS
  • Setting Up the Capture and Apply Programs
  • Specifying Tuning Parameters for the Capture Program
  • Restrictions When Running the Capture Program
  • Authorization for Running the Capture Program
  • Recovering from Severe Errors
  • Alert Generation
  • Trace Buffer
  • Trace Output
  • Storage Dump
  • Operating Capture for MVS
  • Before You Start the Capture Program
  • Starting Capture for MVS
  • Scheduling Capture for MVS
  • Stopping Capture for MVS
  • Suspending Capture for MVS
  • Resuming Capture for MVS
  • Reinitializing Capture for MVS
  • Pruning the Change Data and Unit-of-Work Tables
  • Providing the Current Log Sequence Number
  • Warm and Cold Starts
  • Warm Start Process
  • Automatic Cold Starts
  • Forcing a Warm Start
  • Operating Apply for MVS
  • Before You Start the Apply Program
  • Starting Apply for MVS
  • Scheduling Apply for MVS
  • Stopping Apply for MVS
  • Additional Apply Program Operations
  • Scheduling Subscriptions with the Event Table
  • Loading Large Copies
  • Returning Control to Users with ASNDONE
  • Initiating a Forward Recovery with the Apply Program
  • Troubleshooting
  • Problems Using the Capture Program
  • Problems Using the Apply Program

  • Chapter 11. Capture and Apply for Windows NT and Windows 95
  • Setting Up the Capture and Apply Programs
  • Configuring the Capture Program for Windows NT and Windows 95
  • Configuring the Apply Program for Windows NT and Windows 95
  • Providing End-User Authentication at the Source Server
  • Setting Up the NT Service Control Manager
  • Specifying Tuning Parameters for the Capture Program
  • Restrictions When Running the Capture Program
  • Authorization for Running the Capture Program
  • Operating Capture for Windows NT and Windows 95
  • Before You Start the Capture Program
  • Starting Capture for Windows NT and Windows 95
  • Scheduling Capture for Windows NT and Windows 95
  • Stopping Capture for Windows NT and Windows 95
  • Suspending Capture for Windows NT and Windows 95
  • Resuming Capture for Windows NT and Windows 95
  • Reinitializing Capture for Windows NT and Windows 95
  • Pruning the Change Data and Unit-of-Work Tables
  • Providing the Current Log Sequence Number
  • Warm and Cold Starts
  • Warm Start Process
  • Automatic Cold Starts
  • Forcing a Warm Start
  • Operating Apply for Windows NT and Windows 95
  • Before You Start the Apply Program
  • Starting Apply for Windows NT and Windows 95
  • Scheduling Apply for Windows NT and Windows 95
  • Stopping Apply for Windows NT and Windows 95
  • Additional Apply Program Operations
  • Scheduling Subscriptions with the Event Table
  • Refreshing Target Tables with ASNLOAD
  • Returning Control to Users with ASNDONE
  • Initiating a Forward Recovery with the Apply Program
  • Troubleshooting
  • Problems Using the Capture Program
  • Problems Using the Apply Program

  • Chapter 12. Capture and Apply for OS/2
  • Setting Up the Capture and Apply Programs
  • Configuring the Capture Program for OS/2
  • Configuring the Apply Program for OS/2
  • Specifying Tuning Parameters for the Capture Program
  • Restrictions When Running the Capture Program
  • Authorization for Running the Capture Program
  • Operating Capture for OS/2
  • Before You Start the Capture Program
  • Starting Capture for OS/2
  • Scheduling Capture for OS/2
  • Stopping Capture for OS/2
  • Suspending Capture for OS/2
  • Resuming Capture for OS/2
  • Reinitializing Capture for OS/2
  • Pruning the Change Data and Unit-of-Work Tables
  • Providing the Current Log Sequence Number
  • Warm and Cold Starts
  • Warm Start Process
  • Automatic Cold Starts
  • Forcing a Warm Start
  • Operating Apply for OS/2
  • Before You Start theApply Program
  • Starting Apply for OS/2
  • Scheduling Apply for OS/2
  • Stopping Apply for OS/2
  • Additional Apply for OS/2 Operations
  • Scheduling Subscriptions with the Event Table
  • Refreshing Target Tables with ASNLOAD
  • Returning Control to Users with ASNDONE
  • Initiating a Forward Recovery with the Apply Program
  • Troubleshooting
  • Problems Using the Capture Program
  • Problems Using the Apply Program

  • Chapter 13. Capture and Apply for UNIX Platforms
  • 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
  • Specifying Tuning Parameters for the Capture Program
  • Restrictions When Running the Capture Program
  • Authorization for Running the Capture Program
  • Operating Capture for AIX, Capture for HP-UX, and Capture for Solaris
  • Before You Start the Capture Program
  • Starting Capture for AIX, Capture for HP-UX, and Capture for Solaris
  • Scheduling Capture for AIX, Capture for HP-UX, and Capture for Solaris
  • Stopping Capture for AIX, Capture for HP-UX, and Capture for Solaris
  • Suspending Capture for AIX, Capture for HP-UX, and Capture for Solaris
  • Resuming Capture for AIX, Capture for HP-UX, and Capture for Solaris
  • Reinitializing Capture for AIX, Capture for HP-UX, and Capture for Solaris
  • Pruning the Change Data and Unit-of-Work Tables
  • Providing the Current Log Sequence Number
  • Warm and Cold Starts
  • Warm Start Process
  • Automatic Cold Starts
  • Forcing a Warm Start
  • Operating Apply for AIX, Apply for HP-UX, and Apply for Solaris
  • Before You Start the Apply Program
  • Starting Apply for AIX, Apply for HP-UX, and Apply for Solaris
  • Scheduling Apply for AIX, Apply for HP-UX, and Apply for Solaris
  • Stopping Apply for AIX, Apply for HP-UX, and Apply for Solaris
  • Additional Apply Operations
  • Scheduling Subscriptions with the Event Table
  • Refreshing Target Tables with ASNLOAD
  • Returning Control to Users with ASNDONE
  • Initiating a Forward Recovery with the Apply Program
  • Troubleshooting
  • Problems Using the Capture Program
  • Problems Using the Apply Program

  • Chapter 14. Capture for VSE
  • Setting Up the Capture Program
  • Specifying Tuning Parameters for the Capture Program
  • Restrictions When Running the Capture Program
  • Authorization for Running the Capture Program
  • Recovering from Severe Errors
  • Trace Buffer
  • Trace Output
  • Storage Dump
  • Operating Capture for VSE
  • Before You Start the Capture Program
  • Starting Capture for VSE
  • Stopping Capture for VSE
  • Suspending Capture for VSE
  • Resuming Capture for VSE
  • Reinitializing Capture for VSE
  • Pruning the Change Data and Unit-of-Work Tables
  • Providing the Current Log Sequence Number
  • Warm and Cold Starts
  • Warm Start Process
  • Automatic Cold Starts
  • Forcing a Warm Start
  • Troubleshooting: Problems Using the Capture Program

  • Chapter 15. Capture for VM
  • Setting Up the Capture Program
  • Specifying Tuning Parameters for the Capture Program
  • Restrictions When Running the Capture Program
  • Authorization for Running the Capture Program
  • Recovering from Severe Errors
  • Trace Buffer
  • Trace Output
  • Storage Dump
  • Operating Capture for VM
  • Before You Start the Capture program
  • Starting Capture for VM
  • Stopping the Capture program for VM
  • Suspending Capture for VM
  • Resuming Capture for VM
  • Reinitializing Capture for VM
  • Pruning the Change Data and Unit-of-Work Tables
  • Providing the Current Log Sequence Number
  • Warm and Cold Starts
  • Warm Start Process
  • Automatic Cold Starts
  • Forcing a Warm Start
  • Troubleshooting: Problems Using the Capture program

    • Part 5. Advanced Topics

  • Chapter 16. Mobile Replication
  • An Overview of Mobile Replication
  • Highlights
  • How Mobile Replication Works
  • Mobile Replication Restrictions
  • Planning Mobile Replication
  • Software and Hardware Requirements
  • Communication Program Requirements
  • Configuring the Mobile Client
  • Setting Up the Mobile Client
  • 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 Graphical Interface
  • Selecting Replication Subscriptions
  • Selecting an Apply Qualifier

  • Chapter 17. Advanced User Techniques
  • Defining Replication Sources and Replication Subscriptions for Update Anywhere
  • Stopping the Capture Program with a Trigger

  • Chapter 18. Problem Determination Facilities
  • Replication Diagnosis Resources
  • Errors Encountered during Replication Administration
  • Errors Encountered While Running the Capture and Apply Programs
  • The Apply Program Problem Determination Facilities
  • The Apply Trail Control Table (ASN.IBMSNAP_APPLYTRAIL)
  • Apply Program Trace File
  • The Apply Program Log File
  • Capture Program Problem Determination Facilities
  • Capture Program Trace Control Table (ASN.IBMSNAP_TRACE)
  • Capture Program Trace File
  • Capture Program Log
  • Problem Determination Scenario
  • Problem Source Identification Questions

    • Part 6. Reference Information

  • Chapter 19. Migrating from DataPropagator Relational Version 1 to IBM Replication Version 5
  • Migration Process Overview
  • Collection
  • Analysis
  • Migration
  • Migration Requirements
  • Migration Precautions
  • Installation of the Capture and Apply Programs on DB2 Version 2
  • Before You Begin Migration
  • Invoking the Migration Program and Actions
  • Collecting Data with BUILDDB
  • Analyzing Data with PREPARE
  • Migrating Data with MIGRATE
  • Migrating a Capture Program Process
  • Migrating an Apply Program Process
  • Reverting to Version 1 with FALLBACK
  • Falling Back from an Apply Program Process
  • Falling Back from a Capture Program Process
  • Dropping Version 1 Control Tables and Migration Control Tables with CLEANUP

  • Chapter 20. Table Structures
  • Control Tables Used at the Source Server
  • Capture Enqueue Table
  • Change Data Table
  • Critical Section Table
  • Pruning Control Table
  • Register Table
  • Trace Table
  • Tuning Parameters Table
  • Unit-of-Work Table
  • Warm Start Table
  • Warm Start Table for Capture for VSE and VM
  • Control Tables Used at the Control Server
  • Apply Trail Table
  • Subscription Columns Table
  • Subscription Events Table
  • Subscription Set Table
  • Subscription Statements Table
  • Subscription Targets Member Table
  • Target Tables
  • Base Aggregate Target Table
  • Change Aggregate Target Table
  • Consistent Change Data Table
  • Point-in-Time Target Table
  • Replica Target Table
  • User Copy Target Table

  • Chapter 21. IBM Replication Messages
  • Capture Program Messages
  • Apply Program Messages
  • Migration Messages

    • Part 7. Appendixes

  • Appendix A. How the DB2 Library Is Structured
  • SmartGuides
  • Online Help
  • DB2 Books
  • About the Information Center

  • Appendix B. What's New in IBM Replication
  • Packaging Integration
  • Improved Administration
  • Batch Application Stream Integration
  • New Target Table Types
  • Data Consistency
  • Improved Reliability
  • Improved Performance for the Capture and Apply Programs
  • Operational and Maintenance Enhancements
  • Expanded Support for Run-time Processing Statements
  • Simplified Authorization and Security
  • New Update-Anywhere Capability
  • Support for Occasionally-Connected Systems

  • Appendix C. Notices
  • Programming Interface Information
  • Trademarks
  • Trademarks of Other Companies

  • Index

  • Appendix D. Contacting IBM

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

    [ DB2 List of Books | Search the DB2 Books ]