Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to check fastest growing tables in db2 via db2 command

Hi Experts,

You might feel this very silly question on this forum, but still because of some requirement’s I need that. I'm new to db2 and basis so please bare my immatureness.

Our DB size is growing faster @ 400/500 MB per day from last 15 days, which is supposed to be not more than 100 MB per day. We want to check the fastest growing tables. So i checked the history in db02 transaction and select the entry field as per 'Growth'. But for the given specific date it is showing nothing. Earlier we had same issue some 3 months back that time it used to display with same selection criteria.

So I want a db2 command to execute and check the fastest growing table on database level. Please help guys. Early reply must be appreciated.

PFA screenshot. DB version is DB2 9.7 and OS is Linux

Thanks & Regards,

Prasad Deshpande

Growth_Table.jpg (129821 B)
Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question