XID/TRANSACTIONID Environment Variables Report The Value Correctly Byte Reversed On X64 Intel.
(Doc ID 2622976.1)
Last updated on APRIL 17, 2023
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 |