Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    143

    Unanswered: Identify user access to specific tables

    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

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    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

  3. #3
    Join Date
    Nov 2004
    Posts
    26
    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.

  4. #4
    Join Date
    Nov 2004
    Posts
    143
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •