It's inevitable that you see a couple of DB2 fix packs every year and place the readme document in a drawer somewhere for perusal later when you are not busy. While the fix packs may contain fixes there are sometimes a few enhancements buried in the fine print.
OVERHEAD and TRANSFERRATE are tablespace parameters that the optimizer uses to help choose an access plan. Are the defaults good enough? (hint: probably not) In this blog post, I describe a simple way to measure values for your system.
As guest blogger, Russ Stocker shares useful tips on DB2 Large Object (LOB) performance. Part 2: a primer on LOB storage management
Understanding DB2 for LUW Buffer Pool I/O
You will get virtually no argument from anybody that buffer pool management is important to good DB2 and application performance. Large buffer pools are a well known wisdom. There are many ideas on buffer pool management, including the number of buffer pools
By now, most DB2 for LUW users have probably heard about the release of DB2 11.1 that became available in June of this year. In this article I’d like to provide more information on some performance optimizations in DB2 11.1 that will benefit queries accessing both row and column-organized tables.