Joe Geller discusses some favorite tuning tips for Db2 in this video recorded at IDUG EMEA in Lisbon last month.
When it comes to tuning a query, program, or even an application that most developers are not sure where to begin or what may be causing response time issue(s). This article is here to help!
There are a number of fairly important tuning tips that do not get much attention. In this article I will describe one of my favorites – Hash Joins.
It's inevitable that you see a couple of DB2 fix packs every year and place the readme document in a drawer somewhere for perusal later when you are not busy. While the fix packs may contain fixes there are sometimes a few enhancements buried in the fine print.
This presentation from the IDUG EMEA 2016 will provide an overview of DB2 LUW statistics and the options to collect them, to help you achieve optimal query performance, with minimal administration effort.