Tools for performance analysis
You can use workstation and browser-based tools to simplify performance analysis for Db2 for z/OS.
For example, the following tools simplify performance analysis for Db2 for z/OS:
- IBM Data Server Manager
- IBM Data Studio
- Tivoli OMEGAMON XE for Db2 Performance Expert on z/OS
- Introduction to Buffer Pool Analyzer (Tivoli OMEGAMON XE for Db2 Performance Expert on z/OS )
- Db2 SQL Performance Analyzer for z/OS
- https://www.ibm.com/support/knowledgecenter/SSAURY_3.3.0/topics/cqmhome.html
You can also use the Db2 EXPLAIN facility to analyze query access paths. For more information, see Investigating SQL performance by using EXPLAIN.
IBM OMEGAMON for Db2 Performance Expert on z/OS
IBM OMEGAMON for Db2 Performance Expert on z/OS integrates performance monitoring, reporting, buffer pool analysis, and a performance warehouse function into one tool. It provides a single-system overview that monitors all subsystems and instances across many different platforms in a consistent way.
IBM OMEGAMON for Db2 Performance Expert on z/OS includes the function of Db2 Performance Monitor on z/OS. It provides the following features:
- Combined information from EXPLAIN and from the Db2 catalog.
- Displays of access paths, indexes, tables, table spaces, plans, packages, DBRMs, host variable definitions, ordering, table access sequences, join sequences, and lock types.
- An immediate "snapshot" view of Db2 for z/OS activities that the online monitor provides. The monitor allows for exception processing while the system is operational.
IBM OMEGAMON for Db2 Performance Expert on z/OS offerings support Db2 for z/OS on IBM zSystems, and Db2 for Linux®, UNIX, and Windows, HP-UX, Sun Solaris, and IBM® AIX®).