IBM Support

What is the precision of &TIMSTAMP?

Question & Answer


Question

What is the precision of &TIMSTAMP (Record Modification Time) journal control field when mirroring?

Cause

The precision of &TIMSTAMP journal control field depends on the source database type. The precision is as high as technically possible given the content of a transaction log.

Answer

  • Db2 LUW source - seconds only precision.
  • Oracle database source - seconds only precision.
  • Sybase source - precision of 1/300 of a second.
  • Microsoft SQL Server source - milliseconds precision.
  • Db2 for i source - microseconds precision.

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSX3HK","label":"InfoSphere Change Data Capture"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
11 December 2019

UID

swg21599578