A fix is available
APAR status
Closed as program error.
Error description
PTF UI45126 in V11 is built with the wrong DISTLIB(ADSNSAMP) on the ++SAMP card when the SYSLIB is SDSNSAMP. It should be DISTLIB(ADSNMACS) instead. It causes maintenance apply problem for customer since DSNALLOC and DSNDDEF1 in DSNB10.SDSNBASE do not have provision for ADSNSAMP. This problem is only in DB2 11 for z/OS for UI45126/PI73168. DB2 12 for z/OS PTF UI45573/PI73492 is built correctly and has no problem.
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
In response, this APAR reships the parts that were incorrectly defined in PTF UI45126 as: ++ SAMP (name) DISTLIB(ADSNSAMP) SYSLIB(SDSNSAMP) with the correct definition: ++ SAMP (name) DISTLIB(ADSNMACS) SYSLIB(SDSNSAMP) This APAR and APAR PI79560 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 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 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 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
PI79222
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-03-31
Closed date
2017-06-29
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:
UI48422
Modules/Macros
DSNCPDCD DSNCPDCM DSNCPDCR DSNCPDCT DSNCPDDD DSNCPDDM DSNCPDDR DSNCPDDT DSNCPDGU DSNCPDRU DSNCPLCM DSNCPLCR DSNCPLCT DSNCPLDD DSNCPLDM DSNCPLDR DSNCPLDT DSNCPLGU DSNCPLRU DSNCPSCD DSNCPSCM DSNCPSCR DSNCPSCT DSNCPSDD DSNCPSDM DSNCPSDR DSNCPSDT DSNCPSGU DSNCPSLD DSNCPSRU
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI48422
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