Db2 for z/OS - The AI Database



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

By Paul McWilliams posted Fri February 14, 2020 01:41 PM

By Patrick Bossman, Paul Bartak, and Paul McWilliams.

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.

Patrick Bossman is a STSM for Db2 for z/OS, Paul Bartak is a Principle Solutions Advisor for Db2 Tools for z/OS,  and Paul McWilliams is an  Information Developer for Db2 for z/OS.