How to Calculate the following

1. Collect the details of TOP Ten Tables based upon the Size.

2. Collect the details of TOP Ten Tables based upon the Row Count.

3. Collect the details of TOP Ten Tables based upon the Recent Usage.

4. Collect the details of TOP Ten Tables based upon the Not Used Recently.

Whether the data is available from db2pd or event monitor or snapshot tool

1 and 2 is available in sysstat.tables - based on last runstats

what do you mean by 'top 10 based on recent usage' ? is the the most recent accessed tables ?
If using 9.7 see if lastused column is what you are after. note, last used column is not current but is based on a recent update by db2.

HTH

Sathyaram

Thanks for Ur info.. Point 3 and 4 are recently used tables and unused tables...

Since i am little new to DB2..May i Get the procedure to get the data for all points???

In Our Database , they are nearly 20,000 tables are there at present. How to get top 10 tables and row count for tat tables???

OK, let me repeat

1 and 2 is available in sysstat.tables , card column. This column is updated by the runstats command and therefore this value is correct at the time of collecting stats(runstats command)

3 and 4 - if using 9.7, it is available in lastused column of syscat.tables.This time specified in the column is not guaranteed to be correct - the update to the column occurs later and not immediately following the event.If using earlier versions of db2, afaik, there is no place where last used is stored.

I hope I have provided you with enough information to help you find the information you want.

Thanks a lot dude....


I got all data with ur help........

Hi Sathyaram,

Can u help me in tis,

1. Collect the details of Agent ID’s by Top 10 CPU Usage
2. Collect the Statements executed by those Agent ID’s
3. Collect the details of Top 10 Tablespace Containers based on Highest Read time.



Thanks in advance

Bala