Hi Guys,

Just wondering if I have a child process which is basically hanging and I can see that is on sleep or wait mode if I want to remove/terminate this process , the signal has to come from its parent I assume. The reason I'm asking this is because I'm facing a db2 hang situation and we can see that most processes are showing:
Waiting on latch type: (SQLO_LT_SQLE_DBCB__dblatch) - Address: (78000000029ef20), Line: 351, File: sqlmutil.C

I have raised this with IBM but no luck and to the hangs doesn't ends here because we can't remove those processes issueing :
-db2stop
-db2stop force
-db2_kill
-kill ppid
-ipcrm (remove s,m,q) AIX
-kill -9 -1
-kill using root access
therefore the only way to restore the sevices is rebooting the server and this is a big shared server. I would like to know how can I remove a process in this sort of state. Can I send I signal to exit .Please any ideas or suggestions would be highly appreciated.

Harby.