Tag Archives: indexes

Are my indexes used – Part III

Posted on October 9, 2010 by rpillai

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

Reverse engineer indexes in DB2 – Take 1

Posted on August 11, 2009 by rpillai

I love DB2LOOK for many reasons. Its a wonderful and easy way to reverse engineer a database. DB2LOOK can generate DDLs for specific table(s), but what if we just want indexes to be reverse engineered, thats were db2look hits the … Continue reading →

Posted in db2 | Tagged , , , | Leave a comment

DB2 inplace reorg

Posted on April 2, 2009 by rpillai

Reorg is a close friend of a DBA.  But who and what is a reorg ?  Why do we need him ? Reorg is an utility in DB2 that reorganizes the data is the clustering sequences and can free up … Continue reading →

Posted in db2 | Tagged , , , , , , , | 5 Comments