476 DB2 Performance Expert for Multiplatforms V2.2
Buffer pools are created in your CM Library Server database and CM Resource
Manager database. The size of the buffer pools are based on the assumption
that 2 GB RAM is available on the machine. The buffer pool sizes are shown in
Figure B-2.
Figure B-2 Buffer pools created during CM installation
Monitoring CM databases with Performance Expert
The IBM DB2 Content Manager V8.3 Enterprise Edition Performance Tuning
Guide describes a CM performance methodology that is based on the following
five stages. The IBM DB2 Content Manager V8.3 Enterprise Edition Performance
Tuning Guide can be found at:
http://www.ibm.com/support/docview.wss?uid=swg27006452
Stages:
1. Planning for performance and scalability
Document the projected system topology and the projected workload, define
measurable performance and scalability objectives, and perform initial
capacity planning and sizing estimates.
Appendix B. Monitoring CM databases with Performance Expert 477
2. Solution design choices and performance trade-offs
Understand topology choices (types of client, eClient, Document Manager,
Client for Windows, custom client), feature choices (for example, replication,
High Availability, text search, versioning, and so on), and their performance
implications.
3. Performance tuning
Plan for an initial tuning period to maximize confidence and reduce risk to
meet the objectives that were set in the planning phase. Focus on effective
tuning of CM server calls, database and database manager parameters,
memory, disk I/O, and network bandwidth.
4. Monitoring and maintaining performance
Maintain a “performance profile” of the workload metrics and resource
utilizations on your CM servers. Monitor over time to observe trends before
they become a problem.
5. Performance troubleshooting
When performance issues arise, use a disciplined and organized approach to
solve the problem by using the “performance profile” data and performance
tuning guidelines.
Performance Expert can help you to monitor your CM Library Server and CM
Resource Manager databases in the following CM Performance Methodology
stages:
Performance Tuning
Monitoring and maintaining performance
Performance Troubleshooting
See the following sections for details about how Performance Expert can be
used in these stages.
Performance Tuning
During the initial tuning period, the following monitoring tasks using Performance
Expert will help you to determine if you need to modify your database or
database manager in order to meet the objectives that you set in the planning
stage.
Monitor your overall system health in normal and peak times and adapt
configuration parameters if necessary. See the following sections for more
information:
“Monitoring the health of the CM DB2 databases” on page 480
“Monitoring buffer pool effectiveness” on page 502

Get DB2 Performance Expert for Multiplatforms V2.2, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.