Database Space



IBM's flagship relational database management system

Database Space

Postby arshadhrashid » Thu Oct 08, 2009 11:55 pm

Hi,
I woule like to calculate the space used by my database.
the site DB2DBA Blog
http://db2dbazos.blogspot.com/2009/07/c ... table.html
Suggets to run STOSPACE and then sum(size) column in sysibm.systablespace and sysibm.sysindexspaces.

I want to make sure if its correct as after running STOSPACE for STOGROUP the column STATSTIME was not updated in the above tables. so the space is not current in my opinion.

Is there any better way to find out how much space is used by my database?

Thanks.
arshadhrashid
 
Posts: 70
Joined: Tue Jul 28, 2009 5:03 am
Has thanked: 0 time
Been thanked: 0 time

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post