Articles & Content

Archives

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

Topic: DB2 for LUW

Subtopic: 2015



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 which ones, and which statements within them, are the bottlenecks?  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?  We all know that having too little memory for DB2 is bad - but is there such a thing as too much memory?  How do you update OVERHEAD and TRANSFERRATE for your new, super-fast flash storage? And we'll tackle a question that comes up all the time - how to do a quick performance health check on your system? We'll show how you can do it in just 10 minutes! 



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.