Dear All,

What is the db2 command to see the database growth last 5 month.

I want it to see db growth each month.

Regards,
K.manikandan.

A very rough and simple approch:
Monitory the size of your backup images thru time. They give a nice impression.

... if they are not compressed or incremental.

There is a storage management tool in DB2 Control Center. Alternatively, you can run the CAPTURE_STORAGEMGMT_INFO procedure manually on schedule and select information you need from the storage management tables. You will find more information in the manuals.

do db2 list tablespaces show detail then for each tablespace do
total pages X Page size.....Add up this value for all tablespaces and you'll have your db size

or you can use the get_dbsize_info procedure...