My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

Applies to:

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

Symptoms

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:

INSERTALLRECS
GETUPDATEBEFORES

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:

Cause

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
Symptoms
Cause
Solution
References


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