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 v8.1.0.89", "special_15295", "U800790_15295", and
FixPak "9".
Product is installed at "/opt/IBM/db2/V8.1".
Thanks