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

capture doesn't work properly

P: n/a
Hello.

W2K, db2 v7, FP10a.

Before now our replication worked properly. But some days ago capture
suddenly stopped loggin and filling cd tables without any messages. The last
message was like this:
--
2004-03-03-09:17:36 ASN0105I: Data that has been copied was pruned from the
change data table ASN.IBMSNAP_UOW at SEQ = 00000000006EFDC2DB55 for 2
ROWS and the unit-of-work table.
--
Capture is started and stopped successfully but now it doesn't fill cd
tables.
After a warm start of capture the last message in ccp log table is like
this:
--
2004-03-03-15:48:40 ASN0103I: The Capture program started with SERVER_NAME
ABONCRK; the START_TYPE is WARMNS STARTSEQ=00000000006EFE53EB30; the
TERM_TYPE is ; the PRUNE_TYPE is PRUNE.
--
I tried a cold start of capture and our replication worked fine some days,
but today it happened again.
What shall I do?

P.S. We use userexit routine. I noted that after warm start of capture
userexit get retrive command, and 1 logfile appears in the active log path.
But other retrive commands don't send to userexit and I see the gap in
numbering between this log file and other active log files. After stopping
capture this log file disappears from active log path.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.