How to force a full refresh when the source is an external CCD table

Replication can involve external CCD tables as sources. These tables are not populated by the Capture program.

To initiate a full refresh of external CCD tables, run the following statements after qualifying them so that they update only the intended rows.

1. On the source server:

UPDATE ASN.IBMSNAP_PRUNCNTL
SET SYNCHPOINT = NULL,
SYNCHTIME = NULL,
WHERE SET_NAME = 'setname '
AND APPLY_QUAL = 'applyqualifier '
AND TARGET_SERVER = 'targetdb ';

UPDATE ASN.IBMSNAP_REGISTER
SET CCD_OLD_SYNCHPOINT = X'minimumcommitseqfromtheCCDtable ',
SYNCHPOINT = X'highest commitseqfromtheCCDtable ',
SYNCHTIME = CURRENT TIMESTAMP
WHERE SOURCE_OWNER = 'srclib '
AND SOURCE_TABLE = 'srctable ';


2. On the control server:
UPDATE ASN/IBMSNAP_SUBS_SET
SET LASTSUCCESS =NULL,
SYNCHTIME = NULL,
SYNCHPOINT = NULL
WHERE SET_NAME = 'setname '
AND APPLY_QUAL = 'applyqualifier ';

Finally, start the Apply program.