Bookshelf Home | Contents | Index | PDF     

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 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 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
Parameter
Explanation
Upgrade Setting

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
Parameter
Explanation
Upgrade Setting

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
      
Siebel Database Upgrade Guide Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.