Start of change

Creating services for provisioning Db2 for z/OS (DBaaS)

You can use the sample Db2 software services template to create a service that rapidly provisions multiple Db2 for z/OS subsystems or data sharing groups, and deprovision them later.

Before you begin

Various administrators must provide information and prepare the z/OS environment for the Db2 software service template. For a list of these tasks, see Preparing the environment for the Db2 software service template in the readme file in GitHub.

Configure z/OSMF Version 2.3 with APAR PH09130 or higher.

About this task

The sample runs as a software service template in IBM Cloud® Provisioning and Management for z/OS. For an overview, see IBM Cloud Provisioning and Management for z/OS .

You can use the sample Db2 software service template, to build your own Db2 software service template to provision multiple stand-alone Db2 12 for z/OS subsystem instances, or an n-way data sharing group (cluster), in a typical Db2 configuration based on the latest best practices. For details, see About the sample Db2 software service template in the readme file in GitHub.

The sample Db2 software service template also makes the following actions available in the service, for the provisioned Db2 subsystems:

  • Start Db2.
  • Stop Db2.
  • Display DDF information.
  • Start of changeDisplay group information.End of change
  • Enable optional features ( Db2 REST services, ODBC, and JDBC).
  • Deprovision the provisioned Db2 subsystem.
Tip: Start of changeAn alternative to using the sample Db2 software service template is to run the installation CLIST to generate the required artifacts. This approach supports more customization of the provisioned Db2 subsystems than the sample Db2 software service template. For more information, see Creating artifacts for provisioning Db2 by running the installation CLIST.End of change

Procedure

To create services for provisioning Db2 subsystems or data sharing groups:

  1. Download and prepare the sample template:
    1. Start of changeObtain the artifacts for the sample template by downloading the appropriate pax file from GitHub at https://github.com/IBM/Db2ZTools/tree/master/DevOps/Db2SystemServices/Db2ProvisionSystemNonDS.End of change
      Db2 system type Artifacts pax file
      Db2 data sharing Db2ProvisionSystemDS.pax
      Stand-alone Db2 Db2ProvisionSystemNonDS.pax
    2. Upload the file by using FTP in binary mode to a directory in z/OS UNIX System Services.
    3. Extract the pax file into the directory of your choice.
      Db2 system type Example command
      Db2 data sharing 
      pax -rvf Db2ProvisionSystemDS.pax
      Stand-alone Db2 
      pax -rvf Db2ProvisionSystemNonDS.pax
    4. Start of change If you are using the sample artifacts before building your own template, you must update the dsntivin input variable file, and the dsntivia file for data sharing, with values for your installation, as described in the Specifying input properties section of the Readme file.End of change
  2. Test the provisioning template, verify the provisioned Db2 system, and test the deprovisioning process.
  3. Publish the template to make it available to consumers.
End of change