Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2005
    Posts
    12

    Unanswered: Restore with ROLL FORWARD to a new DB

    I need to restore a DB2 UDB Database to a different server on a new database (same name as the original one). I've tried copying all the logs and the backup to the correspondind directories in the new server. I've also copyed SQLLOGCTL file but it doesn't work. Restore is successful but the DB remains in ROLL FORWARD PENDING status.

    Any suggestion?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Please specify DB2 version and OS.

    Are you issuing the ROLLFORWARD command?

    You should also be able to take an offline backup and
    restore that and no rollforward needed.

    Andy

  3. #3
    Join Date
    Oct 2005
    Posts
    12
    DB2 V8.

    We know how to do it with an offline copy, but our DB2 subsystem is 24x7. We can't disconnect every application to run an offline copy... We do need to restore an online copy and roll forward up to a specific point in time...


    Thanks anyway..

  4. #4
    Join Date
    Jun 2003
    Location
    Chennai
    Posts
    26

    rollforward - examples.

    db2 "restore db test taken at <backup time stamp - example 20041204190658> with 2 buffers buffer 2048 without prompting"

    #After restoring u can always look for minimum point in time recovery using the below query - means you can only rollforward later than the given time.

    db2 rollforward db test query status

    db2 "rollforward db test to <the time stamp you want to rollforward - example 2004-12-11-19.00.00.000000> and complete


    NOTE: You should always have your archived logs to rollforward and userexit program running.

    In v8.2 onwards the backup will also have the logfile to rollforward. To have more idean on this read online IBM doc - http://publib.boulder.ibm.com/infoce...help/index.jsp
    MS

Posting Permissions

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