My Oracle Support Banner

ISeries MultiMember Table Replicating To Teradata Target, 12.3 (*ALL) Fails To Capture Member Name (Doc ID 2451070.1)

Last updated on JANUARY 09, 2020

Applies to:

Oracle GoldenGate - Version 12.3.0.1.2 to 12.3.0.1.2 [Release 12.3]
IBM i on POWER Systems

Symptoms

Problem Summary
---------------------------------------------------
iSeries MultiMember table replicating to Teradata Target, 12.3 (*ALL) Fails to capture Member name

Problem Description
---------------------------------------------------
We replicate an iSeries Multi-Member table to a Teradata target. We COLMAP the member name to the target. We do this successfully in 12.1.2.1.5. We are upgrading to 12.3.0.1.2 and this no longer works.

According to the 12.3 documentation, we should be able to use (*ALL)
https://docs.oracle.com/goldengate/c1230/gg-winux/GGHDB/understanding-whats-supported-ibm-db2-i.htm#GGHDB-GUID-FCB50797-BAD7-4AC5-A779-58E25FB78576

We see this Warning in the RPT file:
2018-05-04 17:09:30 WARNING OGG-10173 (rsnsd1mm.prm) line 70: Parsing error, parameter [map] has unrecognized keyword or extra value "(*ALL)".

we are not getting the full Table Name in our COLMAP.

12.1 map and result:
map XXXX/XXXX(*ALL), target XXXX.XXXX, colmap (usedefaults, row_updt_tms=@DATENOW(), row_stat_cd='I', member_name= @GETENV ('GGHEADER','TABLENAME'))

XXXX/XXXX(CO18050714)

12.3 map and Result:
map XXXX/XXXX(*ALL), target XXXX.XXXX, colmap (usedefaults, row_updt_tms=@DATENOW(), row_stat_cd='I', member_name= @GETENV ('GGHEADER','TABLENAME'))

XXXX/XXXX


Why does 12.3 Fail, when the documentation indicates it should work the same?

Changes

 

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
Changes
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.