Re: Monitoring table access

In 7.1 you can use DB/Cockpit Table Profile view, that provides table profiling information noted by Rick (and much more) in the real time. Beginning from 7.1 UD1 table profiling information is available even if table is not currently opened. Vitaly On Fri, 13 Oct 1995, Rick Christie x7528 wrote: } } In a previous episode: } } > From: Tod Kehrli <72064.1721@CompuServe.COM> } > Subject: Monitoring table access } > Date: Wed, 11 Oct 1995 18:32:54 -0500 } > To: informix-list@rmy.emory.edu } > X-Informix-List-To: christie@platinum.com } > X-Informix-List-Id: <news.17847> } > } > Is there any way to monitor application access to specific } > tables (i.e. # of selects in a day)? I'm trying to measure } > system usage without putting hooks into the application. } > } } It depends on the version you're running. } If you are running version 7, then it is possible to get very } detailed information on table i/o via the SMI tables: } } select dbsname, -- database name } owner, -- table owner } tabname, -- table name } pf_dskreads, -- disk reads } pf_isread, -- row reads } pf_dskwrites, -- disk writes } pf_iswrite, -- row writes } pf_isrwrite, -- row updates } pf_isdelete, -- row deletes } pf_bfcread, -- buffer reads } pf_bfcwrite, -- buffer writes } pf_seqscans -- sequential scans } from sysptntab a, } systabnames b } where a.partnum = b.partnum; } } This information is available while the table is being used. Once the } table is not being used, this information is no longer available. } } Hope this helps. } } ---- } WARNING -- "advertising" follows: } } DB-Vision for Informix from PLATINUM technology is a performance monitor } for Informix databases that provides this information in graphical and tabular } format. DB-Vision can also track performance history, so that statistics on } table i/o can be analyzed even after the table is no longer being used. } } For a more complete listing of features of DB-Vision for Informix, please } send email to christie@platinum.com. PLEASE - do not send requests to this } mailing list ! } } Thanks. } } Rick } ----------------------------------------------------------------------- } | Rick Christie | PLATINUM technology, inc. | } | Lead Developer, DB-Vision for Informix | 620 W. Germantown Pike | } | christie@platinum.com | Suite 200 | } | (610) 940-6020 | Plymouth Meeting, PA 19462 | } | (610) 940-6021 (fax) | | } ----------------------------------------------------------------------- } | He asked me for advice. I said, "Use the door." | } | -- Chrissie Hynde | } ---------------------------------------------------------------- } } ---------------------------------------------------- Vitaly Volchek Com Software Industries e-mail: vitaly@applicom.co.il phone: (972)-9-598953 at work ----------------------------------------------------