RE: TOP Process

You could be seeing a loop of some type. I've seen this in the 4ge world every now and then. Of course, I guess that it is possible for a program to be actually doing some work . . . -----Original Message----- From: Dirk Moolman [mailto:dirkm@reach.co.za] Sent: Monday, January 08, 2001 2:31 AM To: informix-list Subject: TOP Process HP-UX 11.00 IDS 9.21FC1 Hallo everyone, I have something that's been a problem to me for quite some time now. If I run a "top" on HP, showing me the processes using the most cpu power, I often find 4gi's sitting right on top, using 60 - 90 % cpu power. I also think these programs are not doing any selects (as seen from the current sql statement from onstat -g ses), but something else. How can I find out what the program is doing, and why it is using so much cpu power ? One example I have this morning: onstat -u | grep 15373 c000000094be4828 Y--P--- 15373 izakb tPe c000000088e55d80 0 163 0 Flags are normal. If I get the current sql statement using "onstat -g ses", and I run this in dbaccess, it runs very quickly (sub second). Current SQL statement : select unique waybill_no from waybill_ref where waybill_ref.ref_no='18405' The user says that on his side, the program seems to be hanging. Has anyone had similar experiences on HP & IDS 9.21FC1 ? We get this every now and then, the program will sit right on top for a couple of minutes and then disappear again. I don't know if this is an Informix problem or an HP problem, and I have people thinking its the database because they can see the current sql statement sitting there and not changing. I also get the status - cond wait (netnorm) - when I run onstat -g ses, which I am not too familiar with, accept that I think the program is waiting for response from another process. Dirk Moolman Database Administrator Reach Technologies "Bravery is the capacity to perform properly even when scared half to death." - General Omar Bradley