var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: db2 health monitor issue
Checked and found that a process is running from last 5 hours..
Query getting executed. : CALL SYSPROC.SYSINSTALLOBJECTS('POLICY','V','','')
i have tried to kill the process from db2 end as well as from os but its still showing me.
Any idea how to terminate this process or why it is taking so much of time??
DB2 level : DB21085I Instance "db2ins14" uses "64" bits and DB2 code release "SQL09055"
with level identifier "06060107".
Informational tokens are "DB2 v18.104.22.168", "s091123", "U829462", and Fix Pack
Product is installed at "/opt/IBM/db2/V9.5".
OS : AIX 6.1
Are you sure it is _running_, not waiting on a lock? How is it a "health monitor issue"?
In db2top application status it is showing me UOW executing.
Please check attachment for reference.
Did you try restarting the instance? Is health_mon dbm cfg enabled? Please open a pmr if you need to debug this. I can try to take a look if you collect "db2pd -latches" (execute 3 times, several min apart).
Its a production db so i cannot restart instance @working hours.
yesterday also we faced same issue at time for backup activity.
we have tried db2 force application all and db2stop force but none of them worked. atlast we used ipclean to restart instance.
health_mon dbm cfg is set to ON.
Will provide you output of db2pd -latches shortly.
Please find output of db2pd -latches
Database Partition 0 -- Active -- Up 0 days 10:04:51
Address Holder Waiter Filename LOC LatchType
0x078000000075F3C4 9557 8786 sqlerFmpEngine.C 6826 SQLO_LT_sqlerFmpRow__ipcLatch
Seems like we have hit APAR IC76825.