How to solve ADM10501W and ADM10502W in DB2

Posted on 2009-02-19
Last Modified: 2012-06-27
Hello Experts
I've been asked to identify the root causes for the following warnings in DB2:
MESSAGE : ADM10501W  Health indicator "Monitor Heap Utilization"
          ("db2.mon_heap_util") breached the "upper" warning threshold of "85
          %" with value "88 %" on "instance" "db2cpd". Calculation:
          "((db2.mon_heap_cur_size/db2.mon_heap_max_size)*100);" = "((458752 /
          524288) * 100)" = "88 %".  History (Timestamp, Value, Formula): "()"
MESSAGE : ADM10502W  Health indicator "Database Backup Required"
          ("db.db_backup_req") is in state "Manual backup required" on
          "database" "db2cpd.CPD     ".
MESSAGE : ADM10502W  Health indicator "Table Space Operational State"
          ("ts.ts_op_status") is in state "Backup in progress" on "table space"
          "db2cpd.CPD     .SYSTOOLSPACE".

We're running on DB2 ver 8.2
Question by:contacto_rangel
    1 Comment
    LVL 57

    Accepted Solution

    To bring Monitor Heap Utilization back to normal either increase the db2.mon_heap_cur_size or decrease the db2.mon_heap_max_size in DB2 configurations.

    Database Backup Required message indicates that after the last backup most of the things have changed and hence the server is waiting for whole set of builds.

    To resolve Table Space Operational State, either add a new tablespace or file group to the current one.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now