By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

DB2 replication - Apply program not replicating

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
<al*******@gmail.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.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

What is the status of your subscription sets?
Nov 12 '05 #2

P: n/a
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_subs_set set lastsuccess = null,synchpoint = null,
synchtime = null where APPLY_QUAL = 'REPGROUP' AND SET_NAME ='REPGRP'
AND WHOS_ON_FIRST = 'S'

thx

Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.