Tag Archives: automation

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