Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2012
    Posts
    177

    Unanswered: Issue in DB2HMON Application

    Hi All,

    In our setup db2 v9.7 with fixpack 9.

    Facing issues in DB2HMON application is hold with SYSIBM.SYSTABLES.

    Agent Application Application Object Lock Object Lock Lock Is
    Id(State) Name Status Name Mode Type Status Count Blocker
    ------------ -------------------- ----------------------------------- ---------------------------------------- -------- ---------- ---------- -------- -------
    4031(*) DB2HMON Waiting for remote node SYSIBM.SYSTABLES NS Row Granted 1 No
    4031(*) DB2HMON Waiting for remote node SYSIBM.SYSTABLES IS Table Granted 1 No


    It's keep on running and locking with some other application ID.

    When i tried to kill the application,

    db2 "force application (4031)"
    DB20000I The FORCE APPLICATION command completed successfully.
    DB21024I This command is asynchronous and may not be effective immediately.

    It's keep on connecting how to kill this application?

    I have checked dbm paramater
    Monitor health of instance and databases (HEALTH_MON) = ON

    If i disable this parameter it's be risk for DB's under this instance?

    Please help me to sort out this issue.

    Thanks,
    laxman.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    health monitor is deprecated. You can set HEALTH_MON=OFF, although in some versions this was ineffective.

  3. #3
    Join Date
    Sep 2012
    Posts
    177
    Thanks for your reply db2mor.

    In our setup we have two DB's under this instance. If i disable this parameter DB performance issues will happend? And this process is running in production environment.

    Thanks,
    laxman.

  4. #4
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Have you read the documentation about this health monitor? Your questions are answered there...
    IBM Knowledge Center

  5. #5
    Join Date
    Sep 2012
    Posts
    177
    Hi db2mor,

    I have disabled the HEALTH_MON parameter,

    [db2inst1@prddw1 ~]$ db2 get dbm cfg | grep HEALTH_MON
    Monitor health of instance and databases (HEALTH_MON) = OFF

    Still the application is handling DB2HMON process.


    Agent Application Application Object Lock Object Lock Lock Is
    Id(State) Name Status Name Mode Type Status Count Blocker
    ------------ -------------------- ----------------------------------- ---------------------------------------- -------- ---------- ---------- -------- -------
    22139(*) DB2HMON Waiting for remote node SYSIBM.SYSTABLES IS Table Granted 1 No
    22139(*) DB2HMON Waiting for remote node SYSIBM.SYSTABLES NS Row Granted 1 No

    How to avoid this?

    Thanks,
    laxman.

Posting Permissions

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