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

Technote (FAQ)


Question

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

Cause

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

Answer

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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere Replication Server
Misc

Software version:

8.1, 8.2

Operating system(s):

Platform Independent

Reference #:

1211787

Modified date:

2011-04-14

Translate my page

Machine Translation

Content navigation