By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

Database metrics

P: n/a

Hi Folks,
I have following requirement.
1)to find size of DB
2) no of rows in all tables in Database.
3)update date of all tables in Database.
4)CPU utilization by application.
5)Top 10 jobs by CPU utilization.
6)Top 10 user by CPU utilization.

Thanks
Anis
--
anis
------------------------------------------------------------------------
anis's Profile: http://www.dbtalk.net/m7
View this thread: http://www.dbtalk.net/t289895

Mar 6 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
See below. #######
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"anis" <an*********@no-mx.forums.yourdomain.com.au> a écrit dans le message
de news: an*********@no-mx.forums.yourdomain.com.au...

Hi Folks,
I have following requirement.
1)to find size of DB ####### On disk or in memory?
In memory - db2mtrk or very detailed: db2pd 2) no of rows in all tables in Database. ####### select tabname,card from syscat.tables 3)update date of all tables in Database. ####### AFAIK this data is not kept for updates of column values unless you
create your own trigger. 4)CPU utilization by application.
5)Top 10 jobs by CPU utilization.
6)Top 10 user by CPU utilization. ####### For the last three, you ned to read a bit on db2 V8.2 for the
Activity Monitor.

HTH, Pierre.
Thanks
Anis
--
anis
------------------------------------------------------------------------
anis's Profile: http://www.dbtalk.net/m7
View this thread: http://www.dbtalk.net/t289895


Mar 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.