My Oracle Support Banner

XID/TRANSACTIONID Environment Variables Report The Value Correctly Byte Reversed On X64 Intel. (Doc ID 2622976.1)

Last updated on MAY 27, 2020

Applies to:

Oracle GoldenGate - Version 19.1.0.0.3 to 19.1.0.0.3 [Release 12.3]
Linux x86-64

Symptoms

When comparing our upgraded DEV environment to our TEST environment we have noticed:

Oracle GoldenGate 19.1.0.0.4 for DB2 for zOS on AIX, 129.6 MB was applied to DEV

 - STG_PROCESS_DATE timestamp column is now rounding to the second. Is there a setting to disable this so that it does not round off?

DEV:
TLP_NB_ID STG_PROCESS_DATE
9.98011150399513E14 2019-10-29 10:20:02.000000
9.98221142602996E14 2019-10-29 08:42:19.000000
9.98841142849287E14 2019-10-29 10:43:02.000000


TEST:
TLP_NB_ID STG_PROCESS_DATE
9.98011150399513E14 2019-10-29 10:20:02.825120
9.98221142602996E14 2019-10-29 08:42:19.801600
9.98841142849287E14 2019-10-29 10:43:02.852176

 - The length of the GG_XID value has increased from 21 to 23 characters. Is this due to the extract running on a Linux OS now instead of an AIX OS?

GG_XID
400000000057375225034 - (pre-upgrade)
512D310280900006D7ED310 - (post-upgrade)
5127BD427090000CEC07BD4 - (post-upgrade)
2000000000927714DD3AD - (pre-upgrade)
40000000005741D8CF81A - (pre-upgrade)
5120B1D2809000056630B1D - (post-upgrade)

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.