I just restored a database which was backed up about a month ago. It had replication running. Now when I try to start replication on the new server where I restored the database I get this error:
ASN0005E CAPTURE "ASN" : "WorkerThread". The Capture program encountered an error when reading the DB2 log. The log sequence number is "0000:0000:023B:ED93:6B3C", the SQLCODE is "-2657", and the reason code is "".
The log it is looking for has been deleted. Is there a way to tell replication to start with the current log? I see the MIN_INFLIGHTSEQ in ASN.IBMSNAP_RESTART.
If it can't be reset, will I need all the logs from the past month?
DB21085I Instance "db2inst2" uses "64" bits and DB2 code release "SQL08022"
with level identifier "03030106".
Informational tokens are "DB2 v18.104.22.168", "special_15295", "U800790_15295", and
Product is installed at "/opt/IBM/db2/V8.1".
the gap is too large
try to start capture with cold : will force a full refresh
and then force offline load (but do not unload/reload) just to synch again
from replication center
there is a column in capture setting that can resolve the large gap
see replication guide or infocenter online
if large gaps, log files should be avialable from that moment in time.
otherwise force cold..
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be