Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2008
    Posts
    131

    Question Unanswered: heap utilization

    I am using db2 V9.5 ESE on windows.
    In the health center I got a warning saying:

    Health indicator name: database heap utilization
    Description:
    This indicator tracks the consumption of the monitor heap memory, based
    on the memory pool with the ID SQLM_HEAP_DATABASE. The utilization is
    calculated using the formula (db.pool_cur_size / db.pool_max_size) * 100
    for the Memory Pool Identifier SQLM_HEAP_DATABASE. Once this percentage
    reaches the maximum, 100%, queries and operations may fail because there
    is no heap available.

    Advisor suggests to increase the database heap size by updating the database configuration parameter ‘dbheap’. But it is already set to automatic. How can I modify this parameter to resolve the error???

    Machine details are: windows 2003
    RAM: 4GB
    HardDisk: 400GB

    There are hardly 3-4 applications running on the system.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The health monitor is a virus. It's only purpose is to convince potential customers that are considering their first purchase of DB2 LUW that it has automatic built-in health monitoring. The problem is that it does not actually work.

    db2 update dbm cfg using HEALTH_MON OFF
    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
    Jul 2008
    Posts
    131
    but how do i convince your point to my client\manager??? for them its an error in the health monitor and they want to get it resolved.

Posting Permissions

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