Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    30

    Unhappy Unanswered: How to Prune "db2rhist.asc" file

    Hi All

    I am working on db2 8.1 FP4 for AIX - 5l,
    I want to know how to prune the history file as it is continously growing I am doing weekly reorg which causes this file (db2rhist.asc) to grow. The application is of warehouse.

    I tried to prune with the command
    prune history <timestamp>
    but the size of the file was not decreased.

    I also tried to stop/start the db/instance but no luck, the size of the file is still the same.

    Is there any settings in db where one can restrict it , if so Please let me know.

    Appreciated Quick response.

    Cheers,
    Push

  2. #2
    Join Date
    Mar 2004
    Posts
    448
    This is dbm parameter

    REC_HIS_RETENTN

    use update dbm cfg using REC_HIS_RETENTN <no of days>

    regards,

    mujeeb

  3. #3
    Join Date
    Jun 2009
    Posts
    1

    Update db cfg

    Hi

    Sorry, but is not Update dbm cfg , insted of that, user
    update db cfg for <database alias> using REC_HIS_RETENTN <# of days>

    BR

    R FErronato

  4. #4
    Join Date
    Jun 2009
    Posts
    1
    You can try this command :

    PRUNE HISTORY <timestamp> WITH FORCE OPTION

    If "with force option" is not specified, all entries from the backup image forward will be maintained in the history. You mentioned that's warehouse database, so I guess you didn't take backup for a while, So even though you issued prune command, but those records still remain in the history file.

Posting Permissions

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