Hi all,
We need help solving a memory issues in our site, we
running db2 9.5 express c on linux
and we encounter memory problem
the db2diag generating:

2011-05-18-03.42.45.566566-240 I4183E1457 LEVEL: Severe
PID : 14212 TID : 183140084064 PROC : db2sysc
INSTANCE: db2inst NODE : 000 DB : RESEARCH
APPHDL : 0-55893 APPID: 10.28.6.156.54405.110516125127
AUTHID : DB2RERCH
EDUID : 26564 EDUNAME: db2agent (RESEARCH)
FUNCTION: DB2 UDB, SQO Memory Management, sqloFreeMemorySubPool, probe:1020
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid memory addr"
DIA8561C A invalid memory block was encountered.
DATA #1 : String, 38 bytes
sqloGetMemChunks not explicitly freed.
DATA #2 : unsigned integer, 8 bytes
246
CALLSTCK:
[0] 0x0000002A9683898D sqloFreeMemorySubPool + 0x211
[1] 0x0000002A964C2AFF _Z24sqlbFreeAllPageAndBPDMemP12SQLB_GLOBALSP16sqeL ocalDatabaseP15SQLB_BufferPool + 0x181
[2] 0x0000002A964DD01D _Z18sqlbTermBufferPoolP16sqeLocalDatabaseP9SQLB_BP CBP15SQLB_BufferPoolP12SQLB_GLOBALS + 0xA5
[3] 0x0000002A964DCDD9 _Z8sqlbtermP12SQLB_GLOBALS + 0xC3
[4] 0x0000002A9659C93A _ZN16sqeLocalDatabase7CleanDBEP5sqlca + 0x302
[5] 0x0000002A9659BBC0 _ZN16sqeLocalDatabase13TermDbConnectEP8sqeAgentP5s qlcai + 0xDC2
[6] 0x0000002A9657E209 _ZN14sqeApplication12AppStopUsingEP8sqeAgenthP5sql ca + 0x635
[7] 0x0000002A965C1716 _Z11sqlesrspWrpP14db2UCinterface + 0x96
[8] 0x0000002A965C1949 sqleUCagentConnectReset + 0xA1
[9] 0x0000002A96613217 /opt/ibm/db2/V9.5/lib64/libdb2e.so.1 + 0x1095217

2011-05-18-03.42.45.667172-240 I5641E609 LEVEL: Error
PID : 14212 TID : 183140084064 PROC : db2sysc
INSTANCE: db2inst NODE : 000 DB : RESEARCH
APPHDL : 0-55893 APPID: 10.28.6.156.54405.110516125127
AUTHID : DB2RERCH
EDUID : 26564 EDUNAME: db2agent (RESEARCH)
FUNCTION: DB2 UDB, buffer pool services, sqlbFreeAllPageAndBPDMem, probe:610
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid memory addr"
DIA8561C A invalid memory block was encountered.
DATA #1 : String, 28 bytes
sqloFreeMemorySubPool failed


the database is running Self tuning memory

Thank you for time and help

I am not sure which release of 9.5 you are using, but there were a lot of bugs using STMM and Linux in early 9.5 releases. IBM stopped enhancing DB2 Express-C 9.5 once that 9.7 was made available, and you cannot apply the latest 9.5 fixpacks to Express-C.

I would consider upgrading to DB2 Express-C 9.7.4. I believe you will have to backup the database, de-install 9.5, install 9.7.4 Express-C, and then restore database backup. But I would read the DB2 Express-C upgrade instructions for more details.

If you can't upgrade, then try hard-coding your bufferpools (not use -2), and make sure the total size of all bufferpools is about 1 GB or less for 64-bit Linux, or about 750 MB or less for 32-bit Linux.

Thank you for the answer at the moment we will first try to configure the buffer pool.
can you advise us please in the case of 2 databases and 3 buffer pools
one database very small usage as configuration db using 4k bp and
second database bigger size (100GB) one main buffer pool is 4k and second bp is 8k
main usage for inserting and retrieving large amount of data.
which config would you suggests to start with?

I believe that there is 2 GB limit for DB2 Express-C in the amount of memory that can used by DB2 in total. So I would suggest that the total amount of bufferpool memory for all databases be configured to 1 GB or less. If you have a 32-bit version of DB2, I would recommend no more than 750 MB for the sum of all bufferpools.