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...
What if db2stop fails ?!?
Don’t tell me you haven’t had db2stop fail on you. Once in a while db2stop would hang especially if you...
Whats up with DB2 V9.7
While I am still playing with Db2 V9.7, I found this link to be quench the thirst for the time...
Invalid history version in header
I kept getting this error and was filling my db2diag.log. A little bit of research revealed it was because a...
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. ...
Are my indexes used ?
Often I wonder out of all those 100s of indexes on my siebel database what all indexes are really used...