Configuring an IBM DB2 Database for Siebel CRM

This topic includes guidelines for obtaining optimal performance from an IBM DB2 Database for use with Siebel CRM. These guidelines will be useful to a broad segment of customers. Choose values for the parameters described in this guide that reflect conditions in your particular environment. For more information, see IBM DB2 technical documentation.

Note: In this guide, the terms IBM DB2 or DB2 are often used to refer to the database platform IBM DB2 for Linux, UNIX, and Windows.

When you use IBM DB2, the IBM Data Server Client must be installed on the Siebel Server computer. Verify that the IBM Data Server Client is installed before proceeding. For details, see Siebel Database Upgrade Guide. In addition, the IBM Data Server Runtime Client must be installed on the Siebel Server computer. For IBM DB2 version information, see the Certifications tab on My Oracle Support.

Note: If your database is IBM DB2 for z/OS, then see Implementing Siebel Business Applications on DB2 for z/OS instead of this chapter.

Guidelines for Configuring an IBM DB2 Database

Various kinds of guidelines are presented for configuring an IBM DB2 database:

• Guidelines for Setting IBM DB2 Database Configuration Parameters

• Guidelines for Selecting a Language for IBM DB2

• Guidelines for Creating the IBM DB2 Database

• Guidelines for Setting IBM DB2 Configuration Parameters

• Guidelines for Setting Up IBM DB2 Buffer Pools

• Guidelines for Creating IBM DB2 Tablespaces

• Guidelines for Overriding IBM DB2 Default Tablespaces for Database Objects

• Guidelines for Preventing IBM DB2 from Running Out of ODBC Statement Handles

• (UNIX) Guidelines for Increasing the Number of IBM DB2 User Processes Under AIX

• Guidelines for Determining IBM DB2 Log Space

• Guidelines for Creating IBM DB2 Database Objects

• Guidelines for Managing IBM DB2 Fragmentation

Related Topics

Installing the Siebel Database on the RDBMS

Planning RDBMS Installation and Configuration

Overview of Database Configuration

Specifying the Locale for Siebel CRM

Verifying Installation for the Siebel Database

Related Books

Siebel Database Upgrade Guide

Implementing Siebel Business Applications on DB2 for z/OS