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