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
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.