Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Posts
    2

    Lightbulb Unanswered: Archive log suppression

    Dear

    We have a server with around 20 DB2 databases on it. They are all running in archive mode , so Online backups are possible and are being made daily.

    However , every week we also make an offline backup. Since I'm new to DB2 I'm not sure that I can delete the \ARCHIVELOG directory after such a offline backup.

    So : Can I delete all the archivelogs (not circulars) of a certain database after making an offline backup, and then still be able to fully restore it without the archivelogs ?

    Sorry if this questions is stupid , but I'm completely new to DB2

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    an offline can always be restored without logfiles
    the restore is valid till the point of the offline backup
    if rollforward is needed, to recover as much as possible the pogs are needed
    if online backup is taken, specify : include logs
    log files needed for this restore are included in the backup image
    otherwise the restore is unusable if log files are unavailable
    db is in rollforward mode pending
    always keep the log files as long as possible to be able to rollforward and recover as much as possible
    move them to tape- or other disk/filesystem...
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Apr 2007
    Posts
    2
    Thanks a lot ! You've made it clearer

Posting Permissions

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