PM78781: QREPLICATION OLDEST_TRANS VALUE SOMETIMES HAS INCORRECT VALUE.
Closed as program error.
Qreplication sometimes stores wrong value into Oldest_Trans column in the applymon table.
A heartbeat message might contain a current log time of 0 if the heartbeat interval expires before the logreader has published the first transaction or hit end of log.
If Q Apply receives 0, it will store the MQ put time as OLDEST_TRANS to prevent the value going backwards. However the MQ put time may be higher than some transactions yet to be published. By suspending heartbeat messages until an appropriate log time can be sent, this ensures OLDEST_TRANS is always accurate.
fix is contained in PTF UK80762 (APAR= PM66551) defect wsdbu01058557
Reported component name
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
Fixed component ID
Applicable component levels