• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1013
  • Last Modified:

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".

0
sy_geoffrey
Asked:
sy_geoffrey
  • 3
  • 2
2 Solutions
 
momi_sabagCommented:
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_sabagCommented:
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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now