db2 does not remove archived log files

[Pierre Saint-Jacques]

Those two parameters are used by DB2 to track life of info. in the
rechist file.
The developpers WILL NOT erase any of your backups and/or log files.
They don't want us on the phone saying:" The system ate my files..."

So, NUM_DB_BACKUPS is a parm. that tells DB2 to track five active
backups and identify the previous ones as inactive or useless. They can
still be used to recover if you have the logs to roll forward. It is
just a tracking number that will take no delete action on anything.

And, REC_HIS_RETENTN set to five days tells DB2 to PRUNE the rechist
file of entries older than five days. Again, here you loose the
reference to the info. as it is deleted. But, if you still have the
images (and their corresponding log files) you could stil use them to
recover.

If you back up every day NUM_DB_BACKUPS set to five makes sense. BTW,
they are full db backups, not tblsp. backups. However, since the
recovery history file goes in the image, you may want to set the
REC_HIS_RETENTN to 30 or 60 days. This way, if you bust your system,
you can still recover only the history file and have 30 or 60 days of
tracking info. without having it wiped off. This is very important if
you go to a mix of db or tblsp backups which are mixed as full,
incremental and/or delta. This info over 30 or 60 days in the history
file is hellpful in determining the sequence of images to be applied in
recovery.

HTH, Pierre.

news.aon.at wrote:

> Hi!
> I set USEREXIT database configuration parameter to NO and LOGRETAIN
> parameter to RECOVERY. Then i did the offline backup of the database and
> configured the online backup to backup the database every day.
> Database configuration parameters REC_HIS_RETENTN is set to 5 (days) and
> NUM_DB_BACKUPS is set to 5.
> The article
> http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document
> .d2w/report?fn=db2hae71db2ha22.htm#HDRSEXITDB tells me:
> "DB2 removes archived log files from the active log path when these log
> files are no longer needed for recovery. "
> In my configuration i thought that DB2 should remove the log files older
> then 5 days and should not keep more the 5 online backups. But DB2 never
> removes the log files and the online backups.
>
> Do I have to configure another parameter so that DB2 knows that there are
> log files and backups to remove?
> Do I have to tell DB2 that there are log files and backups no more needed
> through a userexit program? If so, how?
>
> Thanks in advance!
>
> Thomas
>
>
>
>
>
>
>
>
>