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.

Gavin

Have you tried Informix ServerStudio (http://www.serverstudio.com)?

Gorazd

"me here" <donotspam@notspam.spam> wrote in message
news:2cohb.32$ws.2169@news02.tsnz.net...
> 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.
>
> Gavin
>

There's lots of this sort of stuff in the International Informix Users Group
software repository, at www.iiug.org. You have to join, but it's free.. and
you should be a member already! :-)

"me here" <donotspam@notspam.spam> wrote in message
news:2cohb.32$ws.2169@news02.tsnz.net...
> 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.
>
> Gavin
>

I have a number of sql scripts that run against sysmaster. They include
finding the highly used tables, finding users who do most sequential scans
etc.
At the moment my main concern is that I can't post through informix-list for
some reason.

Any ideas

Malcolm

"Neil Truby" <neil.truby@ardenta.com> wrote in message
news:bm5l56$i46bc$1@ID-162943.news.uni-berlin.de...
> There's lots of this sort of stuff in the International Informix Users
Group
> software repository, at www.iiug.org. You have to join, but it's free..
and
> you should be a member already! :-)
>
> "me here" <donotspam@notspam.spam> wrote in message
> news:2cohb.32$ws.2169@news02.tsnz.net...
> > 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.
> >
> > Gavin
> >
>
>

Malcolm Weallans wrote:
> I have a number of sql scripts that run against sysmaster. They include
> finding the highly used tables, finding users who do most sequential scans
> etc.
> At the moment my main concern is that I can't post through informix-list for
> some reason.
>
> Any ideas
>
> Malcolm
>
> "Neil Truby" <neil.truby@ardenta.com> wrote in message
> news:bm5l56$i46bc$1@ID-162943.news.uni-berlin.de...
>
>>There's lots of this sort of stuff in the International Informix Users
>
> Group
>
>>software repository, at www.iiug.org. You have to join, but it's free..
>
> and
>
>>you should be a member already! :-)
>>
>>"me here" <donotspam@notspam.spam> wrote in message
>>news:2cohb.32$ws.2169@news02.tsnz.net...
>>
>>>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.
>>>
>>>Gavin
>>>
>>
>>
>
>

Sounds useful. Try gavin -at- jolly -dot- net -dot- nz

The reason I wnat these queries is as I said, they may be added into the
admin tools of a Java application we are building. All we have is JDBC
to query the database.

Thanks. When I get to work I will find the queries I have been suing and
post those.


Gavin

me here wrote:

> Thanks. When I get to work I will find the queries I have been suing and
> post those.

You've been suing queries? You're worse than an American!

--
Ciao,
The Obnoxious One

"Ogni uomo mi guarda come se fossi una testa di cazzo"

Obnoxio The Clown wrote:
> me here wrote:
>
>
>>Thanks. When I get to work I will find the queries I have been suing and
>>post those.
>
>
> You've been suing queries? You're worse than an American!
>

Didnt even notice. I am a bit dyslexic at the best of times. As an
aside, why is dyslexic so hard to spell?? I am sure some sadist created
that word.

Gavin

me here wrote:
>
> Didnt even notice. I am a bit dyslexic at the best of times. As an
> aside, why is dyslexic so hard to spell?? I am sure some sadist
> created that word.

If a dyslexic was also cross-eyed, would they be able to read properly?