Have you tried Informix ServerStudio ([url]http://www.serverstudio.com)?[/url]
"me here" <firstname.lastname@example.org> wrote in message
news:email@example.com...> Does anyone have any good admin queries (SQL) that can be run to report
> on current server stats. Simiar results to "onstat -u"
> I can query the syssessions view on sysmaster and have trolled the
> newsgroups and web for useful queries. A lot of the reporting scripts
> where Unix shell scripts but I need to run the queries over JDBC using
> an awesome JAVA sql client I have found. These reports may be included
> in an JAVA web application if I can prove them to be useful.
> I am specifically not mentioning any of the SQl statements I already
> have as I would like to find out what other people are using.