Bookshelf Home | Contents | Index | PDF     

Upgrade Guide > Preparing an IBM DB2 Database for a Siebel Upgrade >

Setting IBM DB2 Parameters for a Siebel Upgrade

Upgrades: All Siebel upgrades.

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 DMS tablespace has at least 25% of free pages.
  • The file system has sufficient space to allow your DMS tablespace to grow.
  • Siebel tablespaces for the DB2 platform should be database-managed tablespaces (DMS) rather than system-managed tablespaces (SMS).
  • Verify that the tablespaces are not near their capacity. This can be done by connecting to the database and issuing the following command:

    db2 list tablespaces show detail

The tables below 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 below.
  • 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 24 provides guidelines for setting configuration parameters specifically to optimize upgrade performance. Set these parameters for each DB2 instance.

Table 24. DB2 Database Manager Configuration Parameters
Parameter
Explanation
Upgrade Setting

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 25.

DB2 Database Configuration Parameters

The Upgrade Setting column in Table 25 provides guidelines for setting configuration parameters specifically to optimize upgrade performance. Set these parameters for each DB2 instance.

Table 25. DB2 Database Configuration Parameters
Parameter
Explanation
Upgrade Setting

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 logs 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
    
Upgrade Guide Copyright © 2006, Oracle. All rights reserved.