DB2 inplace reorg
Reorg is a close friend of a DBA. Â But who and what is a reorg ? Â Why do we need...
Back to the past in DB2 !
Have y’all ever failed back to a previous version of DB2 after few weeks. Â Try it…its a nightmare ! Â Failing...
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....
Automated runstats – take 2
A while back I posted a script that automatically created and ran runstats for all tables in each database on...
DB2 Best practices….huh ?
While I was cruising the internet highway trying to find about tuning agents stolen for V9.5 . If found this...
A Shell script to get total space allocated in a database
Often I get asked how much space does the database take and I end up doing list tablespace and calculating...