DB2TOP replay

February 8, 2013,   has blogged 7  posts

Actually DB2TOP is a real-time tool, however many DBA’s don’t know that it can be run in REPLAY mode with captured session information. So, next time you have a big crisis with your database, you can capture all the data from db2top and do the analysis afterwards.

Detecting indexes not used DB2 9.7

January 22, 2012,   has blogged 27  posts

This article shows a method to view the indexes not used in our database since the last reboot. There are another methods to obtain the same information, like the use of the LASTCOLUMN included on 9.7 version. This article will let you know what indexes are not being used, with the waste of resources involved.

Uptime DB2

April 6, 2011,   has blogged 27  posts

This mini article tells how to know when was the last time you restart a DB2 server on a UNIX / LINUX.