Oninit cdi / Archive
Talk to an expert →

onstat -a runaway process

Posted in 2007

Topics: Server Administration, Triggers, Constraints & Referential Integrity

Beau Nanaz — — source: Usenet: comp.databases.informix

Greetings, family (if y'all haven't disowned my by now ;-) We have a problem (so what else it new) with onstat -a: we have a script that periodically runs onstat -a and oncheck -pe. The onstat occasionally starts to eat CPU and the user calls us DBAs to kill the process. If someone knows of a condition that triggers this misbehavior, please respond. Alterntively, if someone knows what option it is running when it heads into that loop, it would also help greatly, because we would cut out the -a and replace it with options that exclude the culprit. Thanks much for any help on this. -- JS (Depriving a village somewhere of its idiot)

↪ replying to Beau Nanaz
Jack Parker — — source: Usenet: comp.databases.informix

Why in the h*ll are you prediocally running an onstat -a? This is a default debugging mechanism, not a casual monitoring tool. Figure out what it is you want to monitor and check THAT periodically - not the whole enchilada. Much of the onstat -a output is fairly useless anyway, unless you're digging into a single point of time in detail and don't know what it is your looking for yet. j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Beau Nanaz Sent: Thursday, February 01, 2007 8:06 PM To: informix-list@iiug.org Subject: onstat -a runaway process Greetings, family (if y'all haven't disowned my by now ;-) We have a problem (so what else it new) with onstat -a: we have a script that periodically runs onstat -a and oncheck -pe. The onstat occasionally starts to eat CPU and the user calls us DBAs to kill the process. If someone knows of a condition that triggers this misbehavior, please respond. Alterntively, if someone knows what option it is running when it heads into that loop, it would also help greatly, because we would cut out the -a and replace it with options that exclude the culprit. Thanks much for any help on this. -- JS (Depriving a village somewhere of its idiot) _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

Glossary