Enable Db2 for z/OS optimizer to leverage machine learning

Overhead view of electrical power plant

IBM Db2® AI for z/OS® enables your organization to reduce CPU consumption and IT costs through optimization for best query access paths, ultimately improving Db2 application performance. Db2 for z/OS infused with machine learning technology allows for rapid model learning specific to the data and configuration per LPAR, without requiring data science skills. Now with Db2 AI for z/OS 1.3, you can automatically learn about connection and thread behavior of remote applications and then see recommended Db2 profile controls that can prevent connection flooding from impacting other applications, hence optimizing database performance.

Benefits

Reduce CPU consumption and IT cost

Up to 25 percent CPU savings through optimization for best query access paths using machine learning technology.

Improve Db2 application performance

Db2 for z/OS applications run faster and more efficiently and therefore use less MIPs.

Learn patterns from the collected data

Rapid model learning specific to the data and application behavior per subsystem without requiring data science skills.

Product images

How customers use it

  • Man working on computer in an office

    Identify and resolve Db2 connection problems before they happen

    Problem

    In today’s complex cloud, mobile and IoT environments, new applications are configured to access Db2 more rapidly than ever before. Db2 for z/OS is still the undisputed leader for storing and harnessing mission-critical data. It remains the “gold standard” for system availability, scalability, security and cost-effectiveness; however, spikes in uncontrolled connections can lead to degradations in application performance and system availability.

    Solution

    Db2 AI for z/OS v1.3 automatically learns about connection and thread behavior of remote applications and then recommends Db2 profile controls that can prevent connection flooding from impacting other applications. This feature will identify whether applications are configured for optimal performance and reuse of threads.

  • woman working on computer

    Improve Db2 for z/OS application performance

    Problem

    Optimizing the performance of database systems and applications is time consuming and costly. According to IBM Distinguished Engineer John Campbell, database administrators can spend as much as 25 to 30 percent of their time managing application performance and tuning SQL queries.

    Solution

    Using the Db2 for z/OS optimizer and leveraging IBM machine learning for z/OS technology, Db2 AI for z/OS exploits new intelligence to identify optimal access paths for SQL queries, uniquely based on your workload characteristics.

  • Overhead view of man working on laptop

    Save time and reduce costs

    Problem

    Today’s complex environments require skill sets even beyond the abilities of accomplished database administrators. Organizations with Db2 for z/OS are looking for new approaches to improve IT operations by using machine learning and AI technology.

    Solution

    Db2 AI for z/OS embeds machine learning services in the Db2 for z/OS engine to:
    • Gain insight into the health of IBM Db2 for z/OS subsystems
    • Help maintain optimal performance of Db2 systems
    • Reduce IT operational cost and time