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
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.