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...
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))...