Skip to main content

Integrating Db2 for z/OS Database Changes Into a CI/CD Pipeline

An IBM Redpaper publication

thumbnail 

Published on 03 September 2021, updated 13 September 2021

  1. .EPUB (2.3 MB)
  2. .PDF (4.4 MB)

Apple BooksGoogle Play BooksRead in Google Books
Share this page:   

ISBN-10: 0738459941
ISBN-13: 9780738459943
IBM Form #: REDP-5646-00


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

    menu icon

    Abstract

    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 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

     

    Others who read this also read