Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Antony_05
Contributor III
Contributor III

How the Timestamp is getting created in Kafka messages

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

Labels (1)
1 Solution

Accepted Solutions
SwathiPulagam
Support
Support

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

View solution in original post

3 Replies
SwathiPulagam
Support
Support

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
Specialist II
Specialist II

@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
Contributor III
Contributor III
Author

Hi Team,

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

Thanks and Regards,

Antony S