Follow me !
By PDGACO GaballaLoans
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: db2pd
Checking on HADR
By now I am sure lot of db2 users have adopted DB2 HADR as one of their high availability solution. IBM has matured HADR over the last two versions and its becoming more and more robust. Couple of years ago … Continue reading
Posted in database, db2, how to
Tagged check hadr, db2 hadr, db2 high availability, db2pd, hadr, hadr status
Leave a comment
Are my indexes used – Part III
Last month, I wrote an article that identifies indexes that are not used in DB2 UDB. Well, IBM has made it easier in DB2 V9.7. They now have a monitor routine called MON_GET_INDEX that can help identify the indexes that … Continue reading
Posted in database, db2
Tagged db2 unused indexes, db2pd, indexes, mon_get_index, tcbstats, truncate table, unused indexes
Leave a comment
Are my indexes used ? – Part II
Last year, I wrote an article and a script that helps to identify unused indexes in DB2 UDB. Its unfortunate, IBM doesn’t provide an easy way of identifying them. In DB2 Z/os, you can look up SMF records or use … Continue reading
Posted in db2
Tagged db2 indexes that are not used, db2 unused index, db2pd, identify indexes, index usage, merge, tcbstat
1 Comment
Track db2′s memory usage
Here is a script that displays the current memory usage and peak memory usage of an instance and its databases. The script basically used db2pd -dbptnmem and parses out data to make it easy to read and manage. You can … Continue reading
Posted in db2
Tagged db2, db2 memory usage, db2pd, db2pd -dbptnmem, dbptnmen, instance memory
Leave a comment