Performance Tuning for Content Manager

172 Performance Tuning for Content Manager

8.1 Introduction

DB2 plays an extremely important role in Content Manager system performance.

Library Server, the central focal point for the entire Content Manager system, is

largely an extension of DB2. Performance tuning is affected by many factors,

including the workload scenario and the system environment. For this reason,

proper DB2 configuration setup, regular routine maintenance, and careful tuning

of the buffer pools and the configuration parameters are the keys to a solidly

performing Content Manager system. In the following sections, we cover these

key areas in detail. Some of the recommendations might have been presented in

previous chapters, but we decided to include all DB2-related performance tuning

in one section for easy reference.

We have provided general examples of the related DB2 commands. Always

check the product publications for the correct syntax as it applies to your

situation:

 IBM DB2 Universal Database Version 8.2 SQL Reference Volume 2,

SC09-4845

 IBM DB2 Universal Database Version 8.2 Command Reference, SC09-4828

 IBM DB2 Universal Database Version 8.2 Administration Guide: Performance,

SC09-4821

8.2 Design and configuration setup

Design and configuration setup influences system performance. Without proper

design and configuration setup, the system might never be able to perform at the

expected level. In this section, we recommend a list of actions that you should

consider taking to improve overall system performance. They include:

 Spread the database components over multiple disks.

 Customize CM databases deployment at install through DDL.

 Create separate instances during installation.

 Initial parameter tuning for Library Server database.

 Create attribute indexes.

 Create indexes for document routing.

 Additional configuration and tuning suggestions.

Attention: You must be an experienced DBA to perform the suggested tasks.

If you are not familiar with what they are and how to do them, we do not

recommend you experimenting with them.