IBM DB2 Database Configuration Parameters

The Upgrade Setting column in the following table provides guidelines for setting configuration parameters specifically to optimize upgrade performance. Set these parameters for each IBM DB2 instance.

Parameter	Explanation	Upgrade Setting
`SORTHEAP`	Sort list heap (4 KB)	`20000—40000` Recommended size; this might increase or decrease depending on the amount of memory in the database server computer and the size of the data. A `20000` setting allows `SORTHEAP` to increase up to 80 MB.
`MAXLOCKS`	Percentage of lock lists for each application	`5`
`CHNGPGS_THRESH`	Changed pages threshold	`5`
logarchmeth1	Primary log archive method configuration parameter	OFF. To retain active log files for rollforward recovery, set logarchmeth1 to LOGRETAIN by issuing the command: `UPDATE DB CFG USING logarchmeth1 LOGRETAIN.`
`LOGFILSIZ`	Log file size (4 KB)	Development environments: `8000-16000`
`SOFTMAX`	Triggers bufferpool flushing	`50`