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

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

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

You should never have just one log file. Three is the minimum.