DB2 Replication 2004-08-13 - By Anuj Kumar
Back
<P>
<BR>
Hi All,<BR>
<BR>
I'm sorry to mention DB2 problem coz this gruop belongs to J2ee.<BR>
I hope i'll get some help .<BR>
<BR>
I'm trying to replicate db2 Databases .<BR>
i'm using DB2 version 8.1.<BR>
<BR>
I'm not able to run the Capture program.<BR>
<BR>
and if i look at IBMSNAP_CAPTRACE table in the souce server i get this
exception <BR>
<BR>
<BR>
ASN0005E CAPTURE "ASN". The Capture program encountered an
error when reading the DB2 log. The log sequence number is "0000
:0000:0000", the SQLCODE is "-2651", and the reason code is "
;".<BR>
<BR>
ASN8008D "Capture" : "ASN" : "Destroyed"
IPC queue with key(s) "(OSSEIPC0tempDB2.SOURCE1.ASN.CAP.IPC,
OSSEIPC1tempDB2.SOURCE1.ASN.CAP.IPC, OSSEIPC2tempDB2.SOURCE1.ASN.CAP.IPC)"
.<BR>
2004-08-13-12.00.02.847000 <_asnCapture> ASN0008I CAPTURE "ASN
". The Capture program was stopped.<BR>
<BR>
<BR>
and on the destination side where my apply program is running if i look into
IBMSNAP_APPLYTRACE table i get this warning<BR>
<BR>
2004-08-13-12.10.42.583000 <CPCCI(C0/05)> ASN1064W APPLY "QUAL
". The Apply program cannot perform a full refresh for the subscription set
named "SETNAME", because the Capture program for this source has not
yet been cold started.<BR>
<BR>
This is understood because when capture program is not started it can't refersh
....<BR>
<BR>
can anybody help me out or advise me ?<BR>
Thanks and regards,<BR>
Anuj
</P>
<br><br>
<A target="_blank" HREF="http://clients.rediff.com/signature/track_sig.asp">
<IMG SRC="http://ads.rediff.com/RealMedia/ads/adstream_nx.cgi/www.rediffmail.com
/inbox.htm@(protected)" BORDER=0 VSPACE=0 HSPACE=0></a>
===========================================================================
To unsubscribe, send email to listserv@(protected) and include in the body
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".
<p>
�
Hi All,
I'm sorry to mention DB2 problem coz this gruop belongs to J2ee.
I hope i'll get some help .
I'm trying to replicate db2 Databases .
i'm using DB2 version 8.1.
I'm not able to run the Capture program.
and if i look at IBMSNAP_CAPTRACE table in the souce server i get this
exception
ASN0005E CAPTURE "ASN". The Capture program encountered an error when reading
the DB2 log. The log sequence number is "0000:0000:0000", the SQLCODE is "
-2651", and the reason code is "".
ASN8008D "Capture" : "ASN" : "Destroyed" IPC queue with key(s) "
(OSSEIPC0tempDB2.SOURCE1.ASN.CAP.IPC, OSSEIPC1tempDB2.SOURCE1.ASN.CAP.IPC,
OSSEIPC2tempDB2.SOURCE1.ASN.CAP.IPC)".
2004-08-13-12.00.02.847000 <_asnCapture> ASN0008I CAPTURE "ASN". The Capture
program was stopped.
and on the destination side where my apply program is running if i look into
IBMSNAP_APPLYTRACE table i get this warning
2004-08-13-12.10.42.583000 <CPCCI(C0/05)> ASN1064W APPLY "QUAL". The Apply
program cannot perform a full refresh for the subscription set named "SETNAME",
because the Capture program for this source has not yet been cold started.
This is understood because when capture program is not started it can't refersh
....
can anybody help me out or advise me ?
Thanks and regards,
Anuj
===========================================================================
To unsubscribe, send email to listserv@(protected) and include in the body
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".
|
|
