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.
Want to know which MON_GET functions give you information about CPU usage? Can't remember how many input parameters there are to MON_GET_BUFFERPOOL? The Information Center can tell you - but here's a much faster way!
We hope that you’ve enjoyed this month’s articles on DB2 performance on z/OS.
We talked about the new performance possibilities in DB2 11, about performance hints and tips for framework development, about explaining tuning to C-level and about efficient ways of replication.
The second entry of this month’s theme, DB2 for z/OS performance, is a video by Thomas Baumann covering “Tuning Explained to C-level”. Take the time to watch this great video by one of IDUG’s Hall of Famers. Because, as important as tuning your system, is explaining what you did to your management.