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.
An under-appreciated set of ANSI SQL functions introduced over a decade ago could dramatically reduce application chattiness and improve response times.
We always assume that tuning, will result in actual monetary savings. Well, with IBMs Measured Workload Pricing this is not always the case. Join well known DB2 speaker Phil Grainger as he explains how IBMs MLC works in practice and what this means to our DB2 world.
IBM Data Studio is a no-charge download that provides lots of functionality for working with DB2 databases on all platforms. This post will help direct you to some resources for finding out more about IBM Data Studio.
With each new release, DB2 is getting smarter and smarter. However, DB2 is not yet clairvoyant enough to understand the intentions of all queries and turn them into optimal forms. What’s the bottom line? Do you need to worry about how you code? The answer is yes, but not as much as in the past.