db2 memory problem?

itsonlyme44 · #1 (**permalink**) 10-14-08, 15:57

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

ARWinner · #2 (**permalink**) 10-14-08, 16:35

I would guess you are running out of memory. Maybe if you turn off STMM this might go away.

Andy

itsonlyme44 · #3 (**permalink**) 10-15-08, 12:54

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

n_i · #4 (**permalink**) 10-15-08, 13:08

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech