DB2 performance tuning
I haven’t inflicted enough punishment onto myself in the past few weeks. So now I’ve been trying to tweak our DB2 machine this week.
This page really says it all. Read it and do it all the way through. It’s easier than looking through IBM’s docs.
It’s important to have an Event Monitor configured and running while you beat the crap out of your DB, because then you get all the wonderful statistics you need to figure out what the heck is happening.
Also, a normal runstats on schema.table seems to do just about nothing. This seems to be a lot better:
runstats on table schema.tablename WITH DISTRIBUTION ON ALL COLUMNS AND DETAILED INDEXES ALL ALLOW WRITE ACCESS