After switching post mode from STP to MTP an out of sync is being reported.
The event log shows the following:
"Out of sync: table - "KBLOAD"."DL_LOG" (rid:AAIZSBAAWAABWEEAAA) [sp_opst (for o.SPLX402-o.DB402 queue aixdb2)/16022]
Out of sync: table - "KBLOAD"."DL_LOG" (rid:AAIZSBAAWAABWEEAAA) [sp_opst (for o.SPLX402-o.DB402 queue aixdb2)/16022]"
There was an issue in 5.1.x where Shareplex was reporting a false out of sync.
There was an issue in 5.1.x where Shareplex was reporting a false out of sync. This has been addressed in Shareplex 5.3.x. To check whether a false out of sync is being reported, please do the following:
Post process will go into recovery when the data in the queue does not match the data in the shareplex_trans table. This table is updated regularly during the normal running of the process. Post process will update this table during the check pointing. When the queue sequence number in the shareplex_trans table does not match the data in the header file of the queue, post will go into recovery state and discard the messages until the data in the header file and the shareplex_trans table match. Normally there should be no data loss.
Please check for the rowids from the source (table names are provided as well)
Based on the Primary Key on the source, check the data on the target to see if it is in sync.
KBLOAD"."DL_LOG" (rid:AAIZSBAAWAABWEEAAA)
