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.
To round off this month's DB2 for LUW performance topics, we are please to have another contribution from frequent contributor Joe Geller.
In this article he discusses how to determine when tables and indexes need reorgs.