Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    30

    Unanswered: Question regarding Recovery History File

    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
    Last edited by dareman123; 10-08-08 at 21:51.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •