Re: Sql question
>does anyone have a script that will pull out the tables
>in a database that would have the most read/write activity?
One way is to use the "onstat -g ppf" command, which shows the
tables that are currently active along with some other info.
Another is to use the following script, presented at the IIUG
track at the User Conference. Be sure to check out the site for
more of the same, at http://www.iiug.org .
dbaccess sysmaster - <<EOF
select dbsname,
tabname,
isreads,
iswrites,
lockreqs
from sysptprof
where dbsname = "$1"
order by isreads desc;EOF
Of course, as far as Informix is concerned, the warnings in the
OnLine Admin Guide about these tables being unsupported and subject
to change without warning still apply.
This is pasted from the archives of comp.databases.informix from
that same IIUG site. You'll want to join up while you're there.
Hope that helps,
______________________________________________________
Clem Akins (aka clem@informix.com) <- NEW ACCOUNT!
Informix Software, Inc (Standard disclaimers apply)
International Technical Support
Last seen: Walking round the harbour, Auckland