Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: online backup question

    db2 v8.2 fix pak 10 aix 5.2

    our database is on archive mode and during the batch job archive log directory became full and for few hours transfering logs from active logs to archive logs failed (in db2diag.log we got so manay massages as unsucessful loging into archive directory) is that mean we lost some logs? should we take a offline backup ASAP?

    please advise?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    It is unlikely you would have lost any logs .. AFAIK, if the archive of a log file fails, it is retried ... You will be able to see this info in the logs. Also, check the log file directory is any of them are missing.

    If you are unsure, yes, taking a full backup will help .. Even an online backup is OK

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by sathyaram_s
    It is unlikely you would have lost any logs .. AFAIK, if the archive of a log file fails, it is retried ... You will be able to see this info in the logs. Also, check the log file directory is any of them are missing.

    If you are unsure, yes, taking a full backup will help .. Even an online backup is OK

    Cheers
    Sathyaram
    Thank you so much Sathyaram, your comment was helpful

Posting Permissions

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