Integrating Db2 for z/OS Database Changes Into a CI/CD Pipeline
An IBM Redpaper publication
Published 03 September 2021, updated 13 September 2021
IBM Form #: REDP-5646-00
Rate and comment
Authors: Maryela Weihrauch, Frank van der Wal, Rafael Toshio Saizaki, Kendrick Ren, Eric Radzinski, Hendrik Mynhard, Benedict Holste, Maria Sueli Almeida
The goal of this IBM® Redbooks® publication is to demonstrate the ability to perform single click automated deployments of multi-platform applications that include IBM Db2 for z/OS database schema changes by using 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 application and database changes. Therefore, it 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.
In this publication, we e 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.
Table of contents
Chapter 1. Introduction
Chapter 2. Db2 database code changes in the CI/CD pipeline
Chapter 3. Sample application overview
Chapter 4. Architectural overview
Chapter 5. Code repository organization
Chapter 6. Delivering database and application changes at the same speed
Chapter 7. IBM UrbanCode Deploy
Chapter 8. Jenkins automation server
Chapter 9. Application development tools for z/OS
Chapter 10. Application change execution and demonstration documentation
Chapter 11. Summary
Appendix A. Additional material
Follow IBM Redbooks
Follow IBM Redbooks