Re: Informix Statistic

Hi Dana, Pls do send your script to me. Thanks a lot "B. Dana" wrote: > Coincidentally I am working the same problem. > So far I have a cron job that collects info from systabnames, sysptprof, > and sysptnhdr in sysmaster; then resets the statistics. It runs at 05:00 > and 17:00 to log usage of all tables (by dbspace) during general OLTP > and batch hours. > Using perl with the GD module to generate trend plots of the > busiest by reads and writes, and growth of the largest tables. Other > reporting will be tables that grow more than some percentage over time. > > One of the original purposes of this collection was to determine where > to locate the tables within dbspaces. > Initial analysis has shown that of 1600 tables almost half are NEVER > used! Same for the indexes. One odd bit has shown one table with five > indexes, has the same number of index reads (on all 5 indexes) as the > number of rows in the table. (I suspect an ugly HAVING clause.) > > I can send you the scripts to collect the data; the graph generator is still > > very rough. > > Tham Huei Hwan wrote: > > > Hi all, > > > > I need some input from you all. What are the statistic that I can > > capture from informix (ie. number of transaction, i/o for each dbspaces > > etc ). My purpose here is to capture the statistic and plot out a graph. > > > > Thanks and regards, > > > > Tham