A fix is available
APAR status
Closed as new function.
Error description
Provision schema with zOSMF workflows
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All DB2 12 for z/OS users who plan to * * provision a static schema, a schema like * * and a database through the usage of * * z/OSMF workflow. * **************************************************************** * PROBLEM DESCRIPTION: * * This APAR includes z/OSMF workflow * * definitions, z/OSMF workflow * * input variable files and tailored JCL * * templates. These artifacts are used to * * provision a static schema, to * * provision a schema like, and to * * provision a database through z/OSMF * * workflow. * **************************************************************** * RECOMMENDATION: * * Apply PTF. * **************************************************************** This APAR delivers 3 z/OSMF workflows which can be used to provision a static schema with DDL input, to provision an empty database with DDL input, and to provision a schema like that from a source environment onto a target environment. The artifacts of each workflow include a workflow definition file, a workflow input variable file and a set of tailored JCL templates. Each set of artifacts can be used in z/OSMF to create a workflow instance using z/OSMF workflow task or to create a workflow template using z/OSMF cloud provisioning services task provided with IBM Cloud Provisioning and Management for z/OS. Executing the workflow instance can automatically provision a schema or database with the inputs on the target environment. Creating a workflow template can allow a group of authorized users to share the same template to create workflow instances from the template to provision a schema or a database automatically. For more information about z/OSMF, see IBM z/OS Management Facility Programming Guide (SC27-8420). This APAR provides the following sample workflow artifacts in 3 sets. The first set is for provisioning a database: DSNCPDRM - the readme file describing how to use the workflow artifacts to create the workflow template or instance to provision a database DSNCPDWD/DSNCPDIV - the sample workflow definition file and input variable file to provision a database DSNCPDAT - the actions definition for the workflow template to provision/deprovision a database DSNCPDDP - the workflow definition file to deprovision a database DSNCPDCD/DSNCPDDD - the JCL template for creating/dropping a database DSNCPDCM/DSNCPDDM - the JCL template for creating/removing RACF distributed map id DSNCPDCR/DSNCPDDR - the JCL template for creating/removing RACF group and user id DSNCPDCT/DSNCPDDT - the JCL template for creating/removing trusted context DSNCPDGU/DSNCPDRU - the JCL template for granting/revoking user privileges The second set is for provisioning a static schema: DSNCPSRM - the readme file describing how to use the artifacts to create the workflow template or instance to provision a static schema DSNCPSWD/DSNCPSIV - the sample workflow definition file and input variable file to provision a static schema DSNCPSAT - the actions definition for the workflow template to provision/deprovision a static schema DSNCPSDP - the workflow definition file to deprovision a schema DSNCPSCD/DSNCPSDD - the JCL template for creating/dropping a static schema DSNCPSLD - the JCL template for loading sample data DSNCPSCM/DSNCPSDM - the JCL template for creating/removing RACF distributed map id DSNCPSCR/DSNCPSDR - the JCL template for creating/removing RACF group and user id DSNCPSCT/DSNCPSDT - the JCL template for creating/removing trusted context DSNCPSGU/DSNCPSRU - the JCL template for granting/revoking user privileges The third set is for provisioning a schema like: DSNCPLRM - the readme file describing how to use the artifacts to create the workflow template or instance to provision a schema like that from a source environment DSNCPLWD/DSNCPLIV - the sample workflow definition file and input variable file to provision a schema like that from a source environment DSNCPLAT - the actions definition for the workflow template to provision/deprovision a schema like that from a source environment DSNCPLDP - the workflow definition file to deprovision a schema DSNCPLPS/DSNCPLDS - the workflow definition file to provision/ deprovision the security definition DSNCPLDD - the JCL template to deprovision a schema DSNCPLCM/DSNCPLDM - the JCL template for creating/removing RACF distributed map id DSNCPLCR/DSNCPLDR - the JCL template for creating/removing RACF group and user id DSNCPLCT/DSNCPLDT - the JCL template for creating/removing trusted context DSNCPLGU/DSNCPLRU - the JCL template for granting/revoking user privileges The z/OSMF workflow artifacts for DB2 require z/OS V2R1 or a subsequent release. Under z/OS V2R1, z/OSMF V2R1 APAR PI42725 is required. The z/OSMF artifacts of provision schema like workflow for DB2 requires IBM DB2 Change Management Solution Pack, specifically DB2 Administration Tool V11.2 with APAR PI67731/PI72396/PI76054 or a subsequent release.
Problem conclusion
The code is changed to deliver the new function.
Temporary fix
Comments
This APAR delivers z/OSMF workflow definitions, z/OSMF workflow input variable files and tailored JCL templates to provision a static schema, to provision a schema like, and to provision a database through z/OSMF workflow.
APAR Information
APAR number
PI73492
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-12-08
Closed date
2017-03-15
Last modified date
2017-05-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI45573
Modules/Macros
DSNCPSDT DSNCPDDR DSNCPSDR DSNCPLIV DSNCPDDP DSNCPSDP DSNCPSDM DSNCPLRM DSNCPDDM DSNCPDDD DSNCPLWD DSNCPLGU DSNCPDDT DSNCPSDD DSNCPSAT DSNCPDAT DSNCPDCT DSNCPDCR DSNCPDWD DSNCPDCM DSNCPSCM DSNCPLAT DSNCPDCD DSNCPDRU DSNCPLCT DSNCPSRU DSNCPLDD DSNCPSCR DSNCPDGU DSNCPSCT DSNCPSIV DSNCPDIV DSNCPLDP DSNCPLDS DSNCPLDR DSNCPSGU DSNCPDRM DSNCPLDM DSNCPSRM DSNCPSWD DSNCPLDT DSNCPSCD DSNCPLRU DSNCPLCR DSNCPSLD DSNCPLPS DSNCPLCM
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI45573
UP17/03/30 P F703
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
17 May 2017