Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Configuring the RDBMS > Configuring IBM DB2 UDB for Siebel Applications >

Guidelines for Determining DB2 UDB Log Space

You must create database transaction logs large enough to support various large transactions used by the Siebel software. On DB2 UDB, three parameters affect the amount of log 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.

To run on a large system, create approximately 1 GB of total log space. Create 25-50 primary log files of 32 MB each. These tasks are accomplished by setting the LOGFILSIZ database configuration parameter to 40000 and the LOGPRIMARY parameter to 25-50. In addition, to support very large transactions, set the LOGSECOND parameter to 128 minus the value of LOGPRIMARY.

Smaller systems may use less log space.