IBM Support

PH13045: CHANGE THE MAXIMUM SETTING FOR RATIO ON THE ALTER GBPOOL COMMAND

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Raise the limit of RATIO on the ALTER GROUPBUFFERPOOL command
    from 255 to 1024, the default value of RATIO from 5 to 10.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 12 for z/OS data sharing users of                    *
    * ALTER GROUPBUFFERPOOL command.                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The maximum setting for RATIO on the                         *
    * ALTER GROUPBUFFERPOOL command should                         *
    * be raised with the progressive trend                         *
    * for larger size group buffer pools.                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    The maximum setting for RATIO on the ALTER GROUPBUFFERPOOL
    command is 255. With the progressive trend for larger size
    group buffer pools this limit should be raised too.
    
    The default of RATIO of 5 is also too small, especially for
    read intensive workloads.
    

Problem conclusion

Temporary fix

Comments

  • In this APAR, Db2 raises the limit of RATIO on the ALTER
    GROUPBUFFERPOOL command from 255 to 1024 and the default
    value of RATIO from 5 to 10.
    
    The documentations for the ALTER GROUPBUFFERPOOL command
    and messages DSNB800I and DSNB802I have been modified to
    reflect above changes.
    
    Please refer to ++HOLD DOC change for more information.
    

APAR Information

  • APAR number

    PH13045

  • 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

    2019-06-06

  • Closed date

    2019-07-03

  • Last modified date

    2019-08-01

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

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

    UI64068

Modules/Macros

  • DSNB1AGB DSNB1GBS DSNB1CMD
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI64068

       UP19/07/23 P F907

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

Document Information

Modified date:
01 August 2019