Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    207

    Unanswered: Task Central - How to remove old backups with it?

    Hello Friends,

    My next project is to remove old backups from the local folder.
    By now, I am having a daily job that creates an online backup of my databases and puts it into a local folder.

    Now I want to have an automatism that removes all the backups that are older than 30 days. Is there anyone that has x-perience with that?

    Thanks in advance.

    DB_N00b

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    DB2 can do it for you if you don't need your history longer than 30 days.

    Number of database backups to retain (NUM_DB_BACKUPS) = 30
    Recovery history retention (days) (REC_HIS_RETENTN) = 30
    Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = ON

    These settings will remove Entries in the database Historie after 30 Days. If AUTO_DEL_REC_OBJ is set to ON, DB2 will also remove the files (in the filesystem, in TSM or ...). It will also take care of the archive logfiles and will remove logfiles older than the latest backup.

  3. #3
    Join Date
    Jan 2010
    Posts
    207
    Thanks.
    Thats exactly what i was looking for.

Posting Permissions

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