Results 1 to 3 of 3

Thread: pruge logs

  1. #1
    Join Date
    May 2010
    Posts
    88

    Unanswered: pruge logs

    Hi,
    Userexit is enabled in our environment. I read in the document that logs in the active directory needs to be manually purged once they get moved in the other directory. But why are they automatically getting purged in our environment?
    Also help me know, why are the logs that got archived are not of the same size? What I understand is, log files moves when they get full; in that case, I should see all the logs files in the archived folder to be of same size...

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by db2cap View Post
    Userexit is enabled in our environment. I read in the document that logs in the active directory needs to be manually purged once they get moved in the other directory. But why are they automatically getting purged in our environment?
    If you enable USEREXIT, it is the userexit program responsibility to delete (or not) the archived logs.

    Quote Originally Posted by db2cap View Post
    log files moves when they get full
    ...and also in other cases, e.g. after a backup, or when the database is deactivated.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    If userexit is enabled, db2 should reuse the logs in the active log directory by renaming them. Let's say, log A gets archived by userexit. When log A is no longer active (full logs are archived when they're still active) and DB2 needs to allocate a new log B, it should rename log A to log B. The archived logs can be of different size if they get truncated (at the end of an online backup, archive log command or when the database is deactivated as n_i mentioned). Truncated logs used to be deleted in older version, but they are now extended and reused.

Posting Permissions

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