Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: What is better to have on big log or multiple small ones

    Hi,
    what is better to have one big log file (LOGFILSIZ) or 10 small logs?
    My settings:
    LOGFILSIZ = 9000
    LOGPRIMARY = 10

    Would it be better to have:
    LOGFILSIZ = 90000
    LOGPRIMARY = 1

    Thanks,
    Grofaty

    My system:
    DB2 workgroup server edition v8.2.2 on Windows 2003

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    log file

    if using large log files and archive of log files, you have to wait longer for the file be archived. If disk crash occures, the large log file (long interval) will be lost. if smaller log files only some small log files ( shorter interval) will be lost and recovery is closer to crash.
    archiving takes also longer..
    if many update/ins/del in db, might be better to have larger files, otherwise overhead for each time create/archive log file
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    As guy pointed out, use larger logs for high insert/update/delete activity ... For transactional systems, use smaller logs so that your recoverability is not impacted in case of disk failures ... But having the files very small will have an impact on performance due to log archiving and log switching ..

    Another releated parameter to consider is SOFTMAX ... Adjust your SOFTMAX value to a reasonable value so that bufferpool flushing is adequate but not too frequent

    HTH

    sathyaram

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You should never have just one log file. Three is the minimum.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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