Topic: 2013 AU
Subtopic: DB2 for z/OS
We all know that SQL in production should be performing at the absolute best that it can – and the market is
full of tools to help you monitor and measure that performance, hopefully against some stated service level
But how does high performance SQL get into production in the first place. Do you ensure that it is coded in
the best way possible right at the start of the development lifecycle, or do you only address performance
issues when the SQL is about to be promoted into production (or perhaps only AFTER it has been migrated)?
This presentation looks at some ways it may be possible to “quality assure” your SQL as it is promoted
through the different environments
We will also look at some development situations that would seem to make SQL QA an almost impossible
Finally, we’ll finish off with some thoughts on what constitutes normal performance and how could it be
possible for a performance monitor to track normality and raise alerts for exceptions – all without annual
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.