LUW SQL Replication - IBMSNAP_LOGMARKER scale

Reidar Jorgensen

LUW SQL Replication - IBMSNAP_LOGMARKER scale

I'm having trouble processing change data provided by SQL Replication because I'm getting multiple records with the same LOGMARKER timestamp.  In z/OS, the LOGMARKER column (in IBMSNAP_UOW) is defined with scale=6, so it has the time down to microseconds, but in LUW, the scale is 0, and it only goes to whole seconds.

Is this a system setting?  Can the scale in LUW be changed to give a more accurate timestamp?

Greg Palgrave

RE: LUW SQL Replication - IBMSNAP_LOGMARKER scale
(in response to Reidar Jorgensen)

Db2 LUW 10.5 on Linux here, and it seems fine.

db2 describe table IBMSNAP_UOW
                                 Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
...
IBMSNAP_LOGMARKER SYSIBM TIMESTAMP 10 6 No
...


db2 "select IBMSNAP_LOGMARKER from IBMSNAP_UOW "

IBMSNAP_LOGMARKER
--------------------------
2018-05-14-19.44.26.000000

 

Could it be that the output is being formatted/disguised by whatever tool you are using to view it?

 

Cheers

Greg

 

In Reply to Reidar Jorgensen:

I'm having trouble processing change data provided by SQL Replication because I'm getting multiple records with the same LOGMARKER timestamp.  In z/OS, the LOGMARKER column (in IBMSNAP_UOW) is defined with scale=6, so it has the time down to microseconds, but in LUW, the scale is 0, and it only goes to whole seconds.

Is this a system setting?  Can the scale in LUW be changed to give a more accurate timestamp?