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.
The purpose of this article is to decode the DB2 backup and restore performance statistics that are now logged in the db2diag.log. It will also discuss some factors that influence backup performance and how the performance stats can be used to identify where performance bottlenecks exist.
Performance problems can be tough to solve, especially if you've not had to deal with them much before. In this session from IDUG NA 2016, Steve Rees goes through a step-by-step, decision tree-based approach for tackling performance problems.