Articles & Content


Just the FAQs, part III - More DB2 LUW Performance Gems - D14

Topic: 2012 NA

Subtopic: DB2 for LUW

This session brings another installment of hints and tips, and - yes - gems of performance information, gathered from diligent lab work, and experience in the field. As always, we focus on the questions that are frequently asked - but not always easily answered. We'll cover the performance apects of some of the latest DB2 features, as well as demystify some long-standing issues that could be keeping you from getting the most out of your system. For example - what kind of performance impact does CPU and IO virtualization have? Is it really (really) necessary to put my transaction logs on a separate device? How do I find the longest-running transactions in my system? Will the statement concentrator really make all my package cache problems go away? What are the performance impacts of declared global temporary tables (DGTTs)? Automatic maintenance is great, but how much performance overhead does it add?

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.