Results 1 to 3 of 3

Thread: history file

  1. #1
    Join Date
    Oct 2007

    Unanswered: history file

    list history command gives error saying
    history file damaged,

    db2rhist.asc, and db2rhist.bak file both are accessible and also there free space available in file system, even the ulimit -a is set to unlimited,
    have full permissions in this file.

    but still list history or db_history is not working giving error say history file damaged.

    Want to recover the old history info is possible with restoring from the backup images i mean any other was to recover the same.


  2. #2
    Join Date
    Apr 2008
    paste the output of db2level and exact error message to look further on your issue.

  3. #3
    Join Date
    Aug 2008
    Are you getting a SQL2161n error? First, option is to attempt to recover it .Second , you can easily create a new one -
    SQL2161N A damaged recovery history file could not be fixed. - DBA DB2

Posting Permissions

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