FEEDBACK tables and PROFILES – is it a dream

A lot of DB2 sites are using pretty basic RUNSTATS syntax, but they might be missing some hidden gems and not providing the optimizer with adequate statistics resulting in non-optimal performance. RUNSTATS has always been a challenge in terms of how to code the best possible syntax based on the SQL hitting the table and this task has not become any easier between each release of DB2. DB2 11 provides some great tools to assist with this task and the future looks even more promising. In this presentation, Steen will cover:
* A thorough walk through RUNSTATS profiles.
* DB2 11 SYSSTATFEEDBACK and DSN_STAT_FEEDBACK, how does DB2 populate these new tables and when.
* New ZPARM and DB2 catalog entries to control these new features.
* How to “control” and interpret the FEEDBACK tables.
* What’s new in autonomics – the perfect marriage.