Hi All

I am working on db2 8.1 FP4 for AIX - 5l,
I want to know how to prune the history file as it is continously growing I am doing weekly reorg which causes this file (db2rhist.asc) to grow. The application is of warehouse.

I tried to prune with the command
prune history <timestamp>
but the size of the file was not decreased.

I also tried to stop/start the db/instance but no luck, the size of the file is still the same.

Is there any settings in db where one can restrict it , if so Please let me know.

Appreciated Quick response.

Cheers,
Push

This is dbm parameter

REC_HIS_RETENTN

use update dbm cfg using REC_HIS_RETENTN <no of days>

regards,

mujeeb

Hi

Sorry, but is not Update dbm cfg , insted of that, user
update db cfg for <database alias> using REC_HIS_RETENTN <# of days>

BR

R FErronato

You can try this command :

PRUNE HISTORY <timestamp> WITH FORCE OPTION

If "with force option" is not specified, all entries from the backup image forward will be maintained in the history. You mentioned that's warehouse database, so I guess you didn't take backup for a while, So even though you issued prune command, but those records still remain in the history file.