在使用IBM Q REPL同步DB2数据库表至oracle中，遇到问题ccd表的时间字段和现有时间相差8个小时http://www.cndba.cn/hbhe0316/article/108016

解决方案：
https://www.ibm.com/docs/en/idr/11.4.0?topic=server-ibmqrep-applyparms-table

db2 connect to dbname
db2 "update apply.IBMQREP_APPLYPARMS set LOGMARKERTZ='LOCAL'"

关于LOGMARKERTZ字段解释：默认为Greenwich时间，需要修改为系统时间。
Data type: CHAR(8); Nullable: No, with default
A value that determines the time zone that the Q Apply program uses when it inserts source commit data into the IBMSNAP_LOGMARKER column of consistent-change data (CCD) tables or point-in-time (PIT) tables.http://www.cndba.cn/hbhe0316/article/108016

GMT (default)
Q Apply records the source commit timestamp in Greenwich mean time.

LOCAL
Q Apply inserts the source commit timestamp in the local time of the Q Capture serverhttp://www.cndba.cn/hbhe0316/article/108016http://www.cndba.cn/hbhe0316/article/108016http://www.cndba.cn/hbhe0316/article/108016

版权声明：本文为博主原创文章，未经博主允许不得转载。

DB2