Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2010
    Posts
    1

    Unanswered: recoverying a database to an early point of time not working

    hi all,
    I did these steps in my test envrionment:
    1) db2 backup db sample online to d:\db_backup include logs
    // the image is 20101217152834
    // the log s***12.log is included in the image.
    2) db2 insert into test values(‘abc’, 20)
    3) db2 restored db sample from d:\db_backup taken at 20101217152834 logtarget d:\temp
    //the log s***12.log is extracted to the d:\temp
    4) db2 rollforward db sample to 2010-12-17-15.00.00 overflow log path (d:\temp) and stop

    then I tested the restored db. I find the new record ('abc', 20) is stored in the test. I suppose this record is removed after a restore operation.
    I find the s***12.log and the current active log s***13.log is processed for in the restore operation.

    I just want it process the included log and restore back to an early point of time? Any suggestions why it does not work?
    byt i am using db2 v8.1

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    The ROLLFORWARD command assumes the timestamp is in UTC, unless you specify USING LOCAL TIME.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Quote Originally Posted by shoujs View Post
    I just want it process the included log
    The time is in UTC as n_i said or you can do:

    3) db2 restored db sample from d:\db_backup taken at 20101217152834 logtarget d:\temp
    3a) remove all logs from the active log dir (move them somewhere else or delete if they're not needed)
    4) db2 rollforward db sample to end of logs overflow log path (d:\temp) and stop

Posting Permissions

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