Skip to Content
0
Mar 17, 2009 at 02:29 PM

Table size statistics

292 Views

Hi guys,

I want to collect some statistics about tables size on DB2 v.8.1.

I tried with TCode DB02 without any success, I have only a table list without the size detail; I also tried as described on thread [Get TOP 10 tables in SAP|Get TOP 10 tables in SAP; but I noticed that some tablespace occupy a huge space on the DB but tables' size (related to these table spaces) is not coherent to this data (0KB or few KB). How is possible?

I successfully got the index statistics from the DB02.

What is the right way to get table size statistics?

Thanks,

Ivan