Informix DBA Survival Guide, Second Edition

Tuning

Question: How can l use the Undocumented QSTATS & WSTATS Parameters?

How can I use the statistics collected by either the QSTATS or WSTATS parameters (see onstat -g wst and onstat -g ost) to find bottlenecks in my system?

Answer: Query the sysseswts Table.

Set WSTAT to 1 in your ONCONFIG file, restart the server, and run the following query at frequent intervals during heavy loads:

select sum(cumtime) , reason from sysseswts where
reason != "condition" and cumtime > 1000
group by reason
order by 1 desc