IBM Support

IC95659: STMM ON 32-BIT INSTANCE PLATFORM MAY FAIL TO UPDATE PCKCACHESZ WHEN IT IS WORKING ON 64-BIT WINDOWS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When DB2 STMM is working for a database of db2 32-bit instance
    on 64-bit Windows, DB2 STMM fails to update PCKCACHESZ db cfg
    parameters with over limited value for 32-bit instance as below.
    
    2013-02-13-13.27.12.006000+540 I1152713H977       LEVEL: Event
    PID     : 8052                 TID  : 7536        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : DB01
    APPHDL  : 0-20                 APPID: *LOCAL.DB2.130213025200
    AUTHID  : DB2ADMIN
    EDUID   : 7536                 EDUNAME: db2stmm (DB01)
    FUNCTION: DB2 UDB, Self tuning memory manager,
    stmmLogRecordBeforeResizes, probe:590
    DATA #1 : String, 525 bytes
    
    ***  stmmCostBenefitRecord ***
    Type: PCKCACHESZ
    PageSize: 4096
    Saved Misses: 11
    Benefit:
      -> Simulation size: 8913
      -> Total seconds saved: 2 (+ 326322613 ns)
      -> Normalized seconds/page: 1.32525E-006
    Cost:
      -> Simulation size: 8913
      -> Total seconds saved: 2 (+ 326322613 ns)
      -> Normalized seconds/page: 1.32525E-006
    Current Size: 89122
    Minimum Size: 2095
    Potential Increase Amount: 44561
    Potential Increase Amount From OS: 44561
    Potential Decrease Amount: 17824
    Pages Available For OS: 17824
    Interval Time: 196.947
    
    2013-02-13-13.27.12.022000+540 I1156264H635       LEVEL: Error
    PID     : 8052                 TID  : 7536        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : DB01
    APPHDL  : 0-20                 APPID: *LOCAL.DB2.130213025200
    AUTHID  : DB2ADMIN
    EDUID   : 7536                 EDUNAME: db2stmm (DB01)
    FUNCTION: DB2 UDB, Self tuning memory manager,
    stmmUpdateDBConfig, probe:275
    MESSAGE : ZRC=0x82AE00A7=-2102525785=STMM_CONFIG_UPDATE_FAILED
              "An attempted configuration update failed"
    DATA #1 : String, 74 bytes
    Error updating parameter Pckcachesz, updateValue = 133683,
    sqlcode = -5131
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * 32-bit instance user on 64-bit Windows                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 10.1 fixpack 4                        *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 version 10.1 fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC95659

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-02

  • Closed date

    2014-06-02

  • Last modified date

    2014-06-02

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

    IC90682

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 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":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 June 2014