Enable Db2 for z/OS optimizer to leverage machine learning

Man working on laptop

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. Additionally, the product enables you to learn program variable values for each SQL and learn number of rows fetched by application.

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

  • person on a laptop typing on the keyboard

    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.

  • people in a classroom with whiteboards and computers

    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