ADHQ2058E IN-COLLECTOR ELAPSED TIME LIMIT EXCEEDED FOR THREAD thread_id
ExplanationThe monitoring agent has been detected to be
consuming CPU for a period of time greater than specified in the HM_TIME_LIMIT parameter in
ADHPARMS. The thread_id is the Db2 thread token for the thread consuming the
CPU, ssid is the Db2 subsystem running the thread, and
plan_name is the plan name the thread was executing.
User responseReview the ADHPARMS parameters HM_DUMPS and
HM_TIME_LIMIT (these set the thresholds for in-collector health monitoring). In environments with
high CPU contention, the HM_TIME_LIMIT parameter value might need to be increased to avoid false
positives. An SVCDUMP will be taken if the HM_DUMPS limit has not been met. If you encounter this
message and receive a dump, contact IBM Software Support.