IBM Support

IC70305: 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 program error.

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 Version 9.7 FixPack 4.                            *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.7 FixPack 4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC70305

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-07-30

  • Closed date

    2011-05-12

  • Last modified date

    2011-05-12

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

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

    IC70520 IC70521

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC70305

Modified date: 12 May 2011