IBM Support

PM94227: DB2 10 AND 11 FOR Z/OS: DSN6SPRM.PLANMGMTSCOPE PARAMETER ACCEPTS INVALID SETTINGS OF 'ALL' AND 'DYNAMIC'

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 10 AND 11 FOR Z/OS: The DSN6SPRM.PLANMGMTSCOPE parameter
    accepts invalid settings of ALL and DYNAMIC.  The only valid
    setting is STATIC.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of the DSN6SPRM.PLANMGMTSCOPE      *
    *                 subsystem parameter in DB2 10 for z/OS and   *
    *                 DB2 11 for z/OS are affected by this change. *
    ****************************************************************
    * PROBLEM DESCRIPTION: The PLAN MANAGEMENT SCOPE field on DB2  *
    *                      installation panel DSNTIP8 accepts      *
    *                      undocumented settings of ALL and        *
    *                      DYNAMIC.                                *
    ****************************************************************
    * RECOMMENDATION: Apply the fixing PTF for this APAR.          *
    ****************************************************************
    The PLAN MANAGEMENT SCOPE field on panel DSNTIP8 is used by the
    DB2 installation CLIST to gather the local setting for the
    PLANMGMTSCOPE subsystem parameter, which in turn specifies the
    defasult plan management scope to use when the PLANMGMTSCOPE
    option is not explicitly specified for the bind or rebind of a
    package.
    
    Currently, this field accepts 3 settings: ALL, DYNAMIC, and
    STATIC.  However, only the STATIC setting is documented.
    

Problem conclusion

  • In response, this APAR modifies DSNTIP8 to permit only STATIC
    in the PLAN MANAGEMENT SCOPE field.  Other PLANMGMTSCOPE
    settings from the CLIST input (DSNTIDxx) member are converted
    to STATIC.  The DSN6SPRM macro continues to accept PLANMGMTSCOPE
    settings of ALL and DYNAMIC but these are now described as
    serviceability only and should not be used without guidance from
    IBM.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM94227

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-31

  • Closed date

    2013-10-03

  • Last modified date

    2013-11-04

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

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

    UK98198 UK98202

Modules/Macros

  • DSNTIP8  DSN6SPRM
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK98198

       UP13/10/20 P F310

  • RB10 PSY UK98202

       UP13/10/18 P F310

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":"10.1","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":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 November 2013