IBM Support

IC70520: WHEN ALTERING BUFFERPOOL TO FIXED SIZE FROM AUTOMATIC IS DEFERRED, STMM WILL CONTINUE TO TUNE IT.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • A user-initiated alter of an automatic bufferpool will be
    deferred until the next database activation if there is not
    enough memory to satisfy this request or "deferred" option is
    specified explicitly. Such a deferred request will be forgotten
    if STMM decides to alter the same bufferpool before the next
    database activation. The problem is that STMM continues to tune
    this bufferpool, and changes made by STMM will override any
    previously deferred (hence saved) alter requests.
    

Local fix

  • 1) Try to issue an alter request that will likely be not
    deferred, for example altering to the same size will not get
    deferred, but the bufferpool will no longer be tuned by STMM.
    2) If the request does gets deferred while the bufferpool is
    still automatic, deactivate and reactivate the database before
    STMM gets a chance to tune the bufferpool.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error description field for more information.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 9.7 with Fixpack including IC70305.               *
    ****************************************************************
    

Problem conclusion

  • The problem will be fixed in 9.7 with IC70305.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC70520

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    910

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-08-11

  • Closed date

    2010-08-23

  • Last modified date

    2010-08-23

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

    IC70305

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

Fix information

Applicable component levels

  • R910 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
23 August 2010