Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    138

    Unanswered: Rollforward problem

    db2 version : 7.1 fixpaxk 7
    Platform : AIX

    I have a DR db which is always in rollforwrad pending state. I have a cronjob running which extracts the logs from TSM and applies to it regularly. Now I am getting an error that

    SQL1265N The archive log file "S0001413.LOG" is not associated with the
    current log sequence for database "WPS" on node "0".

    when I tried to apply the logs.
    -------------------------------------------------------------------------
    Rollforward Status

    Input database alias = WPS
    Number of nodes have returned status = 1

    Node number = 0
    Rollforward status = DB working
    Next log file to be read = S0001413.LOG
    Log files processed = -
    Last committed transaction = 2004-09-15-14.19.53.000000


    $db2 "rollforward db WPS to end of logs overflow log path(.)"
    SQL1265N The archive log file "S0001413.LOG" is not associated with the
    current log sequence for database "WPS" on node "0".


    --------------------------------------------------------------------------
    what's the solution?
    Last edited by chavadb2; 09-16-04 at 11:18.

  2. #2
    Join Date
    Aug 2004
    Posts
    138
    no help?

  3. #3
    Join Date
    Aug 2004
    Posts
    138
    well, I took a online backup in prod and restored in DR. That solved it..
    any other solutions?

Posting Permissions

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