Re: Table Utilization

Ray There is a table in the sysmaster database called sysptprof which lists all open Tblspaces at that point in time. Along with the Tblspaces it gives information about the activity that is occuring on those Tblspaces such as reads, writes, seqscans, idxscans, etc. Note that attached indexes would not show up because they are part of the table's Tblspace. You could run this query several times a day or during a test run to gauge the table activity. HTH Sujit Pal ______________________________ Reply Separator _________________________________ Subject: Table Utilization Author: ray_anderson@compusa.com at Internet Date: 4/2/98 3:45 PM We are running Informix 7.2 and Not being a DBA, I was looking for a way to log table activity. The particular product we are running has a database with approx. 700 tables and we have very little information on table usage. Does INformix have a utility that would assist in this quest? Thanks -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading