Posts Tagged ‘db2’

Minimum DB2 database Transaction logsize for Installing BMC Remedy

March 28th, 2010
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:
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.

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.

%d bloggers like this: