Topic: 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.