IBM Support

PI73168: PROVISION SCHEMA WITH ZOSMF WORKFLOWS

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • Provision schema with zOSMF workflows.
    

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: 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 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 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

Temporary fix

Comments

  • ×**** PE17/05/10 FIX IN ERROR. SEE APAR PI79560  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PI73168

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-12-02

  • Closed date

    2017-02-28

  • Last modified date

    2017-06-26

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI45126

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 UI45126

       UP17/03/15 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.



Document information

More support for: DB2 for z/OS

Software version: B10

Reference #: PI73168

Modified date: 26 June 2017


Translate this page: