O'Reilly logo

Subsystem and Transaction Monitoring and Tuning with DB2 11 for z/OS by Yasuhiro Ohmori, Cathy Drummond, Adrian Burke, Felipe Bortoletto, Paolo Bruni

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Accounting trace overview
The best way to troubleshoot a poorly performing application is to understand where the time is actually spent and what DB2 resources are being used. DB2 traces provide these indicators, but you need to know how to interpret them and what the most efficient corrective actions are. If most of the time is spent using system CPU, what is the most likely culprit? If the problem is elapsed time, there are many types of suspensions and many of them have specific tuning steps to reduce the wait times.
This chapter discusses ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required