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.
IBM DB2 Database Manager Settings
The Upgrade Setting column in Table 13 provides guidelines for setting configuration parameters specifically to optimize upgrade performance. Set these parameters for each IBM DB2 instance.
Table 13. IBM 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 14. |
IBM DB2 Database Configuration Parameters
The Upgrade Setting column in Table 14 provides guidelines for setting configuration parameters specifically to optimize upgrade performance. Set these parameters for each IBM DB2 instance.
Table 14. IBM 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 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
|
|