Database metrics

anis

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

Pierre Saint-Jacques

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