Tuning of SQL queries requires understanding why DB2 chose a particular access path and determining whether or not that access path should perform as expected. The key to this is understanding what filter factors are, how they are used by the Optimizer and how to get DB2 to better estimate them,
The IDUG Web Committee works year-round to support the IDUG website, including the DB2-L listserv. Thank you to Sven Lovrencic, Mariusz Koczar, Cristian Molaro, George Shomsky, Brian Cocherell, William Shipley, Tihomir Katić, Mark Labby, Avram Friedman for all your efforts with supporting IDUG
The dust has started to settle after a great week at the IDUG EMEA 2015 Technical Conference in Dublin. My CPC colleague Phil Nelson has written a Blog which gives an excellent overview of the high spots but as Conference Chair this year I just wanted to add a few closing thoughts.
The conference is almost over for another year, and again I think it has been a wonderful event. Congratulations to Steve Thomas for his leadership
I admit it, that "Day 3" entry wasn't really written on the 3th day of our conference. Not even on the 4th. There are simply too much things going on at the conference to get that done in real time.This time I'm not even going to pretend it's the last conference day. You wouldn't believe me anyway.