Happy to share a new redbook on DB2 perforamnce management using Optim Performance Manager (OPM) and Optim Query Workload Tuner (OQWT).
This redbook is divided in four neat parts. The first part discussed the strategy for performance management and discusses all the performance management solution to help you identify, diagnose, solve and prevent performance management issues in your environment. The first part also discussed at length on planning, installing and configuring the Optim Performance Manager.
The second part introduces OPM and OQWT and brings the most interesting discussion on finding and fixing database level bottlenecks, which in nutshell covers the most frequently asked question on how to consume these tooling and data in different dashboards and reports. The third part touches the performance management in a distributed environment i.e. DPF and pureScale wherein it touches the information that can help you do performance analysis on these type of systems.
The final part covers some of the specific topics such as implementing workload management using OPM UI and out of box support for monitoring packaged based application systems like SAP, IBM Websphere, IBM Cognos, IBM InfoSphere DataStage and InfoSphere SQL Warehouse applications.