DB2 PRUNE HISTORY
Posted by: DBA DB2,
on 26 Jul 2011 |
View original | Bookmarked: 0 time(s)
Use PRUNE HISTORY Command to delete history file entries1) Consider using if : The history file becomes excessively large2) Consider using if: Retention period is high3) Do not Delete db2rhist.asc or db2rhist.bak4) Do a proper analysis of restore requirements prior to PRUNE HISTORYExample :Prior to the PUNE HISTORYI execute the command :PRUNE HISTORY 20110701 This removed all entries for restores, loads, tables space backups and full database backups...