If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Monitoring tables

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-14-10, 11:05
gardarm gardarm is offline
Registered User
 
Join Date: Apr 2008
Posts: 2
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
Reply With Quote
  #2 (permalink)  
Old 01-18-10, 01:54
Mathew_paul Mathew_paul is offline
Registered User
 
Join Date: Oct 2007
Posts: 200
you can use db2audit tool or snapshot on application id
redgs
Paul
Reply With Quote
  #3 (permalink)  
Old 01-19-10, 04:37
grofaty grofaty is offline
Registered User
 
Join Date: Jan 2003
Posts: 1,570
@gardarm, this is exactly the same question I have been asking few days ago: How to monitor which user has accessed which table?
Regards
Reply With Quote
  #4 (permalink)  
Old 01-19-10, 07:25
gardarm gardarm is offline
Registered User
 
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
Reply With Quote
  #5 (permalink)  
Old 03-14-10, 14:00
Willy01 Willy01 is offline
Registered User
 
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On