Integrating Db2 for z/OS database changes into a CI/CD pipeline

A draft IBM Redpaper publication

Updated 20 July 2021

cover image

IBM Form #: REDP-5646-00

More options

Rate and comment

Authors: Maryela Weihrauch, Frank van der Wal, Rafael Toshio Saizaki, Kendrick Ren, Eric Radzinski, Hendrik Mynhard, Benedict Holste, Maria Sueli Almeida

Abstract

The goal of this IBM Redpaper is to demonstrate the ability to perform single click automated deployments of multi-platform applications that include Db2 for z/OS database schema changes by exploiting the capabilities of IBM Db2 DevOps Experience for z/OS.

Pushing the application and database code changes to a source control management system (SCM) triggers a single CI/CD pipeline execution for both application and database changes, and therefore mitigates the dependency on the DBA to deploy those database changes in a separate process. At the same time, DBAs can safeguard the integrity of their organization's data by implementing site rules in Db2 DevOps Experience. DBAs define whether a schema change can be approved automatically after all site rules are satisfied or whether it must be approved manually.

We provide an overview of the CI/CD pipeline architecture in the context of a sample application. We also describe the steps that are relevant to the roles of the DevOps engineer who implements the enterprise CI/CD pipeline, the DBA who is responsible for database code changes in Db2 for z/OS and for defining site rules that ensure quality in production, and the application developer who changes the application code and communicates requirements for changes in the database schema.

Code samples for the demo application used in this Redpaper can be downloaded at https://github.com/IBMRedbooks/REDP-5646-Db2-for-z-OS-DevOps-Experience.

Table of contents

Chapter 1. Introduction
Chapter 2. Db2 database code changes in the CI/CD pipeline
Chapter 3. Description of the sample application
Chapter 4. Architectural overview
Chapter 5. Code repository organization
Chapter 6. Delivering database changes at the same speed as application changes
Chapter 7. IBM UrbanCode Deploy
Chapter 8. Jenkins
Chapter 9. Application development tools for z/OS
Chapter 10. Application change execution and documentation of the demo
Chapter 11. Conclusion

These pages are Web versions of IBM Redbooks- and Redpapers-in-progress. They are published here for those who need the information now and may contain spelling, layout and grammatical errors. This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. Your feedback is welcomed to improve the usefulness of the material to others.

Follow IBM Redbooks

Follow IBM Redbooks