Hi, I have configured table mappings with live audit enabled for timestamp. The replication method is MIRROR.


The timestamp is always yyyy-mm-dd hh:mm:ss.000000000000
The milliseconds is always 000000000000 for transactional record.

The initial records are fine. They show timestamp like yyyy-mm-dd hh:mm:ss.025000000000

Source is DB2.

Anyone knows the reason why?

#DataIntegration
#DataReplication

Hello,

According to this Knowledge Center topic, for Db2 sources, when mirroring data, the timestamp contains the date and time when you write the data to the source table. When refreshing data, the timestamp contains the date and time of when CDC Replication refreshed the first row. As a result, the precision may differ between mirroring and refreshing.  The precision for mirroring for Db2 is seconds. This technote lists the precision for various source databases.

Best regards,
Sarah
IBM Data Replication

------------------------------
SARAH ORVIS
------------------------------