Tag Archives: runstats

New reorg formula

While reading a DB2 tech report and best practice , I see that many IBM DB2 internal experts now do not suggest running reorgchk to find out the tables that needs to be reorg’d .  Instead they suggest using 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

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