IBM Db2 Announcement Letters

IBM Db2 AI for z/OS empowers the Db2 for z/OS optimizer to select improved access paths for SQL and improves application performance using machine learning

(IBM Europe Announcement ZP18-0413, dated September 11, 2018)

Overview

IBM Db2ZAI empowers the optimizer in your Db2 for z/OS engine to determine the best-performing query access paths based on your workload characteristics. New intelligence in the optimizer, using host-variable and number of rows fetched insight, enables it to identify the optimal access paths for SQL queries. This can significantly improve application performance by reducing optimization complexity.

Using the Db2 for z/OS optimizer and leveraging IBM Machine Learning for z/OS (ML for z/OS) technology, IBM Db2 AI for z/OS (Db2ZAI) provides:

• Improved Db2 SQL access path selection
• Improved Db2 application performance
• Rapid model learning specific to the data and configuration per Db2 subsystem