RE: Table usage
From Lester Knutsens webpage(http://www.advancedatatools.com/sysmast.htm)
-- tabprof.sql
database sysmaster;select
dbsname,
tabname,
isreads,
bufreads,
pagreads
-- uncomment the following to show writes
-- iswrites,
-- bufwrites,
-- pagwrites
-- uncomment the following to show locks
-- lockreqs,
-- lockwts,
-- deadlks
from sysptprof
order by isreads desc; -- change this sort to whatever you need to monitor.
Sample Output
dbsname tabname isreads bufreads pagreads
zip zip 334175 35876509 1111
sysmaster sysviews 259712 634102 1119
sysmaster systables 60999 240018 1878
zip systables 3491 8228 543
sysmaster sysusers 2406 8936 87
sysmaster sysprocauth 1276 5104 12
sunset systables 705 2251 26
sysmaster sysprocedures 640 2562 21
sysmaster syscolumns 637 1512 49
stores7 systables 565 1361 16
sysmaster sysdatabases 534 2073 902
-----Original Message-----
From: Thomas Mieslinger
To: informix-list@iiug.org
Sent: 9/20/99 2:05 PM
Subject: Table usage
Hi *,
are there detailed statistics about table usage in IDS 7.31 availble?
I'd like to know which tables are often referenced by UPDATEs, INSERTs
and DELETEs. I could write triggers to gather these statistics, but
maybe someone had this idea already?
Thanks in advance Thomas
--
Thomas Mieslinger Mobil: +49 170 510 6095
Koenigstrasse 44 Fon: +49 661 901 3975
36037 Fulda Fax: +49 661 901 4605
Germany eMail: thomas@mieslinger.de