Performance Tuning Services for DB2 LUW

Objective: Optimize DB2 for Linux, UNIX, and Windows.

The DB2 for Linux, Unix, and Windows Performance Tuning Services engagement is designed to provide your organization with customized assistance and skills transfer with monitoring and tuning of DB2 for Linux, Unix, and Windows.

This service engagement involves in depth monitoring and tuning assistance with your development, test, and/or production DB2 for LUW environment. This service engagement involves analysis of existing system hardware, software, and database configurations to pinpoint over utilized (bottlenecks) and under utilized system resources such as cpu, memory, disk, and network adapter cards. 

Background Information

Prior to DB2 Common Server (version 2.x) it was very difficult to monitor and tune for capacity and performance. This was primarily due to the lack of information and the abundance of misinformation pertaining to the internals of the DB2 database engine. Today the opposite is true, with almost two hundred counters, gauges, high water marks, informational and time stamp data elements, figuring out where to start can be a chore of it's own.

DB2 for LUW provides several methods for collecting and analyzing database performance data. These include the Snapshot Monitor and Event Monitor. The Snapshot Monitor provides a means to collect data at a specific point in time. The Event Monitor provides a means to collect data over a period of time.