A fix is available
APAR status
Closed as program error.
Error description
UI45126 PTF is built with incorrect DISTLIB(ADSNSAMP) for SYSLIB(SDSNSAMP), DISTLIB(ADSNMACS) should be used instead. This apar will remove the PTF UI45126. A new apar PI79222 will be used to create correct PTF.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 11 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: There is a build error in UI45126 * * (fixing PTF for PI73168). * * Accept of this PTF fails with return * * code 8 and these messages: * * GIM54502E ** ALLOCATION FAILED FOR * * ADSNSAMP BECAUSE THERE IS NO DD * * STATEMENT IN THE JCL AND NO DDDEF * * ENTRY IN zonetype ZONE zonename. * * * * GIM28307E ** ALLOCATION FAILED FOR * * ADSNSAMP, WHICH IS REQUIRED IN ORDER * * TO PROCESS ELEMENT DSNCPDCD IN SYSMOD * * UI45126. * * * * GIM22601I ACCEPT PROCESSING * * FAILED FOR SYSMOD UI45126. * **************************************************************** * RECOMMENDATION: * **************************************************************** APAR PI73168 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. However, PTF UI45126, the fixing PTF for PI73168, is built with an incorrect DISTLIB value (ADSNSAMP), instead of ADSNMACS, on the ++SAMP card when SYSLIB is SDSNSAMP. This error also causes accepting the PTF to fail with errors noted in the problem description because DSNALLOC and DSNDDEF1 in SDSNBASE do not specify ADSNSAMP.
Problem conclusion
This APAR supersedes PI73168. It deletes the parts that were incorrectlydefined in PTF UI45126 as: ++ SAMP (name) DISTLIB(ADSNSAMP) SYSLIB(SDSNSAMP) and reships the parts that were defined correctly in PTF UI45126 as: ++ SAMP (name) DISTLIB(ADSNIVPD) SYSLIB(SDSNIVPD) This APAR and APAR PI79222 deliver 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 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 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 10 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 PI71068 is required. Under z/OS V2R2, z/OSMF V2R2 APAR PI70526 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.
Temporary fix
Comments
APAR Information
APAR number
PI79560
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-04-06
Closed date
2017-06-26
Last modified date
2017-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI48324
Modules/Macros
DSNCPDAT DSNCPDCD DSNCPDCM DSNCPDCR DSNCPDCT DSNCPDDD DSNCPDDM DSNCPDDP DSNCPDDR DSNCPDDT DSNCPDGU DSNCPDIV DSNCPDRM DSNCPDRU DSNCPDWD DSNCPLAT DSNCPLCM DSNCPLCR DSNCPLCT DSNCPLDD DSNCPLDM DSNCPLDP DSNCPLDR DSNCPLDS DSNCPLDT DSNCPLGU DSNCPLIV DSNCPLPS DSNCPLRM DSNCPLRU DSNCPLWD DSNCPSAT DSNCPSCD DSNCPSCM DSNCPSCR DSNCPSCT DSNCPSDD DSNCPSDM DSNCPSDP DSNCPSDR DSNCPSDT DSNCPSGU DSNCPSIV DSNCPSLD DSNCPSRM DSNCPSRU DSNCPSWD
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI48324
UP17/07/19 P F707 Ø
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":"11.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":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 August 2017