Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Replication Capture Problem

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


  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11


    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts