Siebel Installation Guide for Microsoft Windows > Configuring the RDBMS > Configuring an IBM DB2 UDB Database for Siebel Applications >
Guidelines for Determining DB2 UDB Log Space
This topic is part of Configuring an IBM DB2 UDB Database for Siebel Applications.
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, allocate 4-8 GB of total log space, as needed. Create 25-50 primary log files of 160 MB each, by setting the
LOGFILSIZ database configuration parameter to 40000 and the
LOGPRIMARY parameter to 25-50. To support very large transactions, set the
LOGSECOND parameter to 128 minus the value of
LOGPRIMARY. Smaller systems may use less log space.