• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Information
  • Conventions
• Understanding Oracle GoldenGate for HP NonStop
  • Oracle GoldenGate Overview
    • Oracle GoldenGate Configuration
    • Oracle GoldenGate Features
  • Oracle GoldenGate Architecture
    • Oracle GoldenGate Components
      • Extract
      • Logger
      • Collector
      • Trails
      • Replicat
      • Manager
      • Syncfile
      • Processing Groups
      • Checkpoints
      • Parameters
      • Reader
      • Coordinator
  • Oracle GoldenGate Processing
    • Initial Data Synchronization
      • File to Replicat
      • Direct Load
    • Capturing Data Changes from TMF Applications
      • Capturing Changes for Distributed Network Transactions
    • Capturing Data Changes from Non-TMF applications
    • Using Extract for Data Distribution
    • Batch Processing
    • Capturing Directly from Files
    • Custom Event Processing
  • Oracle GoldenGate Commands
    • To Start GGSCI
• Planning the Configuration
  • Planning Overview
  • Configuring TMF-Enabled Processing
    • Changing the Layout of a File or Table
    • Ensuring All Audit is Processed
    • Keeping Necessary Audit Available for Extract
      • Using Tape Dumps as an Alternative Location
    • Minimizing Vulnerability to Outages
    • Configuring FUP RELOAD Activity
    • Data Compression
      • Compressed Enscribe Records
      • Compressed SQL Records
      • DCOMPRESS File Attribute Not Supported
      • AUDITCOMPRESS File Attribute Considerations
    • Configuring for Distributed Network Transactions
      • Re-configuring TMF
  • Configuring Non-TMF-Enabled Processing
    • Maintaining Data Integrity
    • Supported File Types and Operations
    • Authentication for Bound Programs
    • System Utilities That Update Databases
    • Private Memory and Stack Space
    • Impact on Existing Application Performance
  • Configuring Oracle Goldengate Global Operations
    • GLOBALS Parameter File
    • Changing the Default Location of AUDCFG
  • Configuring Replication
    • Replicating SQL Tables with System Keys
    • Replicating Primary Key Updates
      • Missing Row Errors
      • Non-Audited Target
      • Compressed Updates to Enscribe Targets
    • Files and Tables Other Than Key-Sequenced
    • Load Balancing and Performance Issues
    • Potential Problems with Audit Compressed Files
    • Conflicts with Updating the Target
    • Many-to-One Replication
    • Bi-Directional Replication
    • Replicating Data to Non-TMF Enabled Databases
    • Replicating New SQL Columns
  • Configuring for Maximum Throughput
    • Extraction
    • TMF Extraction
    • Non-TMF Data Extraction
    • Replication
    • Latency Issues
    • Capacity Planning
      • TMF Data Extraction
      • Non-TMF Data Extraction
      • Data Transfer into Oracle GoldenGate Trails
      • Replicat Throughput
  • Changing Default Component Names
  • Using Wildcards
  • Support for DDL and DDL2
  • Specifying Internet Protocol Addresses
• Configuring Initial Data Synchronization
  • Initial Data Synchronization
    • Example Steps for Initial Data Load
      • Configure and Run Extract
      • Perform Initial Load Using the File to Replicat Method
      • Configure and Run Replicat
    • Direct Load
      • To run direct load:
      • Using Wildcards
    • Direct Bulk Load
      • To run direct bulk load:
    • Synchronizing Nonstop Databases Using Database Utilities Through TCP/IP
  • Controlling the IP Process for Replicat
  • Loading Oracle, Microsoft, or Sybase SQL Server Tables
    • Loading to Oracle or SQL Server
    • Initial Sync Parameter File Examples
      • Sample NonStop to Oracle Parameter Files
      • Sample SQL Server Parameter Files
  • Limiting the Enscribe Source Key Range for Initial Load
  • Restarting an Initial Load
  • Loading Initial Data from Windows and Unix
  • Integrating Source and Target Data
  • Distributing Extracted Data
  • Direct File Extraction
  • Batch Processing
    • One-Time Database Extraction
    • Trickle Batch Processing
      • Determining the Next File
      • When the Next File is Processed
• Configuring Oracle GoldenGate Security
  • Using Encryption
    • How Data is Encrypted?
    • Encrypting Trail or Extract Files
    • Encrypting a Database Password
    • Encrypting Data Sent Across TCP/IP
  • Generating Encryption Keys
  • Using Command Security
    • Securing the CMDSEC File
• Configuring the Manager and Collector
  • Introducing Manager
  • Configuring and Starting Manager
    • Creating and Configuring the Manager Parameter File
      • A Sample Manager Parameter File
    • Starting and Stopping Manager
  • Configuring and Running the Collector
    • Maintaining Ports for Remote Connections through Firewalls
    • Configuring Collector
      • Configuration Examples
    • The TCP/IP Port
      • Dynamic Method
      • Explicit Method
    • Monitoring Collector
    • Security Considerations
  • Collecting Between Open Systems and NonStop
