470,618 Members | 1,701 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,618 developers. It's quick & easy.

Can not initialize a full refresh (SQL replication) on the apply side

Hello

I tried to do an initial full refresh but I failed - nothing happens
(no error at all). Apply works without errors. Details of my
environment:

I have the following replication scenario: DB2 UDB apply is running on
a Solaris machine (DB2 Version 8, fixpack 9a), capture on a z/OS
machine (host).

On the z/OS machine, the column values of the column "DISABLE_REFRESH"
for all source tables are set to 0 therefore allowing a full refresh.

I successfully updated the ASN.IBMSNAP_SUBSET table on the apply side
as followed (as suggested by the Replication Center while performing an
automatic full refresh):

CONNECT TO TESTDB;
UPDATE ASN.IBMSNAP_SUBS_SET SET ACTIVATE=0 WHERE SET_NAME='S_TEST' AND
APPLY_QUAL='A_TEST' AND WHOS_ON_FIRST='S';

UPDATE ASN.IBMSNAP_SUBS_SET SET LASTSUCCESS=NULL, SYNCHPOINT=NULL,
SYNCHTIME=NULL WHERE APPLY_QUAL='A_TEST' AND SET_NAME='S_TEST' AND
WHOS_ON_FIRST='S';

UPDATE ASN.IBMSNAP_SUBS_SET SET ACTIVATE=1 WHERE SET_NAME='S_TEST' AND
APPLY_QUAL='A_TEST' AND WHOS_ON_FIRST='S';
COMMIT ;

Then - after checking that all above COLUMNS are set to the above
values - I successfully started the apply but the full refresh didn't
take place. Logfile:

2006-01-24-16.15.30.394515 <CPCIMPC(08/07)> ASN1045I APPLY "A_TEST" :
"Initial". The Apply program was started using database "TESTDB".

2006-01-24-16.15.31.038834 <CPREST(01/00)> ASN1044I APPLY "A_TEST" :
"WorkerThread". The Apply program will become inactive for "0" minutes
and "50" seconds.
....

2006-01-24-16.34.21.725226 <CPREST(01/00)> ASN1044I APPLY "A_TEST" :
"WorkerThread". The Apply program will become inactive for "2" minutes
and "0" seconds.

There were no errors in the apply logfile and checking the
ASN.IBMSNAP_APPLYTRAIL shows that no rows were inserted or deleted in
the target tables.

I checked the host side (where capture is running): the tables are not
empty.

Does anybody have an idea why the initial full refresh doesn't take
place?

Thank you very much for your help

With kind regards

John

Jan 24 '06 #1
0 1386

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by randi_clausen | last post: by
5 posts views Thread by Odd BjÝrn Andersen | last post: by
3 posts views Thread by Gert van der Kooij | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.