• June 27, 2022

People are asking “What is Db2 DevOps Experience for z/OS?”

This article was originally published on the IBM community blog and was written in collaboration with Patrick Bossman, an STSM for Db2 for z/OS at IBM, Paul McWilliams, an Information Developer for Db2 for z/OS at IBM, and Paul Bartak, Principle Solutions Advisor for Db2 Tools for z/OS at Rocket Software.

IBM Db2 DevOps Experience for z/OS is where Db2 for z/OS meets DevOps. It is the IBM strategic product for bringing database as a service (DBaaS) to Db2 for z/OS. It makes Db2 for z/OS a first class citizen in fast delivery cycles by reducing data-friction, reducing wait time, and bolstering innovation.

Db2 DevOps Experience for z/OS introduces full user interface and REST API support for the following administration and operations capabilities:

  • Db2 Schema Database-as-a-Service
  • Database-as-code, with versioned source code management of DDL
  • Directives for participation, placement, naming, configuration, and limits
  • Integration into your DevOps pipelines via REST APIs
  • Administration & operations
  • Upstream and downstream DevOps processes
  • Monitoring of directives to control fast paced development activities on z/OS

Db2 DevOps Experience is a separately charged commercial offering, and one of the first commercial offerings built as a Zowe plugin. The user interface is a web application within the Zowe WebUi.

Empower your application developers for on-demand self-service for the full Db2 database portion of the application environment

  • Creating, modifying, approving, and merging database objects and routines including: Db2 database objects such as databases, table spaces, tables, indexes, columns, and more;  plus stored procedures, user-defined functions, and triggers.
  • The option to destroy all such objects created for development and test environments after these activities are complete.

Liberate your database administrators for higher value activities

  • Bring Db2 for z/OS objects into source control, for state-based database change management, with a Db2 for z/OS-optimized compare engine
  • Define Db2 database objects into a single DB2 DevOps Experience application, which is a defined group of Db2 objects that you can provision together as a group. The team members that own the application can change the application.
  • Define and enforce a variety of business rules, including limits on number of instances a user and team can create, space usage, naming conventions for objects, and database object properties.
  • Review and approve of database object changes submitted by team members.
  • Automate deployment of approved changes to other environments.

Equip your DevOps Engineers to automate deployments

  • Over 90 REST APIs that enable integrations with:
    •  CI/CD tools to perform automated deployments
    • Generation of the deployment process
    • Enable efficient review and approval of database changes and deployment processes.
  • The IBM Urban Code Deploy plugin, which exploits the REST APIs for performing automated deployments.
  • An add-on service for IBM Cloud Pak for Data is also available to extend “create schema like” self-services of Db2 application environments into IBM Cloud Pak for Data.

For more information, see the IBM Db2 DevOps Experience for z/OS V1.1 documentation in IBM Knowledge Center.

Paul Bartak 7 Posts

Paul Bartak has been working with IBM databases since 1985, including the first version of DB2 on MVS. As an IBM customer for 14 years Paul worked in Application Development, Database Administration, and DBA. He joined IBM in 1999 as an Information Management Technical Specialist, teaming with the Sales force to present, design, install, demonstrate, and evaluate IBM Information Management solutions in a pre-sales environment; gaining multiple certifications in Database Administration, Data Replication, Blockchain, and Cloud Computing. Paul developed the four generations of the DB2 Migration Planning Workshops from DB2 V8 for z/OS, to DB2 11 for z/OS; and enablement for Db2 for z/OS pureXML and Temporal features. Currently, as a Distinguished Engineer with Rocket Software, Paul is focused on the tools used to maximize DB2 for z/OS value, with emphasis in database cloning and DevOps processes. He supports multiple Db2 User Groups, has been a speaker at several IDUG and Insight/Think conferences, is a Redbook/Redpaper author, and IBM Champion.


Leave a Comment

Your email address will not be published.