The “CA Performance Handbook for DB2 for z/OS”Â handbook helps DB2 performance tuners to complete the following tasks:
- Design databases for high performance.
- Understand how DB2 processes SQL and transactions, and tune those processes forÂ performance.
For database performance management, the philosophy of performance tuning beginsÂ with database design and extends through the database and application developmentÂ and production implementation.
- Fundamentals of DB2 performance.
- Descriptions of features and functions that help you manage and optimizeÂ performance.
- Methods for identifying DB2 performance problems.
- Guidelines for tuning static and dynamic SQL.
- Guidelines for the proper design of tables and indexes for performance.
- DB2 subsystem performance information, and advice for subsystem configurationÂ and tuning.
- Commentary for proper application design for performance.
- RealÂ world tips for performance tuning and monitoring
CA Technologies Product References
- CA Database Analyzerâ„¢ for DB2 for z/OS (CA Database Analyzer)
- CA DetectorÂ® for DB2 for z/OS (CA Detector)
- CA Index Expertâ„¢Â for DB2 for z/OS (CA Index Expert)
- CA Insightâ„¢ Database Performance Monitor for DB2 for z/OS (CA Insight DPM)
- CA Plan AnalyzerÂ® for DB2 for z/OS (CA Plan Analyzer)
- CA Rapid ReorgÂ® for DB2 for z/OS (CA Rapid Reorg
- CA SQLÂ EaseÂ® for DB2 for z/OS (CA SQLÂ Ease)
- CA Subsystem Analyzer for DB2 for z/OS (CA Subsystem Analyzer)
Read the “CA Performance Handbook for DB2 for z/OS“.