Just out of curiosity, how those process got orphaned?? Were the applications killed in a "dirty" manner and the agents didn´t die?
What version of DB2 are you running?
I´ve had a similar problem on DB2 V7.2 on Linux, and from what I saw, after trying to force them a few times, they eventually disconnected from the server.
I think that after turning off your applications in a dirty manner, it has no time to close all opened connection handles and the agents opened by that applications remains open until they finish processing and "realize" the connection is no more. Although this processing may take a while to close, even after you force them off.
It´s now fixed on DB2 V8 FP2
Here´s the APAR that solved this:
IY43459 ORPHANED DB2AGENT PROCESSES STILL PROCESSING AND HOLDING LOCKS AND RESOURCES LONG AFTER THE ASSOCIATED APP IS KILLED
Hope this helps.
Last edited by fohana; 03-08-05 at 09:06.