Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2008
    Posts
    2

    Unanswered: Monitoring tables

    Hi you DB2 nerds...

    I'm trying to find a way to monitor a table traffic in a db2 database.
    I need to know how often and which user is querying the table.
    I'm using db2 v9.5 and I don't see how I can use db2pd or something else for that information.
    Any info would be preciated.

    -gardarm

  2. #2
    Join Date
    Oct 2007
    Posts
    246
    you can use db2audit tool or snapshot on application id
    redgs
    Paul

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    @gardarm, this is exactly the same question I have been asking few days ago: How to monitor which user has accessed which table?
    Regards

  4. #4
    Join Date
    Apr 2008
    Posts
    2
    yebb grofaty, I saw your post a little bit later and I've been trying db2audit.
    Just have to read a little bit more about it...
    -gardarm

  5. #5
    Join Date
    Mar 2010
    Posts
    6
    Hi you can try to use ProteMac Meter.It’s tool record of your network and display your internet traffic.It’s helps me a lot.

Posting Permissions

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