Hi,

If I want to monitor few tables in such a way that I get the userids of the users who accessed the tables, number of times the table was hit etc.
I am using 7.31 IDS FD5.
Can somebody sugest.

Thanks in advance.

Nitin

Hi Nitin,
In dbaccess run the script

database sysmaster;
select dbsname, tabname, sum(pagreads) Reads, sum(pagwrites) Writes
from sysptprof
where dbsname="stores" -- ur db name
group by dbsname, tabname

Have you seen Informix-Ispy? It might be a bit over the top for what you want but it will do what you're asking.

Thanks for your suggestions. But the query will not give me the username who is accessing the table. Further I want to know pagreads and pagwrites mean number of rows selected from the table or number of times the table has been hit.

Can Informix-Ispy be used to monitor specific tables or we have to go for the complete database.

Thanks in advance.

regards,

Nitin