Articles & Content

Archives

D15 - DB2 LUW Performance FAQs, volume 5 - Solving More Puzzles!

Topic: 2015 EMEA

Subtopic: DB2 for LUW



In this presentation, we'll go through a broad scope of performance questions, issues and optimizations that may be affecting YOUR system. For example, in an environment with lots of SQL stored procedures, how do you identify where the bottlenecks are? What's the easiest way to spot possible access plan changes in a busy system, and how does the newest DB2 10.5 fixpak make this even easier? What's different about DB2 performance in the cloud, compared to on-premise? How do you update OVERHEAD and TRANSFERRATE for your new, super-fast flash storage? Bufferpool, log buffer, package cache - can there be too much of a good thing? And as always - lots of good performance monitoring tips.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.