-
Title
SharePlex CDC does not capture key column value during update -
Description
After CDC is implemented on a tracking table , when an update operation is done only the column updated is recorded , but would like to have the key column value also to be recorded. -
Cause
SharePlex issue with CDC table missing value in the key column
-
Resolution
STATUS: Fixed in SharePlex version 8.6.5 and higher through ST111353
WORKAROUND:
1. If you are on 8.6.3 or 8..6.4, patch to 8.6.5 which has fix ST111353 for the missing key issue for update when SP_OPO_TRACK_PREIMAGE=0 for CDC replication
2. If you also want unchanged column value for update to show up in after image, please do the following in addition to patching to 8.6.5:
a. Enable supplemental logging on all columns on source for the related table
b. set below parameters on source:
Sp_ctrl> Set param SP_OCT_INCLUDE_UNCHANGED_COL 1
Sp_ctrl> set param SP_OCT_USE_SUPP_KEYS 1
If you have SP_OPO_TRACK_PREIMAGE set to 1 and you are on 8.6.3 and 8.6.4, then you are not affected by this product defect.