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.
Related posts:
- TCP/IP error while installing ARSystem Remedy on SQL Database?
- Common Database Issues and Solutions with BMC Remedy AR Server
- Calculate database size requirements for new AR System Remedy
- Not able to connect with database to install AR Server?
- Usage of DBA Extensions with BMC Remedy
- BMC Remedy AR System 7.5.0 Installation Guide
- News: BMC acquires MQSoftware to provide Middleware Management
