Measure, Improve, Repeat

Scott Hayes wrote Measure, Improve, Repeat, an article that covers some practical advice on tuning DB2. The article does not focus on data warehouse applications, but some of the tips are still valid. I found his tip about getting all performance data with just one command particularly useful:

$ db2 "get snapshot for all on DBNAME" > allsnap.txt