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.
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.
