Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001
    Posts
    2

    Unanswered: roll forward database 2106-02-06-06.28.15.000000

    SQL1266N Database "TEST" has been rolled forward to
    "2106-02-06-06.28.15.000000", which is past the specified point-in-time.

    db2 => rollforward database TEST to 2106-02-06-06.28.15.000000 and stop

    ************************************************** ****
    I got this error. any ideas? thanks

    SQL1262N The point-in-time specified for rolling forward database "test" is
    not valid.

  2. #2
    Join Date
    Dec 2001
    Location
    Sao Paulo - Brazil
    Posts
    6
    You should try issuing this command as it is the last commited transaction you'd have,

    db2 => rollforward database TEST to 2001-12-04-19.39.07.00 and stop

    since it is in this following warning message

    SQL1266N Database "TEST" has been rolled forward to
    "2106-02-06-06.28.15.000000", which is past the specified point-in-time.
    Rollforward Status

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

    Node number = 0
    Rollforward status = DB working
    Next log file to be read = S0000003.LOG
    Log files processed = -
    Last committed transaction = 2001-12-04-19.39.07.000000

  3. #3
    Join Date
    Mar 2003
    Posts
    343
    I'm not sure I understand what the timestamp is (I am aware that it is CUT) - why are you trying to rollforward to the year 2106?

    If you are trying to determine the minimum point in time to rollforward to, specify a date before the backup - the database will return the minimum point in time to rollforward to. Use that timestamp in the rollforward command. Or if you want to rollforward through all logs, then specify that - ie rollforward database <dbname> to the end of logs and stop <<-- check syntax in manual.

Posting Permissions

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