Db2 for z/OS and its ecosystem

 View Only

Announcing Db2 AI for z/OS 1.3.0!

By Emily Alameida posted Mon June 22, 2020 01:48 PM

by Tim Hogan, Emily Alameida, and Eric Radzinski
Db2® AI for z/OS® (“Db2ZAI”) empowers the optimizer in your Db2 for z/OS engine to determine the best-performing query access paths, based on your workload characteristics. In addition, Db2ZAI detects Db2 system performance exceptions and provides recommended actions for tuning, which are based on your environment. 
  • A major new feature of Db2ZAI 1.3.0 is Distributed Connection Control, which provides protection for Db2 for z/OS from unintentional disruptions and intrusions that can originate from remote applications. This feature helps you to evaluate, monitor, and regulate the usage levels of connections and threads within your Db2 systems so that you can identify problems before they affect application performance.
  • Another major new feature of this latest release is automated SQL regression detection and resolution. Db2ZAI will now detect when an access path has degraded compared to a prior access path, and will automatically lock in and fall back to the prior better-performing access path. This self-healing capability enables Db2ZAI to resolve regressions without intervention by a database administrator, thus saving valuable time and effort.
  • The threshold for self-healing automation is customizable, giving you the ability to specify the conditions for Db2ZAI to automatically execute a fallback. This provides much-needed flexibility for complex environments that require continuous tuning to ensure uptime and responsiveness.
  • The IBM Db2 AI for z/OS System Assessment feature now provides an enhanced exception analysis experience, in which exceptions are categorized into general regions of interest to system programmers (such as CPU, storage, and connectivity) to allow a more immediate identification of problem areas.
  • Once the problems are identified, Db2ZAI provides a correlation graph that enables system programmers to quickly align an anomaly with a particular system attribute and activity. Such correlation is critical to the timely prevention and resolution of system anomalies before they become debilitating system errors.
We hope that you explore the new capabilities of Db2ZAI 1.3.0 and what it can do for your business.

Tim Hogan, Emily Alameida, and Eric Radzinski are Information Developers for Db2 for z/OS and Db2AI for z/OS

Sign in and subscribe to always get the latest news about Db2 for z/OS from the IBM lab: http://ibm.biz/db2znews-subscribe