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 a table and create a trend analysis.