Infinite loop using asnapply in DB2

Hi,

I have a replication setup using IBM DB2 V8.2.
My problem is that when I run ASNAPPLY with COPYONCE=y, the program goes into infinite loop.
Some of my qualifiers work and I've noticed that there is always a pair "F" and "S" for each successful run.

But for one problematic qualifier, after the first "F", the loop repeat itself with the "S" cycle as shown below.

I'll appreciate any help.

Thanks!
Geoff


COMMAND:
asnapply CONTROL_SERVER=DB0001 APPLY_QUAL=DB0001_QMASTER COPYONCE=y APPLY_PATH=c:/ep/db2/capture pwdfile=asnpwd.aut logstdout=y


RESULT ("S" keeps repeating)

2007-10-15-11.31.09.224000 ASN1025I  APPLY "DB0001_QMASTER" : "WorkerThread". Th
e Apply program completed processing for subscription set "DB0001_SMASTER"("S").
 The return code is "0".
2007-10-15-11.31.12.439000 ASN1025I  APPLY "DB0001_QMASTER" : "WorkerThread". Th
e Apply program completed processing for subscription set "DB0001_SMASTER"("S").
 The return code is "0".
2007-10-15-11.31.16.184000 ASN1025I  APPLY "DB0001_QMASTER" : "WorkerThread". Th
e Apply program completed processing for subscription set "DB0001_SMASTER"("S").
 The return code is "0".
2007-10-15-11.31.19.419000 ASN1025I  APPLY "DB0001_QMASTER" : "WorkerThread". Th
e Apply program completed processing for subscription set "DB0001_SMASTER"("S").
 The return code is "0".

sy_geoffreyAsked:
Who is Participating?
 
momi_sabagConnect With a Mentor Commented:
hi
can you open a trace to get the sql statement that the asnapply program executes ?
it will make it easier to understand whats wrong
0
 
sy_geoffreyAuthor Commented:
Hi,

How do you open  a trace?  
Do you add "trcflow" at the end of asnapply, like this?

asnapply CONTROL_SERVER=DB0001 APPLY_QUAL=DB0001_QMASTER COPYONCE=y APPLY_PATH=c:/ep/db2/capture pwdfile=asnpwd.aut trcflow > log.trc

I've checked the log.trc and I cannot find any indication of problems.

Thanks.

0
 
sy_geoffreyAuthor Commented:
Just for reference...

Added something to replicate in one of the DB.  Run ASNAPPLY, and it was able to exit by its own.
Bug?
0
 
momi_sabagConnect With a Mentor Commented:
hi
is this issue still relevant ??
0
 
sy_geoffreyAuthor Commented:
So far, this problem has been solved by adding something to be replicated in the DB.  So closing this issue now.

Thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.