Skip to main content

IBM Db2 13 for z/OS Performance Topics

An IBM Redbooks publication

thumbnail 

Published on 27 January 2023, updated 07 September 2023

  1. .EPUB (13.5 MB)
  2. .PDF (17.5 MB)


Share this page:   

ISBN-10: 0738461008
ISBN-13: 9780738461007
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

    menu icon

    Abstract

    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.

    Table of Contents

    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

     

    Others who read this also read