The “SQL2161N A damaged recovery history file could not be fixed. The specified action failed” error message , can cause some DBA panic, but can be fixed . Recently I executed the following command db2 PRUNE HISTORY 20120701 --received this error message SQL2161N A damaged recovery history file could not be fixed. The specified action failed. Often, the db2rhist.asc file is damaged when the file system becomes full OR when the file size limit has been reached. Checks I made: 1) db2 prune history 2) db2 list history SQL2161N– (same error as above) I fixed by : a) Removed the... Read more →