Page 1 of 1

Database Space

PostPosted: Thu Oct 08, 2009 11:55 pm
by arshadhrashid
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.