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 System Services
  • 1.2.2 Memory Requirements
  • 1.2.3 Disk Requirements
  • 1.2.4 Network Requirements
  • 1.2.5 Other Operating System Requirements
  • 1.2.6 Operating System Privileges
• 1.3 Database Requirements
  • 1.3.1 Database Configuration
  • 1.3.2 Database User for Oracle GoldenGate Processes
• 1.4 Supported DB2 on z/OS Data Types
• 1.5 Non-Supported DB2 on z/OS Data Types
• 1.6 Supported Objects and Operations for DB2 on z/OS
• 1.7 Non-Supported Objects and Operations for DB2 on z/OS

2 Installing Oracle GoldenGate

• 2.1 Installation Overview
• 2.2 Choosing an Installation System for DB2
• 2.3 Understanding and Obtaining the Oracle GoldenGate Distribution
• 2.4 Installing Oracle GoldenGate in USS on z/OS
• 2.5 Installing Oracle GoldenGate on Linux and UNIX
• 2.6 Installing Oracle GoldenGate on Windows
  • 2.6.1 Installing Oracle GoldenGate into a Windows Cluster
  • 2.6.2 Installing the Oracle GoldenGate Files
  • 2.6.3 Specifying a Custom Manager Name
  • 2.6.4 Installing Manager as a Windows Service

3 Preparing the System for Oracle GoldenGate

• 3.1 Preparing Tables for Processing
  • 3.1.1 Disabling Triggers and Cascade Constraints
  • 3.1.2 Assigning Row Identifiers
    • 3.1.2.1 How Oracle GoldenGate Determines the Kind of Row Identifier to Use
    • 3.1.2.2 Using KEYCOLS to Specify a Custom Key
  • 3.1.3 Handling ROWID Columns
• 3.2 Configuring Database Connections
  • 3.2.1 Setting Initialization Parameters
  • 3.2.2 Specifying the Path to the Initialization File
  • 3.2.3 Ensuring ODBC Connection Compatibility
  • 3.2.4 Specifying the Number of Connection Threads
• 3.3 Accessing Load Modules
• 3.4 Specifying Job Names and Owners
• 3.5 Assigning WLM Velocity Goals
• 3.6 Monitoring Processes
  • 3.6.1 Viewing Oracle GoldenGate Messages
  • 3.6.2 Identifying Oracle GoldenGate Processes
  • 3.6.3 Interpreting Statistics for Update Operations
• 3.7 Supporting Globalization Functions
  • 3.7.1 Replicating From a Source that Contains Both ASCII and EBCDIC
  • 3.7.2 Specifying Multi-Byte Characters in Object Names

4 Preparing the DB2 for z/OS Transaction Logs for Oracle GoldenGate

• 4.1 Specifying a Bootstrap Data Set
• 4.2 Making Transaction Data Available
  • 4.2.1 Enabling Change Capture
  • 4.2.2 Enabling Access to Log Records
  • 4.2.3 Sizing and Retaining the Logs
  • 4.2.4 Using Archive Logs on Tape
  • 4.2.5 Controlling Log Flushes

5 Uninstalling Oracle GoldenGate

• 5.1 Uninstalling Oracle GoldenGate from Linux or UNIX (includes USS)
• 5.2 Removing Oracle GoldenGate from Windows Cluster
• 5.3 Uninstalling Oracle GoldenGate from Windows (Non-Cluster)

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