Siebel Database Upgrade Guide > Preparing an IBM DB2 Database for a Siebel Upgrade >
Setting IBM DB2 Parameters for a Siebel Upgrade
Upgrades from: All Supported Siebel releases. Environments: Development, production test, production. Databases: IBM DB2 only. This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade. Before upgrading an IBM DB2 database, verify that your database server meets or exceeds the following configuration criteria:
The tables which follow provide upgrade-specific settings for the Database Manager and database. Use the following strategy to set parameters:
- Set parameters using the recommendations in Siebel Installation Guide for the operating system you are using. Recommendations are located in the chapter on configuring the RDBMS.
- For the upgrade, revise the configuration parameters listed in the tables which follow.
- After the upgrade, reset the configuration parameters to the values listed in Siebel Installation Guide for the operating system you are using.
DB2 Database Manager Settings
The Upgrade Setting column in Table 23 provides guidelines for setting configuration parameters specifically to optimize upgrade performance. Set these parameters for each DB2 instance.
Table 23. DB2 Database Manager Configuration Parameters
|
|
|
SHEAPTHRES
|
Sort heap threshold (4 KB) If you reset SHEAPTHRES or SORTHEAP , rebinding the instance is recommended. |
Double the value allocated for SORTHEAP . See Table 24. |
DB2 Database Configuration Parameters
The Upgrade Setting column in Table 24 provides guidelines for setting configuration parameters specifically to optimize upgrade performance. Set these parameters for each DB2 instance.
Table 24. DB2 Database Configuration Parameters
|
|
|
SORTHEAP
|
Sort list heap (4 KB) |
20000—40000 Recommended size; this may increase or decrease depending on the amount of memory in the database server machine and the size of the data.
A 20000 setting allows SORTHEAP to increase up to 80 MB. |
MAXLOCKS
|
Percentage of lock lists per application |
5
|
CHNGPGS_THRESH
|
Changed pages threshold |
5
|
LOGRETAIN
|
Sequential or circular log files |
NO
Setting this parameter to YES means that log files are archived. You must periodically move or archive the log files to prevent the file system containing the log files from filling up. |
LOGFILSIZ
|
Log file size (4 KB) |
Development environments:
8000-16000 |
SOFTMAX
|
Triggers bufferpool flushing |
50
|
|