A Deep Blue View of DB2 Performance: IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS
An IBM Redbooks publication
Note: This is publication is now archived. For reference only.
Published on 04 May 2006
ISBN-10: 0738497371
ISBN-13: 9780738497372
IBM Form #: SG24-7224-00
Authors: Paolo Bruni, Marcelo Antonelli, Norbert Heck, John Jenkins and Ernie Mancill
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS represents the effort on converging OMEGAMON XE for DB2 and DB2 Performance Expert into one product that retains the best features of each. This new tool gives you a single, comprehensive tool to help assess the efficiency of and optimize performance from your DB2 Universal Database in the z/OS environment. It automates the analysis of your database performance in real time and also adds expert database analysis functions to help you maximize performance and enhance productivity.
The main functions of this tool allow you to:
- Monitor, analyze, and tune the performance of IBM DB2 Universal Database and DB2 applications on z/OS
- Improve productivity with meaningful views of performance
- Quickly and easily identify performance bottlenecks using predefined rules of thumb
- Enjoy substantial breadth and depth in monitoring DB2 environments by combining batch-reporting capabilities with real-time monitoring and historical tracking functions
- Support an enterprise-wide integrated systems management strategy activated by the IBM Tivoli OMEGAMON XE family
- Store performance data and analysis tools in a performance warehouse
The software combines the sophisticated reporting, monitoring, and buffer pool analysis features of the IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS and IBM DB2 Buffer Pool Analyzer products.
This IBM Redbooks publication will help you install and understand the main functions of the product, clarify the differences, and point out the advantages if you had one of the pre-existing products already in use.
Part 1. Introduction
Chapter 1. The new IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS
Chapter 2. History of products
Chapter 3. Architecture
Part 2. Installation
Chapter 4. New installation
Chapter 5. Security considerations
Part 3. What's new for DB2 PE users
Chapter 6. VTAM interface
Chapter 7. Portal interface
Chapter 8. Object Analysis
Chapter 9. Near-term history using the Classic Interface
Chapter 10. Application Trace Facility
Chapter 11. CICS and IMS Attach
Part 4. What's new for OMEGAMON users
Chapter 12. DB2 Connect monitoring
Chapter 13. Reporting
Chapter 14. Performance Database and Performance Warehouse
Part 5. User scenarios
Chapter 15. Accounting on package level
Chapter 16. Solving common DB2 operational problems
Part 6. Appendixes
Appendix A. DB2 Workload Generator
Appendix B. Additional material