Chapter 24. DB2 Performance Monitoring

In This Chapter

• DB2 Traces

• Trace Destinations

• Using IFCIDs

• Tracing Guidelines

• Performance Monitoring and Reporting: Online and Batch

• Monitoring and Reporting Strategy

• Performance Profiles

• Viewing DB2 Console Messages

• Displaying the Status of DB2 Resources

• Monitoring z/OS

The first part of any DB2 performance management strategy should be to provide a comprehensive approach to the monitoring of the DB2 subsystems operating at your shop. This approach involves monitoring not only the threads accessing DB2 and the SQL they issue, but also the DB2 address spaces. You can accomplish this task in three ways:

• Batch reports run against DB2 trace records. While DB2 is running, you can activate ...

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial