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.
In this comprehensive overview of DB2 10, for z/OS Lori Ann Galluzzo goes through the features of DB2 10 in great detail. Each feature is discussed, along with how and when to take advantage of the feature, as well as some pitfalls and things to watch out for.
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.
When dealing with a database, it is important to understand the “DB2 catalog” concept. The catalog is a set of DB2 tables that store the DB2 system state. Almost every action that takes place in DB2 is reflected in a change to one or more catalog tables.