Published on 27 January 2023, updated 07 September 2023
IBM Form #: SG24-8536-00
Authors: Neena Cherian, Nguyen Dao, Reynaldo Fajardo, Akiko Hoshikawa, Peng Huang, Maggie Ou Jin, Ping Liang, Jie Ling, Todd Munk, Bart Steegmans, Jasmi Thekveli, Lingyun Wang, Chung Wu, Chongchen Xu, Huiya Zhang, Xiao Wei Zhang and Xue Lian Zhang
IBM® Db2® 13 for z/OS delivers innovations that can improve your ability to make well-informed business decisions. As the industry's first relational database that integrates artificial intelligence (AI) into SQL queries, Db2 13 combines deep-learning capabilities with advanced IBM Z® technologies to reveal hidden relationships across tables and views in your Db2 data.
As with earlier releases of Db2, Db2 13 continues to enhance availability, scalability, security, and resiliency, and applies optimization to improve the performance of your operational processes. These improvements include the following ones:
Db2 13 is built on the continuous development delivery model that was introduced in Db2 12 for z/OS, and it continues to leverage a tight synergy between IBM zSystems hardware and IBM z/OS®.
This IBM Redbooks® publication provides performance comparisons between Db2 13 and Db2 12, including high-level performance expectations when you migrate to Db2 13. It also provides measurement results and usage considerations for using the new capabilities that are delivered in Db2 13. Because Db2 13 is built on Db2 12 and the functions that were delivered through the continuous delivery stream, measurements are provided for the key performance features that were delivered in Db2 12 and the Db2 ecosystem since IBM Db2 12 for z/OS Performance Topics, SG24-8404 was published in September 2017. These features include various IBM Z platform synergy items and new features that were added in IBM Db2 Analytics Accelerator (IDAA), IBM Db2 for z/OS Data Gate, and IBM Db2 AI for z/OS (Db2ZAI).
The performance measurements in this book were generated at the IBM Silicon Valley Laboratory under specific and tightly controlled conditions. Your results are likely to vary due to differences in your conditions and workloads.
For the purposes of this publication, it is assumed that you are familiar with the performance aspects of Db2 for z/OS. For more information about the functions that were delivered in Db2 13, see IBM Db2 13 for z/OS and More, SG24-8527.
Chapter 1. Introduction
Chapter 2. Scalability and availability
Chapter 3. Synergy with the IBM Z platform
Chapter 4. Workload-level measurements
Chapter 5. Data sharing
Chapter 6. SQL Data Insights
Chapter 7. Application concurrency
Chapter 8. Query performance
Chapter 9. IBM Db2 for z/OS utilities
Chapter 10. Performance enhancements for IDAA for z/OS and IBM Db2 for z/OS Data Gate
Chapter 11. Installation and migration
Chapter 12. Monitoring and instrumentation
Chapter 13. IBM Db2 AI for z/OS benefits and capacity requirement
Appendix A. IBM Db2 workloads
Appendix B. Artificial intelligence semantic queries
Appendix C. IBM Db2 Analytics Accelerator for z/OS workloads