Tag Archives: tablespace

A Shell script to get total space allocated in a database

Often I get asked how much space does the database take and I end up doing list tablespace and calculating total pages * page size .  I tried using the  GET_DBSIZE_INFO stored procedure , it doesn’t seem to give the … Continue reading

Posted in db2 | Tagged , , , | Leave a comment

An sql to find out how full your db2 tablespace is on UDB

You need to have the IBM stored procedure SNAP_GET_TBSP_PART select tbsp_name, ((tbsp_used_pages * 100)/tbsp_usable_pages) as percent_full  from table(SNAP_GET_TBSP_PART (‘ ‘,-1)) as tabl1 This will show you how much percent full your tablespace is. You can insert the result set into … Continue reading

Posted in Misc | Tagged , , | Leave a comment