Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: deleting old logs

    My DB is 8.2 and my desired setup is:
    a) active logs are in active log directory
    b) archive logs are in some other directory

    after online backup with option "include logs" i want to delete logs from archive log directory

    How to setup b) and deleting logs?
    TIA,Zvonimir

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    To set up archiving the logs, set th DB config parameter LOGARCHMETH1. See the online help or the manuals on how to set this. As for deleting them, DB2 provides no method to do this. You have to do it either manually or through some cron type process. Just make sure that you only delete archived logs that are no longer needed. This means that you have to be 100% sure that should a failure occur, and you have to restore the DB from the backup image, that these logs are not needed for rollforward recovery.

    HTH

    Andy

  3. #3
    Join Date
    Jan 2002
    Posts
    165
    i set logarchmeth1="disk=D:\ARCHIVE" but it still archive logs in directory with primary logs.I even restarted instnace
    What i am doing wrong?

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You should be running this to set it properly:

    UPDATE DB CFG for MyDB using logarchmeth1 DISK:\ARCHIVE

    HTH

    Andy

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Stupid smiley face icons. That smiley face is a colon followed directly by D

    Andy

  6. #6
    Join Date
    Jan 2002
    Posts
    165
    Thanks,Andy.
    Everything is perfect
    Thanks

Posting Permissions

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