DB2 backup file deletion

My DB2 backups are starting to take up too much space, and I'd like to start pruning some of the older files. In the past I had simply deleted some files, but that led to some issues when trying to use one of the backup files (unfortunately the details escape me).

I read here that I can get DB2 to manage this. I did the following:

db2 update db cfg for db_name using AUTO_DEL_REC_OBJ ON db2 update db cfg for db_name using NUM_DB_BACKUPS 6 db2 update db cfg for db_name using REC_HIS_RETENTN 21

Our backups run twice weekly, so I was thinking I would save 3 weeks worth. After setting these values, I ran a backup:

db2 backup db db_name user username using password online to file_path include logs without prompting

The backup ran correctly and created a new backup file, but none of the existing files were deleted (I have backups more than 21 days old).

As per this link I expected the Auto Delete to occur at the time I ran the backup. My LOGARCHMETH1 is set to USEREXIT.

My questions are:

Why did my previous files not get removed (and what do I need to change to get them to be removed automatically)?

Can I safely remove log files by simply deleting them from the filesystem?

链接地址: http://www.djcxy.com/p/57836.html

上一篇: C＃中的双向1对1词典

下一篇: DB2备份文件删除