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 , , , , , | 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 , , , , , , | 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 , , , , , , | Leave a 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 , , , , , | Leave a comment