IBM Books

DB2 Replication Guide and Reference

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 Complete IBM Data Replication Solution
  • How the Tools Work Together
  • 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 the Replication Tools
  • The Control Center
  • Tasks
  • Objects
  • Types of Copies
  • Auto-Registration
  • The Replication Control Tables
  • The Capture Program
  • How the Capture Program Captures Changes
  • Control Tables Used by the Capture Program
  • The Apply Program
  • How the Apply Program Replicates Data
  • The Apply Processing Cycle
  • How the Apply Program Selects a Source Table
  • The Apply Qualifier
  • The Control Server
  • Control Tables Used by the Apply Program
  • Full Refresh and Differential Refresh Replication

  • Chapter 3. Getting Started
  • Performing a Replication Scenario for Windows NT
  • 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
  • Mobile Replication with MS Jet Client
  • 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
  • Hardware and Software 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
  • Pull versus Push Apply Design
  • 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
  • Staging Changed Data
  • CD and CCD Tables
  • Staging Tables
  • Benefits of Staging Data
  • Transaction-Based versus Transaction-Consistent Replication: Using Internal CCD Tables to Reduce Network Load
  • How External CCD Tables Are Refreshed (Cascade CCD Full Refresh)
  • Developing a Data Warehouse with CCD Tables
  • Replication Logical Partitioning Key Considerations
  • Data Sharing Considerations
  • Extended Enterprise Edition Considerations
  • Data Restrictions
  • Limits on Column Names for Capturing Before-Image Data
  • Data Currency Requirements
  • Interval Timing (Relative Timing)
  • Event Timing
  • 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
  • Resolving Gaps between Source and Target Tables
  • Using Your Own Full Refresh Technique for External CCD Tables

    • Part 3. Administering Your Replication System

  • Chapter 7. Administration Overview
  • Overview of Replication Administration Steps
  • Navigating to Your Replication Objects with the Control Center
  • Configuring the Control Center for Non-DB2 Universal Database RDBMSs
  • 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 Source
  • Defining Join Replication Sources
  • Viewing or Changing Existing Replication Sources
  • Removing Replication Sources
  • Defining Replication Subscriptions for Update Anywhere

  • 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
  • Defining Replication Sources and Replication Subscriptions for Update Anywhere

    • 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
  • DB2 for MVS Rules Regarding Indexes
  • 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
  • Returning Control to Users with ASNDONE
  • Initiating a Forward Recovery with the Apply Program
  • Loading the Tables within a Subscription Set
  • 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
  • Loading the Tables within a Subscription Set
  • 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 the Apply Program
  • Starting Apply for OS/2
  • Scheduling Apply for OS/2
  • Stopping Apply for OS/2
  • 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
  • Loading the Tables within a Subscription Set
  • Troubleshooting
  • Problems Using the Capture Program
  • Problems Using the Apply Program

  • Chapter 13. Capture and Apply for UNIX Platforms
  • Setting up a UNIX User Account
  • 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, Capture for Solaris, and Capture for UnixWare 7
  • Before You Start the Capture Program
  • Starting Capture for AIX, Capture for HP-UX, Capture for Solaris, and Capture for UnixWare 7
  • Scheduling Capture for AIX, Capture for HP-UX, Capture for Solaris, and Capture for UnixWare 7
  • Stopping Capture for AIX, Capture for HP-UX, Capture for Solaris, and Capture for UnixWare 7
  • Suspending Capture for AIX, Capture for HP-UX, Capture for Solaris, and Capture for UnixWare 7
  • Resuming Capture for AIX, Capture for HP-UX, Capture for Solaris, and Capture for UnixWare 7
  • Reinitializing Capture for AIX, Capture for HP-UX, Capture for Solaris, and Capture for UnixWare 7
  • 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, Apply for Solaris, and Apply for UnixWare 7
  • Before You Start the Apply Program
  • Starting Apply for AIX, Apply for HP-UX, Apply for Solaris, and Apply for UnixWare 7
  • Scheduling Apply for AIX, Apply for HP-UX, Apply for Solaris, and Apply for UnixWare 7
  • Stopping Apply for AIX, Apply for HP-UX, Apply for Solaris, and Apply for UnixWare 7
  • 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
  • Loading the Tables within a Subscription Set
  • 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 Capture 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. Mobile Replication

  • Chapter 16. Mobile Replication for DB2
  • An Overview of Mobile Replication
  • Highlights
  • 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 Graphical Interface
  • Selecting Replication Subscriptions
  • Selecting an Apply Qualifier

  • Chapter 17. Mobile Replication Using IBM 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
  • Operating DataPropagator for Microsoft Jet
  • Starting Capture 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
  • Parameters
  • Error Handling
  • DataPropagator for Microsoft Jet Control Tables
  • Control Server Tables
  • Target Server Tables

    • Part 6. Reference Information

  • Chapter 18. 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
  • Handling Migration Process Failures for the Capture Program
  • Migrating an Apply Program Process
  • Handling Migration Process Failures for the Apply Program
  • 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
  • Dropping Apply Program Views and Tables
  • Dropping Capture Program Views and Tables
  • Tables in the Migration Database
  • Version Control Table
  • Global Change Data Control Table
  • Global View Dependencies Table
  • Global View Text Table
  • Global Refresh Control Table
  • Global Refresh Columns Table
  • Registration Migration Units (RMU) Table
  • Subscription Migration Units (SMU) Table
  • RMU Dependencies on SMU Table
  • SMU Dependencies on RMU Table

  • Chapter 19. Table Structures
  • List of Tables Used at the Source Server
  • List of Tables Used at the Control Server
  • List of Tables Used at the Target Server
  • 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
  • Subscription Schema Changes Table (Microsoft Jet Specific)
  • Row-Replica Target List Table (Microsoft Jet Specific)
  • Control Tables Used at the Target Server
  • Base Aggregate Target Table
  • Change Aggregate Target Table
  • Consistent Change Data Table
  • Point-in-Time Target Table
  • Replica Target Table
  • User Copy Target Table
  • 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)

  • Chapter 20. 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

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

  • Chapter 22. Sample Invocation JCL
  • Link-Edit JCL for Capture (MVS for DB2 Version 3)
  • Link-Edit JCL for Capture (MVS for DB2 Version 4)
  • Link-Edit JCL for Capture (MVS for DB2 Version 5)
  • Bind Package JCL for Capture (MVS for DB2 Version 3)
  • Bind Package JCL for Capture (MVS for DB2 Version 4)
  • Bind Package JCL for Capture (MVS for DB2 Version 5)
  • Invocation JCL for Capture (MVS for DB2 Version 3)
  • Invocation JCL for Capture (MVS for DB2 Version 4)
  • Invocation JCL for Capture (MVS for DB2 Version 5)
  • Link-Edit JCL for Apply (MVS for DB2 Version 3)
  • Link-Edit JCL for Apply (MVS for DB2 Version 4)
  • Link-Edit JCL for Apply (MVS for DB2 Version 5)
  • Bind Package JCL for Apply (MVS for DB2 Version 3)
  • Bind Package JCL for Apply (MVS for DB2 Version 4)
  • Bind Package JCL for Apply (MVS for DB2 Version 5)
  • Invocation JCL for Apply (MVS for DB2 Version 3)
  • Invocation JCL for Apply (MVS for DB2 Version 4)
  • Invocation JCL for Apply (MVS for DB2 Version 5)

    • Part 7. Appendixes

  • Appendix A. How the DB2 Library Is Structured
  • SmartGuides
  • Online Help
  • DB2 Books
  • Viewing Online Books
  • Searching Online Books
  • Printing the PostScript Books
  • Ordering the Printed DB2 Books
  • Information Center

  • Appendix B. Tables at a Glance

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

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

  • Appendix E. Contacting IBM

  • Glossary

  • Index

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

    [ DB2 List of Books | Search the DB2 Books ]