• Home
    • 2018
    • 2017
  • Oracle GoldenGate
    • Core Platform
    • Cloud Service
    • For Oracle DB
    • For Big Data
    • For MySQL
    • For DB2 z/OS
    • For DB2 LUW
    • For DB2 i
    • For Informix
    • For SQL Server
    • For Teradata
    • For AWS Aurora
    • Foundation Suite
    • Use Cases
  • Data Management
    • General
    • Big Data
    • Oracle Database
    • MySQL
    • MS SQL Server
    • IBM DB2
    • IBM Informix
    • Teradata
    • SAP ASE
  • Data Science
  • IT
    • IT Management
    • IT Technology
  • Reading
  • About
Jinyu's Blog
About Data, Database, Integration and IT 

When to Use the Compress Updates and Deletes in Oracle GoldenGate?

10/16/2017

0 Comments

 
This blog discusses when you would use the COMPRESSUPDATES or COMPRESSDELETES ​configurations in Oracle GoldenGate. 
  • COMPRESSUPDATES, the default, causes Extract to write the primary key, the columns in the KEYCOLS, and the changed columns of a row to the trail for update operations. This provides enough information to update the correct target record (unless conflict resolution is required) while restricting the amount of data that must be processed.
  • NOCOMPRESSUPDATES sends all of the columns to the trail. This becomes the default when a table definition does not include a primary key or unique index. NOCOMPRESSUPDATES also is required when using the Conflict Detection and Resolution (CDR) feature for a DB2 database on any of the platforms that are supported by Oracle GoldenGate.
Best Practices
You would be cautious when using NOCOMPRESSUPDATES in Oracle GoldenGate because if you have tables with a lot of columns (e.g., 200 columns), this configuration will significantly increase the trail file size and thus impact the replication performance.  If you don't have the proper key or unique indexes on the source database, you can consider using the KEYCOLS. ​
The similar applies to the COMPRESSDELETES.   The supported databases are DB2 LUW, DB2 z/OS, Teradata version 12 or later, SQL Server, and Sybase.  Note that this doesn't support for MySQL database.
(Created: 11/25/2013, Last Updated: 10/16/2017) 
0 Comments

Oracle GoldenGate 12.1.2

8/15/2014

0 Comments

 
With the release of Oracle GoldenGate for Mainframe on August 15,2014, all of Oracle GoldenGate platforms for 12.1.2 are available. The following summary highlights the features and release date of these platform support: 
Picture
Oracle GoldenGate 12.1.2 Features/Release Summary
To get more information about each release, please refer to the following blogs: 
  • What's New in Oracle GoldenGate for Mainframe HP NonStop (Guardian) (12.1.2.0.0)?  (8/15/2014)
  • What's New in Oracle GoldenGate 12c for Teradata (12.1.2.0.1)? (4/24/2014) 
  • What's New in Oracle GoldenGate for DB2 iSeries (12.1.2.0.1)? (2/15/2014)
  • What's New in Oracle GoldenGate 12c for DB2 LUW (12.1.2.0.1)? (4/24/2014)
0 Comments

    Oracle GoldenGate

    This blog has updates, tips and tricks for Oracle GoldenGate.

    Categories

    All
    12.1 New Feature
    12.2 New Feature
    12.3 New Feature
    Azure
    Basic Concepts
    Best Practices
    Cloud
    Customer Story
    DB2 For ISeries
    DB2 For LUW
    DB2 For Z/OS
    Disaster Recovery
    Globalization
    GoldenGate Fundamentals
    GoldenGate Security
    How To
    HP NonStop
    Informix IDS
    Installation
    JD_Edward
    Manager
    MySQL
    Network
    News
    Oracle DB
    Release
    SQL Server
    Sybase
    Teradata
    Top
    Troubleshooting
    Tutorial
    Use Case
    User Story

    Archives

    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    May 2016
    April 2016
    March 2016
    February 2016
    December 2015
    November 2015
    October 2015
    July 2015
    June 2015
    May 2015
    March 2015
    February 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    October 2013

    RSS Feed

Copyright © 2010-2027 Jinyu Wang.