Book description
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
- Front cover
- Notices
- Preface
- Chapter 1. Introduction
- Chapter 2. Db2 database code changes in the CI/CD pipeline
- Chapter 3. Sample application overview
-
Chapter 4. Architectural overview
-
4.1 High-level architecture
- 4.1.1 Steps 1, 2, and 3: Cloning, editing, and committing
- 4.1.2 Step 4: Automating the process with Jenkins
- 4.1.3 Step 5: Building the artifacts
- 4.1.4 Step 6: Storing the build output in a central repository
- 4.1.5 Steps 7 and 8: Moving the build output to the deployment stage
- 4.1.6 Step 9: Deploying the DDL into Db2 for z/OS by way of DOE
- 4.1.7 Step 10: Deploying the load modules in CICS and binding the DBRM
-
4.1 High-level architecture
- Chapter 5. Code repository organization
-
Chapter 6. Delivering database and application changes at the same speed
- 6.1 Db2 DevOps Experience architecture
- 6.2 Db2 DevOps Experience interactions with Db2 for z/OS
- 6.3 DOE terms and concepts
- 6.4 DOE roles and responsibilities
- 6.5 Establishing the landscape of Db2 subsystems, environments, and teams
- 6.6 Establishing the policy for database provisioning and schema changes
- 6.7 Defining Db2 site rules
- 6.8 DOE setup for DevOps engineer
-
Chapter 7. IBM UrbanCode Deploy
- 7.1 Introduction to IBM UrbanCode Deploy
-
7.2 Db2 DevOps Experience plug-in for UCD
- 7.2.1 DOE APIs used by the plug-in
- 7.2.2 Installing the DevOps Experience plug-in
- 7.2.3 Configuring UrbanCode Deploy
- 7.2.4 Creating roles and teams
- 7.2.5 Creating the component
- 7.2.6 Creating the component deployment process
- 7.2.7 Creating the resource
- 7.2.8 Creating the application
- 7.2.9 Associating the component with the application
- 7.2.10 Defining the process to install the component
- 7.2.11 Creating the environment for the application
- 7.2.12 Assigning the resources to the environment
- 7.2.13 Configuring notifications
- 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
- Related publications
- Back cover
Product information
- Title: Integrating Db2 for z/OS Database Changes Into a CI/CD Pipeline
- Author(s):
- Release date: September 2021
- Publisher(s): IBM Redbooks
- ISBN: 9780738459943
You might also like
book
DB2 SQL Tuning Tips for z/OS Developers
The Definitive Solutions-Oriented Guide to IBM® DB2® for z/OS®: Now Fully Updated for Both v9 and …
article
Run Llama-2 Models Locally with llama.cpp
Llama is Meta’s answer to the growing demand for LLMs. Unlike its well-known technological relative, ChatGPT, …
book
Foundation Db2 and Python: Access Db2 with Module-Based API Examples Using Python
Work with Db2 to write SQL and access databases using optimized code for the fastest response. …
book
DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition
IBM's definitive guide to writing DB2 SQL PL stored procedures, triggers, UDFs, and dynamic compound SQL …