Db2 for z/OS UCD template

The Db2 for z/OS UCD template shows examples of Db2 application provisioning and deployment, including deployment of database schema and stored procedure changes, Db2 native REST services, packages and DBRMs, invoking of Db2 utilities and commands, and integrating with the Db2 DevOps Experience for z/OS UCD plugin in UCD.

The template contains sample artifacts, processes to prepare the artifacts, environments, and an application which associates the artifacts, which demonstrate how you can use UrbanCode Deploy (UCD) to provision and deploy Db2 for z/OS database applications.

The Db2 for z/OS UCD template requires Db2 DevOps Experience for z/OS V1.1.0 with APARs PH1159 and PH11598, or higher and the Db2 DevOps Experience for z/OS UCD plugin to enable the following activities in UCD.

  • Provisioning a database schema instance for an application
  • Deprovisioning a database schema instance for an application
  • Deploying database schema changes, including the following tasks:
    • Comparing and analyzing the data objects in the committed schema changes against those in the target environments to derive the delta and to generate deployment plan with all necessary operations required to apply the changes.
    • Reviewing and approval of deployment plans, which is optional and can be skipped.
    • Applying the changes to the target environments.
    • Notifying users of events and schema changes through UCD capability.

You can also use the Db2 for z/OS UCD template template to enable the following activities in UCD.

  • Running Db2 utilities and commands, such as for binding packages, unloading and loading data, and so forth.
    • Accepting the input of existing bind cards for binding packages.
    • Supporting default bind options with the ability to overwrite the default bind options on certain target environments
  • Provisioning a database schema with DDL input
  • Deploying Db2 native REST services with executable SQL text, bind options, and grant statements as inputs
  • Dropping deployed REST services
  • Running SQL statements including CALL statements and CLP commands in batch mode, with the Db2 command line processor with RACF passticket

To download the Db2 for z/OS UCD template which includes a white paper that contains detailed configuration and usage instructions, see Db2 for z/OS® Package UCD.