Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Informix
7.3 on Solaris 8.
prstat shows 3 oninit processes totalling roughly 33% in the cpu column.
Generally it is much less than this, and we're experience slowdowns. The
vendor software runs on this same server, and I see a number of their
processes near the top of prstat as well. I'd like to verify that Informix is
not being the bottleneck here.
I'm new to monitoring this, so I've been reading a book "Informix DBA Survival
Guide". I've done an onstat -u and I see 460-500 active user threads, most
with a Y in the first column of the flags -- meaning the thread is "waiting on
a condition". I'm surprised to see this many user threads at all -- we have
40-50 users during heavy usage -- would I expect to see 10 threads per user?
How can I find out what those three oninit processes are doing? onstat -g glo
shows three cpu processors (those that are showing near the top of prstat).
Nearly all the other 33 processes show no activity. Or... how can I show that
Informix is not the bottleneck?
Thanks for any suggestions.
Brian McLaughlin
Administrative Computing
George Fox University
(503) 554-2587
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.