Database metrics

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anis - 06 Mar 2006 19:30 GMT

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
Ani

--
ani

Reply to this Message

Pierre Saint-Jacques - 06 Mar 2006 20:39 GMT

See below. #######
HTH, Pierre.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

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

Reply to this Message