Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2006
    Posts
    7

    Unanswered: Database HEap Size question

    How do I know which dbms is causing this health monitor alert? I'm new to DB2 UDB. Thanks

    ADM10500E Health indicator "Monitor Heap Utilization" ("db2.mon_heap_util") breached the "upper" alarm threshold of "95 %" with value "102 %" on "instance" "DB2". Calculation: "((db2.mon_heap_cur_size/db2.mon_heap_max_size)*100);" = "((835584 / 819200) * 100)" = "102 %". History (Timestamp, Value, Formula): " (11/13/2006 10:10:22.307000, 82, ((671744 / 819200) * 100)), (11/13/2006 10:05:22.354000, 82, ((671744 / 819200) * 100)), (11/13/2006 10:00:21.682000, 82, ((671744 / 819200) * 100)), (11/13/2006 09:55:22.495000, 82, ((671744 / 819200) * 100)), (11/13/2006 09:50:22.526000, 82, ((671744 / 819200) * 100)), (11/13/2006 09:45:22.604000, 82, ((671744 / 819200) * 100)), (11/13/2006 09:40:21.792000, 82, ((671744 / 819200) * 100)), (11/13/2006 09:35:21.839000, 82, ((671744 / 819200) * 100)), (11/13/2006 09:30:22.151000, 82, ((671744 / 819200) * 100))"

  2. #2
    Join Date
    Jul 2002
    Posts
    48
    How many databases you have under instancd "DB2". Thanks

  3. #3
    Join Date
    Nov 2006
    Posts
    7

    About 130 or so.

    A lot of databases for a program product that requires a new database for each department using the application. It's the Rational products from IBM. Why doesn't the error message give the database name? Should I be looking at the db2diag.log file?

    Thanks
    Rob

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by lavalamp1964
    Why doesn't the error message give the database name?
    Because the monitor heap is allocated in the instance (database manager) memory.

  5. #5
    Join Date
    Nov 2006
    Posts
    7
    I got it. Thanks. It's mon_heap_sz at the database level. I increased it about 20%.

Posting Permissions

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