Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    35

    Unanswered: db2 memory problem

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2004
    Posts
    35
    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?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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