1/9

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 System Requirements and Preinstallation Instructions

• 1.1 Verifying Certification and System Requirements
• 1.2 Operating System Requirements
  • 1.2.1 Memory Requirements
  • 1.2.2 Disk Requirements
  • 1.2.3 Network
  • 1.2.4 Operating System Privileges
  • 1.2.5 Console
  • 1.2.6 Other Programs
• 1.3 Database Requirements
  • 1.3.1 Database Configuration
  • 1.3.2 Database User for Oracle GoldenGate Processes
• 1.4 Supported DB2 LUW Data Types
• 1.5 Non-Supported DB2 LUW Data Types
• 1.6 Supported Objects and Operations for DB2 LUW
• 1.7 Non-Supported Objects and Operations for DB2 LUW
• 1.8 Supported Object Names

2 Installing Oracle GoldenGate

• 2.1 Installation Overview
• 2.2 Choosing an Installation System for DB2
  • 2.2.1 Choosing and Configuring a System for Remote Capture or Delivery
• 2.3 Downloading Oracle GoldenGate
• 2.4 Setting Library Paths for Dynamic Builds on UNIX
• 2.5 Installing Oracle GoldenGate on Linux and UNIX
  • 2.5.1 Installing the Oracle GoldenGate Files
• 2.6 Installing Oracle GoldenGate on Windows
  • 2.6.1 Installing the Oracle GoldenGate Files
  • 2.6.2 Specifying a Custom Manager Name
  • 2.6.3 Installing Manager as a Windows Service

3 Preparing the System for Oracle GoldenGate

• 3.1 Configuring the Transaction Logs for Oracle GoldenGate
  • 3.1.1 Retaining the Transaction Logs
  • 3.1.2 Specifying the Archive Path
• 3.2 Preparing Tables for Processing
  • 3.2.1 Disabling Triggers and Cascade Constraints
  • 3.2.2 Assigning Row Identifiers
  • 3.2.3 Preventing Key Changes
  • 3.2.4 Enabling Change Capture
  • 3.2.5 Maintaining Materialized Query Tables
• 3.3 Setting the Session Character Set
• 3.4 Preparing for Initial Extraction
• 3.5 Specifying the DB2 LUW Database in Parameter Files

4 Configuring Oracle GoldenGate for DB2 LUW

• 4.1 What to Expect from these Instructions
• 4.2 Where to Get More Information
• 4.3 Configuring the Primary Extract
• 4.4 Configuring the Data Pump Extract
• 4.5 Configuring Replicat
  • 4.5.1 Creating a Checkpoint Table
  • 4.5.2 Configuring the Replicat Parameter File
• 4.6 Next Steps in the Deployment
• 4.7 When to Start Replicating Transactional Changes
• 4.8 Testing Your Configuration

5 Uninstalling Oracle GoldenGate

• 5.1 Stopping Processes
• 5.2 Removing the Oracle GoldenGate Database Setup
• 5.3 Removing Oracle GoldenGate Windows Components
• 5.4 Manually Removing the Oracle GoldenGate Files

A Oracle GoldenGate Installed Components

• A.1 Oracle GoldenGate Programs and Utilities
• A.2 Oracle GoldenGate Subdirectories
• A.3 Other Oracle GoldenGate Files
• A.4 Oracle GoldenGate Checkpoint Table