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 > Database Profiler

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-08-07, 09:16
nick.ncs nick.ncs is offline
Registered User
 
Join Date: May 2007
Location: somewhere in dbforums
Posts: 221
Database Profiler

Does DB2 have some tools which monitors the database and allows me statistics like

SPname
Application Name
Reads
Writes
CPU
Duration

What i actually want to do is analyze which SPs are use more frequently and if reqd optimize it or optimize longer duration queries.....
some sort of a tool which i can keep it on for a day to have a look at the usage statistics and which logs every SP run on the DB

Something on the lines of SQL profiler as provided in MSSQL Server.......
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