DB2 replication - Apply program not replicating

[almousawi@gmail.com]

I am working on a DB2 replication program that used to work. I ran the
"warm" capture program to get a cold start and I am running the apply
program, but, the apply does not replicate the data. I update a test
table and I see that the CD table gets new rows. But the apply program
does not seem to be doing anything .. I see the asnapply is running,but
not doing anything:

2005-07-31-02:18:03 ASN1045I: The Apply program was started using
database ACVPRE.
2005-07-31-02:18:03 ASN1044I: The Apply program will become inactive
for 5 minutes and 0 seconds.


Any ideas would be appriciated.

Sam

[Mark A]

Re: DB2 replication - Apply program not replicating

<almousawi@gmai l.com> wrote in message
news:1122791617 .121905.94270@f 14g2000cwb.goog legroups.com...[color=blue]
>I am working on a DB2 replication program that used to work. I ran the
> "warm" capture program to get a cold start and I am running the apply
> program, but, the apply does not replicate the data. I update a test
> table and I see that the CD table gets new rows. But the apply program
> does not seem to be doing anything .. I see the asnapply is running,but
> not doing anything:
>
> 2005-07-31-02:18:03 ASN1045I: The Apply program was started using
> database ACVPRE.
> 2005-07-31-02:18:03 ASN1044I: The Apply program will become inactive
> for 5 minutes and 0 seconds.
>
>
> Any ideas would be appriciated.
>
> Sam
>[/color]
What is the status of your subscription sets?

[almousawi@gmail.com]

Re: DB2 replication - Apply program not replicating

I am not sure what is the status ..
1. how do I check the status of the subscription (from Control centre,
when I click on replication subscription, I get "No start database
manager command was issued")

2. Do I need to set it to active? how? what are the things I need to do
before I set it to active?

3. When I run the following query, replication is done successfully
once:
update asn.ibmsnap_sub s_set set lastsuccess = null,synchpoint = null,
synchtime = null where APPLY_QUAL = 'REPGROUP' AND SET_NAME ='REPGRP'
AND WHOS_ON_FIRST = 'S'

thx

[almousawi@gmail.com]

Re: DB2 replication - Apply program not replicating

I am still having the problem (the apply and capture programs are
running, the capture is recording the changes in the CD tables, but the
apply is not replicating). Any clues would be helpful.

Thanks
Sam