Data Replication

Expand all | Collapse all

Live Audit Timestamp

  • 1.  Live Audit Timestamp

    Posted Wed May 27, 2020 02:51 AM
    Edited by Learner Cognos Wed May 27, 2020 03:06 AM
    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?


  • 2.  RE: Live Audit Timestamp

    Posted Wed May 27, 2020 09:41 AM
    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
    ------------------------------