348 Performance Tuning for Content Manager
12.1 Troubleshooting basics
The key to successfully and efficiently resolving performance problems in a
Content Manager system is to have an organized, disciplined process that
focuses on identifying and relieving the system’s performance bottlenecks.
Without an organized process focused on identifying bottlenecks, it is very easy
to spend a lot of time and energy tweaking various parameters, ending up with a
system in a worse state than before with no good record of what was changed
and why. To be successful, you must collect the right data and find the real
bottleneck. You will then be able to address that bottleneck, tune the system, and
improve the performance of your Content Manager system.
Before beginning any full performance troubleshooting process, first ensure that
the database statistics for the Library Server and Resource Manager databases
are up to date. Content Manager is a database application. It depends heavily on
accurate database statistics for optimizing all operations. Updating database
statistics on the Library Server and Resource Manager databases is quick and
easy to do, and often turns out to be the only fix needed.
Performance problems are often caused by changes in the system. The changes
that might affect system performance include:
Example: Adding new disks or changing hardware configurations
Operating system changes
Example: Installing PTFs or changing parameters
Example: Adding fix packs for DB2 and WebSphere, or configuration changes
Example: Installing or upgrading new versions and fixes, configuration
changes, installing new modules, or adding new users or new content
Example: Tuning changes in operating system, network, DB2, WebSphere,
TSM, or the application
Is it a performance problem?
When a user complains about a problem or you experience a problem firsthand,
you must first determine the nature of the problem: whether it is a functional
problem or a performance problem. When your hardware, network, or application
does not behave correctly, it is a functional problem (for example, if your Content