Articles & Content


E13 - Tune My Queries but Do Not Touch Them!

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2015

Do your users complain about SQL query performance, but you need to follow a 4-months test cycle for any query change, or you cannot change the application at all (third party vendor package, usage of SQL processing framework, query migrated from another DBMS)? This presentation introduces an efficiency metrics to classify the queries and discusses the most important system performance features implemented during the latest releases. Use this presentation as a checklist against your workload when back from the conference.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.