Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Posts
    288

    Unanswered: Removing db2tschg.his file

    Running DB2 V9.7 Enterprise Edition on Windows. db2tschg.his file is 6 GB in size and I would like to remove it.

    I have read that it can be deleted and a new file will be generated (much like renaming the DB2Diag.log)

    here is the article: http://www-01.ibm.com/support/docvie...id=swg1IY86984

    Can this file just be renamed and moved on the fly with the instance running???

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    Why not use the 'prune history ... and delete logfile prior to .....' to delete old entries from this file - it needs to be maintained by regular pruning.

    Do not use rename/delete of this file if you can easily avoid it.

    Choose a log file name that you know you will never need to rollforward from.
    Remember that this file will be in backup-images so will get replaced on restore-database actions.

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    It's better to use PRUNE HISTORY command for that.
    I'd recommend to use it first...
    Regards,
    Mark.

Tags for this Thread

Posting Permissions

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