Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2010
    Posts
    8

    Unanswered: db2 online db backup & restore

    I am new in db2, i want to take an online backup of db2 database using control center. I have already taken an online backup but i am not sure about copying log files. should i copy them into a new folder after clicking FINISH button of backup operations?

    While restoring db, when i need to paste these log files?

    Should i do this;

    - After finishing restore operations from control center
    - Paste log files on the path mentioned (get db cfg for xxxx)
    - Run rollforward end of logs interface...

    plz guide me, if i m wrong...

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    When doing the backup, use the "INCLUDE LOGS" clause in the command. This will add the necessary logs to the backup image so that all you need to create a working database is the image. Then when you restore, you can extract the logs from the image to the path you want using LOGTARGET and NEWLOGPATH.

    Andy

  3. #3
    Join Date
    Sep 2010
    Posts
    8
    thanks andy... I will try it and let you know if there will be any problem

Posting Permissions

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