1. Installation Guide
  2. Guidelines for Determining IBM DB2 Log Space

Guidelines for Determining IBM DB2 Log Space

This topic is part of Configuring an IBM DB2 Database for Siebel CRM.

You must create database transaction log files large enough to support various large transactions used by Siebel CRM. On IBM DB2, three parameters affect the amount of log file space reserved:

  • LOGFILSIZ. The size of the log file.

  • LOGPRIMARY. The number of log files to preallocate and use.

  • LOGSECOND. Extra log files that are allocated only if they are needed for a large transaction.

For a large system, allocate 4 to 8 GB of total log file space, as needed. Create 25 to 50 primary log files of 160 MB each, by setting the LOGFILSIZ database configuration parameter to 40000 and the LOGPRIMARY parameter to a value between 25 to 50. To support very large transactions, set the LOGSECOND parameter to 128 minus the value of LOGPRIMARY. Smaller systems can use less log file space.