Re: Need a sysmaster sql to find I/O meister.
David Williams wrote in message ...
>In article <67f2pq$gdq$1@usenet11.supernews.com>, Jeff Lanham
><jeffl@etcscan.com> writes
>>Greetings Family,
>>
**SNIP**
>>Is there a way to query sysmaster to find the session id of a heavy I/O
>>offender?
>>
>
> Yep...
>
> select * from syssesprof>
> Easy!!
Thanks! I guess there is no easy way to track this sort of problem back to
the source. By the time you check through all of the output and follow up
on all of the "maybe this one is it"s, the problem has resolved itself.
Maybe that's the real solution!
I got this one from Informix Support. It's slightly more helpful.
SELECT p.sid, username, tty, seqscans, dsksorts, total_sorts from
syssesprof p, syssessions s WHERE p.sid = s.sid;
>
**SNIP**
>
>--
>David Williams
--------------------------------------------------------------------------
Jeff Lanham jeffl@etcscan.com
DBA UIN: 2721788
SCAN/Deluxe Payment Protection Systems, Inc.
Bothell, WA
* Eagles may soar, *
* but weasels aren't sucked into jet engines *