cancel
Showing results for 
Search instead for 
Did you mean: 

Get TOP 10 tables in SAP

Former Member
0 Kudos

Hi,

Can anybody tell me how can I list TOP 10 tables in SAP?

When I look in DB02 for table sizes, it does not show the history of all tables at once, I have to choose the tablespace and the table each time.

Thanks,

Nishikant

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI Nishikant

Do the following to get the TOP 10 Table in one go.

Step 1:- Tcode DB02 then goto menu goto --> table & indices --> Table & Indices

It will prompt New window Memory Mgmt for table and indices.

Step 2:- Put * in Object Name, Tablespace and object type .

Step 3:- Click on Right Tick button Wait for some time it will display the all tables.

Step 4: -Then sort on table size you will get the top 10 table.

Best luck,

Atil

Former Member
0 Kudos

Hello ,

The above was for Oracle.

For Db2 do the following:-

USe Tcode DB02 and click on Table & Indices .. It will open another window put * in Table and tablespace it will give you list and then sort on size to get top 10 table.

Best Luck,

Atil

Former Member
0 Kudos

Thanks Atil,

I did checked your suggestion, but what I get is the list something like this -

Created

Table by Database Tablespace

#ACCESSVALJKG SAPR3 A021XISW LSWFDRYH

#ACTIONTEXTAY9 SAPR3 A030X99S LRMPS0I1

#APPLICATIONTV8 SAPR3 A101XQ0N LSTRXYK2

It does not show me the size of the tables anywhere, I have go in to each table and then it will show me the size.

Is there any other way to check this?

Thanks,

Nishikant

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Guys,

In my case I searched for all the tablespaces & find out the larger tablespaces.

Then I went through individual tablespaces and got the details of the table.

I don't think there is any other way to get the list of TOP 10 table in DB2 database.

Thanks,

Nishikant

Former Member
0 Kudos

In DB2 10.1 version, I could see in DBACOCKPIT,

Space --> Top Space Consumers --> list of Tables with the Tablespace details.

This helps to decide about Reorg.

Cheers,

Eswaran

KayKa
Active Participant
0 Kudos

Hi Eswaran,

why do you answer on a thread from 2008 ?

And as you see in her last posting there are columns with databases and tablespaces. And we are here in the community "SAP on DB2 for z/OS". So no Oracle nor DB2 LUW (or UDB or DB6) transaction will help Nishikant.


Today the simple way is transaction st04 ( or db2 or dbacockpit ) - choose "Space" and then "Tables".
Under "Selection Settings" in field "Sort by"  choose "Used_Space" then you get something like the attached screenshot.

And you can go the same way for tablespaces if you choose "Tablespace" instead of "Tables".

But these ways were not available in 2008, so today her question is obsolete.

regards
Kay