Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2007
    Posts
    26

    Unanswered: db2 history file

    Hi all

    Where the db2 History file located in AIX
    how can we recover that history file if it is corrupted.

    I have idea we can recover that history file from backup image
    is there any way from AIX team


    Thanks and Regards

    V.V.Prasad

  2. #2
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    I found it in Information Center:

    The history file is individually restorable from any backup image. If the current database is unusable or not available, and the associated recovery history file is damaged or deleted, an option on the RESTORE command allows only the recovery history file to be restored. The recovery history file can then be reviewed to provide information on which backup to use to restore the database. For example, you can restore the history file for the sample database with this command:

    db2 restore database sample history file

    Hope it will help
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  3. #3
    Join Date
    Nov 2007
    Posts
    26
    thanks Markham

    tell me the path of the history file

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Jul 2010
    Posts
    1

    Path to history file

    I found one of history file at DB2\NODE0000\SQL00001...

Posting Permissions

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