Follow me !
Search this blog
-
Recent posts
Tags
AIX Apple automation backup best practices Bootcamp cloud cursor db2 db2 compression db2 hadr db2 performance db2 tuning db2 v9.5 db2 v9.7 db2move db2pd google indexes install iPad iPhone linux Macbook memory NULLID Oracle package performance restore runstats script shell script sql SQL805N SQL Server stored procedure tablespace time machine tuning ubuntu ubuntu 9.04 upgrade Windows on Mac wordpressDisclaimer
The posts here are solely my personal views and opinion. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis or consultation with technical support. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. I do not represent any vendor or product.
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
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