Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2010

    Unanswered: Restoring an Online Backup with "include logs" option

    Hello folks,

    in our environment we are backuping up several database with the option

    db2 "backup database sample online compress include logs without prompting"

    the db cfg for logpath says -->
    Path to log files = /ibm/db2/home/db2inst1/sample/NODE0000/SQL00010/LOGSTREAM0000/

  2. #2
    Join Date
    Jan 2010
    what is the restore command for my backup which has been created like this?

  3. #3
    Join Date
    Jan 2003
    Provided Answers: 5
    You will need to use the LOGTARGET and NEWLOGPATH options in the restore command. See the manual for more information.


  4. #4
    Join Date
    Jan 2009
    Zoetermeer, Holland
    The "included logs" are a kind of safety net. When you manage your logs normally you will not need those logs included in your backup-image. Only when you are struggling with the log files or you need to restore a very old backup-image you can be very happy those included logs.
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Posting Permissions

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