Tag Archives: indexes

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

Reverse engineer indexes in DB2 – Take 1

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

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