Siebel Database Upgrade Guide > Preparing an IBM DB2 Database for a Siebel Upgrade >
Setting IBM DB2 Parameters for a Siebel Upgrade
Environments: Development, production test, production. Databases: IBM DB2 only. 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 16 provides guidelines for setting configuration parameters specifically to optimize upgrade performance. Set these parameters for each DB2 instance.
Table 16. DB2 Database Manager Configuration Parameters
|
|
|
SHEAPTHRES
|
Sort heap threshold (4 KB) If you reset SHEAPTHRES or SORTHEAP , then rebinding the instance is recommended. |
Double the value allocated for SORTHEAP . See Table 17. |
DB2 Database Configuration Parameters
The Upgrade Setting column in Table 17 provides guidelines for setting configuration parameters specifically to optimize upgrade performance. Set these parameters for each DB2 instance.
Table 17. DB2 Database Configuration Parameters
|
|
|
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 machine 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
|
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
|
|