Hi All,
My db db2V9.5,Aix 5.3
I have a question regarding the Recovery History File.
when i did a:
list history backup all for db <database_name>

i am seeing only information realated to restores and offline database backups and the online backup entries i am seeing are from after last offline backup.
for example:
if i took offline backup on sep 1st
i am able to see the online backups entries after sep 1st.
i am seeing restore entries even from 2007 november.
but i am not able to see the online backup entries before sep 1st even though we took online backups.
i am seeing the offline backups taken before sep 1st
and we have (REC_HIS_RETENTN) = 366
(NUM_DB_BACKUPS) = 365
and we almost take full online backup every day.

why i was not able to see the online backup entries in Recovery History file which were taken after an offline backup?

any help is appreciated

Thanks

I would be curious to see what you get from using SQL to query the Admin View:

http://publib.boulder.ibm.com/infoce.../r0022351.html


I find that reading the output of LIST HISTORY very difficult. But seeing it in tabular form from a query is much easier.

Andy