Db2 for z/OS and its ecosystem

This Db2 for z/OS News from the Lab blog blog entry was originally published on 2019-11-08.

By Tim Hogan.

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.

Version 1.2.0.2 delivers the following new capabilities:

• with the IBM Db2 AI for z/OS SQL optimization function you can manually lock in or unlock the access paths for static or dynamic SQL statements.

• a RESTful API to schedule a system assessment in order to understand system health status or to detect a tuning opportunity.

• a simplified installation process that reduces the amount of time to get your system up and running.