Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    70

    Unanswered: Log_dir & log_archive issue

    Hi All,

    I am facing a critical issue in DB2.The online log files creating in log_dir folder and transfering to log_archive folder.In my case the log_dir files are transferring to log_archive folder but the log_dir files are still reming in same place.

    Finally the same online log files exist in both log_dir & log_archive folder.what is the isssue..

    Quick response will be appriciated...

    Regards,
    Raj

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Don't worry about that. DB2 sometimes has this behavior.
    My guess: The Logfile was filled and copied to archive log-directory, but not all Transactions in the Logfile are commited. If everything is comitted the logfile will be recycled.
    Also sometimes DB2 can't recycled logfiles, because there's a lock on the Files from a Virusscanner or a Backuputility. If the Logfile is a lot older than the other logfiles in the directory and it was copied to the Archive-Directory you could delete it without problems.

    Cheers
    nvk

Posting Permissions

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