Tag Archives: script

Simple DB2 Reorg Script – Take 1

I used to run a script that did went thru the reorgchk output and build a script out of it. Even though it worked, I often found it difficult to pick the right index. I rewrote it for scalability and … Continue reading

Posted in db2 | Tagged , , | Leave a comment

Automated runstats – take 2

A while back I posted a script that automatically created and ran runstats for all tables in each database on an instance. I noticed that when the database was defined as remote, the script couldn’t connect and created an error … Continue reading

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

whats using that memory in AIX ???

In the process of tuning an application, I had to find out what was taking all those resources in the AIX server.  I had to look up that command as I seems to have misplaced my AIX cheat sheet. So … Continue reading

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