Articles & Content

Archives

D11 - DB2 LUW Performance FAQs: Wait ... Tell me that again?

Topic: 2014 EMEA

Subtopic: DB2 for LUW



In this session, we recap some persistent and useful 'frequently asked questions' from previous IDUG 'FAQ' presentations. We'll start it off with some really valuable fundamentals on basic performance monitoring, followed by a simple step-by-step process for investigating performance problems. We'll talk about LOB performance - a topic which continues to come up all the time. We'll look at the VOLATILE keyword and what it means for access plan selection by DB2. We'll dig into usage lists & how they can help you find unused indexes, and how to get the best performance out of user temporary tables & sequences. And last but not least, we'll also through in some brand-new topics as .well



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.