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.
We use Explain to find out the access path for a query. Jim Dee, from BMC shows you how you can compare the access path with previous versions of the query or package – comparing the estimated costs, and identifying those that have changed with a rebind.