In this session, we will explore how Ansible can be used to modernize Db2 for z/OS system management by automating routine administrative tasks. Db2 System Programmers and DBAs typically perform many day-to-day tasks manually. When these tasks need to be executed across an entire SYSPLEX, they become time-consuming, error-prone, and cumbersome. By utilizing Ansible’s built-in modules and integrating with Db2 RESTful APIs, these processes can be automated, reducing manual effort, and improving accuracy. This session will focus on: Introduction to Ansible: A quick start on using Ansible on z/OS, including an overview of Ansible’s built-in modules. Integration of Db2 RESTful API with Ansible: Demonstrating how to use the Db2 RESTful API with Ansible playbooks to automate common Db2 management tasks. Practical Use Case: Walkthrough of a real-world example where Ansible playbooks are used to automatically retrieve and compare the Db2 zparm setting from all active Db2 regions, eliminating the need for manual intervention. By the end of this session, attendees will have an understanding of how to write and execute Ansible playbooks on z/OS. This session will empower attendees with the knowledge of modern automation practices that can be applied in their z/OS environments.
