Db2- GETENV('RECORD','TIMESTAMP') Return Incorrect Timestamp with Db2 v11

(Doc ID 2289857.1)

Last updated on AUGUST 23, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.10 to 12.1.2.1.10 [Release 12.1]
IBM z/OS on System z

Symptoms

When using the following statements to generate user token in extract:

 Table P1.CUSTOMER_ACCOUNT,
  TOKENS (tk_dbrec_timestamp = @GETENV('RECORD','TIMESTAMP'));

it works fine. The system environments are:
z/OS 1.3
DB2 v10 NFM
Golden Gate 12.1.2.0.4 20440913 21124385

On upgrade to DB2/GG 

DB2 V11 CM
Golden Gate 12.2 (and even with 12.1.x)
found out token value from @GETENV('RECORD','TIMESTAMP') is incorrect: 1899-12-31 19:00:00.000000

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms