In Part 1, I talked about some of the first steps that a developer should go through when it comes to tuning queries. In this article, I will go through the initial steps in evaluating a SQL query using the Db2 explain output.
IBM® Data Server Manager is an integrated database management tools platform. In this article, learn how to use the Query Tuning functionality that is included with the Base edition of DSM at no additional charge to tune the queries running in your DB2® for z/OS® environment.
By now, most DB2 for LUW users have probably heard about the release of DB2 11.1 that became available in June of this year. In this article I’d like to provide more information on some performance optimizations in DB2 11.1 that will benefit queries accessing both row and column-organized tables.
This video is a presentation given at the IDUG DB2 North America Tech Conference in May 2015. It begins with Adrian Burke discussing the challenges associated with tuning dynamic SQL. Then Saghi Amirsoleymani comes in to discuss the features in the no-charge version of IBM Data Studio.
Dynamic SQL statements can remain in the dynamic statement cache for a long period of time. When the statement gets refreshed, its access path could change dramatically. This article shows one way of limiting the impact of such an access path shift.