We have a Datamart on DB2 on Windows. I was asked recently to print the last 2 weeks worth of backup history for one of the databases in the datamart.

I used this command: list history backup all for proddm
Buit this only returned the last 5 entries (5 days worth)

I checked my config file for history retention and it is set like this:
"Recovery","REC_HIS_RETENTN","60","Recovery history retention period"

Luckily, I had logs from the .bat files that call the SQL we use to do the actual backups..

Obviously my history retention is set appropriately ... is there another command I can use to generate backup history reports? Something does not see right..

Did you look at this parm?

Number of database backups to retain (NUM_DB_BACKUPS) = 12

db2 get db cfg for sample