IBM Support

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



Document information

More support for: DB2 for z/OS

Software version: C10

Reference #: PI73492

Modified date: 17 May 2017


Translate this page: