PM78781: QREPLICATION OLDEST_TRANS VALUE SOMETIMES HAS INCORRECT VALUE.

APAR status

• Closed as program error.

Error description

• Qreplication sometimes stores wrong value into Oldest_Trans
  column in the applymon table.
  

Local fix

Problem summary

• 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.
  

Problem conclusion

• 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.
  

Temporary fix

Comments

• fix is contained in PTF UK80762 (APAR= PM66551)
  defect wsdbu01058557
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  PM78783

Modules/Macros

• ASN
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• R910 PSY

     UP