Lotus Domino Administrator 7 Help - Setting DB2 Log File Size

DOMINO AND DB2

Setting DB2 Log File Size
For this beta release of Domino 7 and DB2, you need to set the DB2 log file size. You can specify these values as you would any DB2 configuration settings by using either the DB2 Control Center, or by using the DB2 Command Line Processor (CLP).

For example, from the DB2 CLP, enter a command similar to the following:

db2 update db cfg for <yourdb> using logprimary X

Where the value of <yourdb> is the value you specified for DB2Database in the Server Enablement Tool. The default value is DOMINO.

Recomended DB2 log settings

The recommended DB2 log file settings are as follows:

For low traffic workloads, use the default setting, ~28MB
Log file size (4KB)
(LOGFILSIZ) = 1000
Number of primary log files
(LOGPRIMARY) = 5
Number of secondary log files
LOGSECOND) = 2

For mid-traffic workloads, the suggested setting is ~240MB
Log file size (4KB)
(LOGFILSIZ) = 4000
Number of primary log files
(LOGPRIMARY) = 10
Number of secondary log files
(LOGSECOND) = 5

For high-traffic workloads, the suggested setting is ~480MB

Log file size (4KB)

(LOGFILSIZ) = 8000

Number of primary log files

(LOGPRIMARY) = 10

Number of secondary log files

(LOGSECOND) = 5

See also

Maintaining the Domino and DB2 environment

Understanding Domino and DB2 -- Limited Availability

Glossary

Help on Help

All Help Contents

Glossary

Help on Help

All Help Contents

`Log file size (4KB)`	`(LOGFILSIZ) = 1000`
`Number of primary log files`	`(LOGPRIMARY) = 5`
`Number of secondary log files`	`LOGSECOND) = 2`

`Log file size (4KB)`	`(LOGFILSIZ) = 4000`
`Number of primary log files`	`(LOGPRIMARY) = 10`
`Number of secondary log files`	`(LOGSECOND) = 5`

`Log file size (4KB)`	`(LOGFILSIZ) = 8000`
`Number of primary log files`	`(LOGPRIMARY) = 10`
`Number of secondary log files`	`(LOGSECOND) = 5`