Minimum DB2 database transaction log size
When you upgrade an AR System 7.5.00 server that uses an IBM® DB2 Universal Database® in an environment supporting BMC Remedy IT Service Management (ITSM) applications, BMC recommends a minimum database transaction log file size of 1.3 gigabytes (GB).
Before starting the upgrade, adjust the following DB2 Universal Database
configuration parameters to ensure that logfilesize >= 1.3 GB:
???? LOGFILSIZ
???? LOGPRIMARY
???? LOGSECOND
For example:
Log file size (4KB) (LOGFILSIZ) = 20000
Number of primary log files (LOGPRIMARY) = 8
Number of secondary log files (LOGSECOND) = 10
WARNING
This example is from a test environment and represents a minimum transaction log file size. To determine the log file requirements for your environment, consult your database administrator before beginning the upgrade.
For more information about determining your transaction log file size, go to
http://publib.boulder.ibm.com/tividd/td/tec/SC32-1233-00/en_US/
HTML/ecoimst65.htm.
