IBM Support

PI79560: REMOVE UI45126 PTF BECAUSE IT IS BUILT WITH WRONG DISTLIB(ADSNSAMP). 17/05/10 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

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.



Document information

More support for: DB2 for z/OS

Software version: B10

Reference #: PI79560

Modified date: 02 August 2017


Translate this page: