Tuning Siebel CRM for IBM DB2

This topic provides instructions for tuning your Siebel database on IBM DB2. These steps improve the performance of Siebel workspace queries on IBM DB2, for Siebel developers using Siebel Tools or Siebel Web Tools. Your database administrator can apply these configurations directly on your DB2 database. Testing for the following configurations was done on IBM DB2 v11.1. Results might vary on IBM DB2 v10.5.

To tune Siebel CRM for IBM DB2

Check the value of the NUMDB parameter. If it is too high, then set it to a lower number to provide each database with sufficient memory.
Increase the buffer pool allocation to 5 GB. To do so, enter the following commands:

Note: Before you increase buffer pool allocation, it is important to identify the buffer pool for the table spaces used by your workspace queries. For example, for table spaces TBS_16K and TBS_4K, you might configure the buffer pools BUF_16K and BUF_4K, respectively.
```
db2 alter bufferpool buf_4k immediate size 1310720 automatic # 5 GB
db2 alter bufferpool buf_16k immediate size 327680 automatic # 5 GB
```
The value AUTOMATIC allows the size to be adjusted dynamically if more memory is available. Alternatively, each buffer pool could also be set to 80% of DATABASE_MEMORY.

Note: The preceding configuration changes would require the database server to be restarted, requiring some downtime. For maximum performance benefit, perform steps 1 and 2 together.

Enable parallel execution. To do so, enter the following commands:

db2stop force
db2 update dbm cfg using intra_parallel on
db2start
db2 deactivate db <dbname>
db2 update db cfg for <dbname> using dft_degree any
db2 activate db <dbname>

Increase SORTHEAP size. To do so, enter the following commands:

db2 update db cfg for <dbname> using SHEAPTHRES_SHR 200000
db2 update db cfg for <dbname> using SORTHEAP 100000

Related Books

For additional database configuration settings for IBM DB2 and other RDBMS, see Siebel Installation Guide.