windows-1252?Q52=45=3A=20=6F=6E=73=74=61=74=20=2D=
WSTATS 1
----- Original Message -----
From: Jacques Lapeire <ids@iiug.org>
To: ids@iiug.org
At: 10/24 17:32:53
Hi Gary,
Here are my notes about WSTAT, I never used it myself.
Maybe it helps you out.
Best regards,
Jacques Lapeire
WSTATS is an undocumented parameter that can be set to 1 to collect
waiting statistics.
Causes some overhead, must be set to 0 again afterwards (needs restart
of Informix)
Can be checked with onstat -g wst ????
During enabled WSTATS , measure with:
exec $INFORMIXDIR/bin/dbaccess sysmaster - <<eof 2>/dev/null
select sum(cumtime)/1000000 time, reason[1,25] reason from
sysseswts
where reason != "condition" and cumtime > 1000
and sid != ( select sid from syssessions where pid = $$ )
group by reason
order by 1 desc
eof
You will get something like:
time reason
49,64480400000 aio
22,102884 buffer
19,66827700000 running
0,691903 mt ready
0,489298 mt yield 0
0,102884 buffer
In this case he database server is waiting for IO and buffers.
You need to tune AIO and add more BUFFERS.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
GARY PRICE
Sent: woensdag 24 oktober 2007 21:45
To: ids@iiug.org
Subject: onstat -g wst setup [10244]
I'm trying to run onstat -g wst to get some wait stats; the command
returns a
message "Wait statistics not enabled". I've scanned the manuals and see
no
reference as to what needs to be enabled to get the wait stats. Any help
will
be appreciated.
IDS 9.40
AIX 5.2
Thanks folks.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.