Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2007
    Posts
    288

    Unanswered: db2 memory problem?

    DB2 on Windows. DB2 Ver 9.1.0.356 (fixpack 1)

    getting this error over and over for each Database in the instance.. then it crashes..

    any ideas???

    Code:
    2008-10-14-12.45.53.189000-240 I134731388H649     LEVEL: Error
    PID     : 4424                 TID  : 5116        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : UATREPO
    APPHDL  : 0-12032              APPID: *LOCAL.DB2.081007234204
    AUTHID  : OPETLUAT
    EDUID   : 5116                 EDUNAME: db2stmm (UATREPO) 0
    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, 78 bytes
    Error updating parameter Database_memory, updateValue = 32820, sqlcode = -5047

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I would guess you are running out of memory. Maybe if you turn off STMM this might go away.

    Andy

  3. #3
    Join Date
    Dec 2007
    Posts
    288
    4 GB of memory on the box. One instance with 10 databases and everything is set to automatch. it is a datawharehouse so there is not a whole lot of activity at any one time.

    also getting this in the diaglog I've looked it up but I really don't understand that it is telling me... can anyone help?


    Code:
    2008-10-15-12.22.32.731000-240 E453392H794        LEVEL: Warning
    PID     : 4072                 TID  : 5660        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : PMODM
    APPHDL  : 0-7737               APPID: *LOCAL.DB2.081015162248
    AUTHID  : ISJXR18
    EDUID   : 5660                 EDUNAME: db2agent (PMODM) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
    MESSAGE : ADM6073W  The table space "TEMPSPACE2" (ID "11") is configured to use
    
              buffer pool ID "4", but this buffer pool is not active at this time.
              In the interim the table space will use buffer pool ID "4099".  The
              inactive buffer pool should become available at next database startup
    
              provided that the required memory is available.
    
    2008-10-15-12.22.32.731000-240 I454188H545        LEVEL: Severe
    PID     : 4072                 TID  : 5660        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : PMODM
    APPHDL  : 0-7737               APPID: *LOCAL.DB2.081015162248
    AUTHID  : ISJXR18
    EDUID   : 5660                 EDUNAME: db2agent (PMODM) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:620
    DATA #1 : String, 71 bytes
    Database will come up with hidden buffer pools.
    totalBufferPoolPages:
    DATA #2 : signed integer, 8 bytes
    64

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Looks like you've allocated more memory to one of the bufferpools than is available (or the self-tuning memory manager has taken it away). Use
    Code:
    select * from syscat.bufferpools where bufferpoolid=4
    to determine which bufferpool it is and what is its size, then reduce it to a more realistic value.

    As an aside, I find that STMM is quite buggy; I was forced to disable it completely to avoid random DB2 crashes.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •