• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Configure DB2 to automatically delete unneeded backup images from history file

dragon

Newcomer
Joined
Jan 6, 2012
Messages
3
Reaction score
0
Points
0
Hi all,

Please sorry, but I am totally new in the area of DB2 backup.
We are using DPF DB2 database v9.7 and EMC Networker (tape system) to store backup images.
I have tried to configure DB2 to automatically prune and update the status of recovery history
file entries, but I have seen that even I have setup these parameters in my db configuration:

db2 get db cfg for test | grep NUM_DB
Number of database backups to retain (NUM_DB_BACKUPS) = 1

db2 get db cfg for test | grep AUTO_DEL
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = ON

db2 get db cfg for test | grep REC_HI
Recovery history retention (days) (REC_HIS_RETENTN) = 0

I haven't seen any kind of automatically pruning of the recovery history file entries for the backup taken on tape (using EMC Networker)
they are still there (I am using SYSIBMADM.DB_HISTORY view), even I have for example 5 (five) online backups for every database partition.

Thanks,
D.
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

DigitalOcean $100 Credit

Support ADSM.ORG and get DigitalOcean FREE credit. DigitalOcean currently offer a $100, 60-day Free Credit for new accounts. Sign-up here:

DigitalOcean Referral Badge

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 20 18.7%
  • Keep using TSM for Spectrum Protect.

    Votes: 65 60.7%
  • Let's be formal and just say Spectrum Protect

    Votes: 13 12.1%
  • Other (please comement)

    Votes: 9 8.4%

Forum statistics

Threads
31,897
Messages
135,988
Members
21,783
Latest member
london
Top