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:

• New business insights without complex AI application deployment
• Scalability and performance improvements through smarter optimization without tuning actions
• Highly available (HA) system management with greater resiliency and flexibility
• Greater insights into managing complex enterprise systems

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