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

Last updated on APRIL 17, 2023

Applies to:

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

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