1. Database Upgrade Guide
  2. Setting IBM DB2 Parameters for a Siebel Upgrade

Setting IBM DB2 Parameters for a Siebel Upgrade

Environments: Development, Test and Production.

Databases: IBM DB2 only.

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 IBM DB2 must 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 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. 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.