Ask a question
Limited-Time Offer: 50% off IBM TechXchange Conference 2025
IBM’s largest technical learning event is back October 6-9 in Orlando, FL
By Bob Bersano, Kate Wheat, and Mac Gupta
IBM Db2 Automation Expert for z/OS is a new product offering that brings intelligence and automation to Db2 maintenance, eliminating the need for deep z/OS skills. By offering a rich API library and integration into modern tool sets, Db2 Automation Expert not only provides a familiar framework to the next generation of DBAs but also helps experienced DBAs with limited time and resources.
For example, Db2 Automation Expert provides REST APIs to generate Db2 utility statements according to best practices and shop standards. Such APIs remove the burden on the engineer to understand the intricacies of utility syntax. Other provided APIs allow you to execute the generated utilities in a DevOps pipeline.
Additionally, Db2 Automation Expert provides sample ansible playbooks. Ansible playbooks are blueprints of automation tasks; actions are executed with limited or no human involvement. For example, one provided playbook can evaluate objects against exception profiles to decide whether maintenance is required and if so, generate the utility JCL for that object using the parameters in a utility profile. This playbook eliminates the need to know complex JCL.
Here's an example of running this Ansible playbook:
And here’s the generated JCL:
You can integrate these playbooks from Db2 Automation Expert into your existing Ansible workflows.
These APIs and playbooks are just some of the features of this new tool. For more information about Db2 Automation Expert, see https://www.ibm.com/docs/daefz/1.1.0 and Ansible playbook samples. Also, check out this video about Db2 Automation Expert. You can also read the other blogs in this series:
Bob Bersano is a Principal Solutions Advisor at Rocket Software.
Kate Wheat is a Senior Information Developer at Rocket Software.
Mac Gupta is Senior Director in Marketing at Rocket Software.
#IBMChampion