How the Timestamp is getting created in Kafka messages

[Antony_05]

Hi Team,

We are replicating data from IBM DB2 z/OS to Kafka where we can see that the timestamp is getting created for all the messages.

Can anyone please let me know to which time does this timestamp points to because in our case for the data getting replicated for today in CDC is showing the timestamp in 2020 (2020-11-09).

Please let me know your thoughts on this.?

Thanks and Regards,

Antony S

[SwathiPulagam · Accepted solution]

Hi  @Antony_05 ,

The timestamp column will populate the replicate server time. If it is not the case please create a support case. It might be a bug in the specific version.

I verified in the latest version and it is populating as expected.

Thanks,

Swathi

[Heinvandenheuvel]

@Antony_05 please expand on what you mean by 'the timestamp'  

The Kafka endpoint has a 'timestamp = The date and time of the metadata message." in  the "Metadata message"  compare this with the variable AR_H_TIMESTAMP. If that's wrong Occam's Razor suggests that the time setting on the Replicate server is wrong. Did you check?

The Kafka endpoint also has a 'timestamp = The original change UTC timestamp. Applicable to CDC operations."  in the "Data message".  Compare this with the variable AR_H_COMMIT_TIMESTAMP. If that's wrong there is a misinterpretation of the change log by the source endpoint driver. Check for ODCB settings, versions and source DB and source DB client software versions.

hope this helps,

Hein

[Antony_05]

Hi Team,

The timestamp seems to be wrong only for few records which got populated for a particular time.

Thanks and Regards,

Antony S