• Configuring Change Synchronization
  • Introduction
  • Change Synchronization for TMF Applications
    • Configuring Extract
    • Configuring Trails
    • Configuring Replicat
  • Change Synchronization for Non-TMF Applications
    • Creating the LOGPARM File
      • Sample LOGPARM File
    • Configuring Logger and GGSLIB
    • Starting Logger
    • Using Macros to Bind GGSLIB to a Non-TMF Application
      • Building GGSLIB
      • Private Memory and Stack Space
    • Alternate Methods of Binding GGSLIB to an Application
      • Using the ?Search Directive
      • Non-Native Environments
      • Native Mode Itanium Systems
    • Libraries for Native Applications
      • Running NLDLIB
      • Removing a Library
    • Activating Authorization of Bound Libraries
      • Managing the Authorization Event
      • Adding and Verifying the Authorization Event
      • Using Different PARAM-TEXT Options
      • Getting the Current Status of the Authorization Event
  • Working with Parameter Files
    • Creating a Parameter File
    • Storing Parameter Files
    • Viewing a Parameter File
    • Changing a Parameter File
    • Using OBEY and Macros in Parameters
    • Verifying a Parameter File
    • Substituting a Parameter
• Configuring Custom Operations
  • User Exits
    • Record Formats for User Exits
    • Creating User Exits
    • Linking User Exits
    • Sample User Exits
  • Using Oracle GoldenGate Macros
    • Creating a Macro
    • Creating Macro Parameters
    • Changing the Macro Character
    • Running the Macro
    • Invoking a Macro Without Parameters
    • Sample Macros
      • Implementing Multiple Uses of a Statement
      • Consolidating Multiple Commands
    • Macro Libraries
      • Sample Macro Libraries
      • Suppressing Report File Listing
      • Tracing Parameter Expansion
  • Using OBEY Files
  • Creating High Pin Processes
    • Replicat
    • Extract and GGSCI
    • TACL DEFINE
• Integrating Data
  • Selecting Records
    • Selecting Records with FILTER
    • Selecting Records with WHERE
      • Comparing Fields
      • Compressed Update Considerations
      • Testing for NULL Values
  • Column Mapping
    • Mapping Between Different Database Structures
      • Data Type Conversions
      • Oracle GoldenGate User Tokens
      • Populating User Tokens in the Trail Header
      • Retrieving Values
      • Default Mapping
      • Mapping Examples
      • Legal Column Mapping
      • Dangerous Mapping if AUDITCOMPRESS Used on Source File
      • Using Constants, Taking Default Values.
  • Field Conversion Functions
    • Function Arguments
    • Arithmetic Expressions
    • Null, Invalid, and Missing Columns and Fields
      • Overriding Exceptional Conditions
  • Retrieving Before Values
  • Detokenizing Base24 (Classic) TLF/PTLF records
    • Converting from the T24 User Exit to Oracle GoldenGate Mapping
    • Detokenizing with Oracle GoldenGate Mapping
• Managing and Monitoring
  • Managing Tasks
    • Getting Information on Tasks
    • Managing Tasks Using the Process Name
  • Managing Oracle GoldenGate Trails
    • Initial Allocation of Storage for Trails
      • To estimate the required trail space
    • Ongoing Trail Management
      • Setting the Size of the Trail
      • Setting the PURGEOLDEXTRACTS rules
      • Manager Purge Trail Processing
      • Recommendations for Managing Trail Purges
  • Oracle GoldenGate Self Describing Trail Files
    • Understanding the Self-Describing Trail Behavior
  • Managing Log Trails
  • Monitoring Processing
  • Error Handling
    • Error Handling Parameters
    • Handling Replicat Errors
    • TCP/IP Error Handling
      • Altering TCP/IP Error Handling Parameters
    • Using Discard Files
      • Using the Discard File
      • Using the SQL Formatted Discard File
    • Conflict Detection with SQLEXEC
      • A SQLEXEC Example
  • Using the Event Log
  • Using the Process Report
    • Viewing Process Reports
    • Storing Process Reports
    • Managing Process Reports
    • Generating Run-time Statistics
  • Viewing Record Counts
  • The STATS Command
  • Collecting Events from Other Systems
    • Running EMSCLNT on Other Operating Systems
• Using Oracle GoldenGate Utilities
  • Generating Data Definitions with DEFGEN
    • Configuring DEFGEN Interactively
    • Configuring DEFGEN in Batch
    • A Sample Definitions File
    • Running DEFGEN to Use Existing Definitions
  • Creating Target Database DDL
    • Configuring DDLGEN Interactively
    • Configuring DDLGEN in Batch
    • Addressing Enscribe DDL Peculiarities
    • Understanding the Template File
      • Sample Template File
      • Sample NonStop SQL Table Definition
      • Modifying the Sample Template File
      • Generating the Sample Definition
  • Using Syncfile
    • Implementing Syncfile
• Oracle Oracle GoldenGate Components
  • Programs, Utilities, Macros, and Libraries
  • Oracle GoldenGate Database
  • External Component Summary
  • Templates, Demonstrations, and Sample Code
• Installing Event Detail Text
  • Standard Installation
  • Custom Installation
  • Customizing Error Messages