My Oracle Support Banner

Issue With REPLICAT, Using UPDATEFORMAT FULL, And Newer Versions Using GGSUNIFIEDUPDATE (Doc ID 2472459.1)

Last updated on MAY 11, 2022

Applies to:

Oracle GoldenGate - Version to [Release 12.2 to 12.3]
Information in this document applies to any platform.


Problem Summary
Issue with REPLICAT, using UPDATEFORMAT FULL, and newer versions using GGSUNIFIEDUPDATE

Problem Description
Assume the EXTRACT is putting the proper before columns in the logs. (NOCOMPRESSUPDATES, UPDATEFORMAT FULL, LOGALLSUPCOLS, etc…)

Example replicat:


MAP x.y, TARGET z.y, KEYCOLS (w, x, y),
COLMAP (USEDEFAULTS, …..added columns for instance);

Without UPDATEFORMAT FULL on the source, the records are logged as 2 records, the older versions with GETUPDATES, LOGALLSUPCOLS, from the EXTRACT side etc…since DB2 z/os cannot do TABLE x, GETBEFORECOLS() yet the result is:

This will log a Before record, then an After record both with all columns as logged.

On new versions of OGG 12.3 or 12.2 with any GGSUNIFIEDUPDATE record in the logs:

Any version with the GGSUNIFIEDUPDATE FULL or COMPACT the same logic will only log AFTER image record only, even with GETUPDATEBEFORES in the REPLICAT is specified.

If the customer is required to code each @BEFORE(columns) for these tables in separate mapping it will be an extensive amount of work and not something anyone wants to support going forward for hundreds or thousands of tables.

Based on this document, it only says not supported for COMPACT, and older versions will not work in this case:


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.