Articles & Content

Archives

DB2 LUW Performance - Just the FAQs! (D01)

Topic: DB2 for LUW

Subtopic: 2008



DATE: 2008-5-19 (09:45 AM - 10:45 AM)
SPEAKERS: Steve Rees (IBM Toronto Lab)

What's the best approach for fast INSERT performance? How do I minimize the impact on my system when I'm collecting performance data? How much faster will my system run when I move to 64bit? What snapshot elements should I pay attention to for everyday monitoring? How much overhead can I expect if I create my database in Unicode? ... This presentation will cover a wide variety of common DB2 performance questions, in areas such as implementation, administration, and application development. The typical answer to performance questions is "it depends", but in this session we will take a straightforward approach, with emphasis on clarity, useful guidelines and rules-of-thumb. Underneath these answers will be a solid foundation of 'why' - including experimental data and explanations of DB2 internals. This will provide attendees with useful information on some of the most common & persistent DB2 performance questions.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Attendees will learn the answers to many frequently asked DB2 performance questions - including ones they had when they walked in the door, and also other they hadn't yet run up against.

We will be touching on a number of important overall topics, including system configuration, application development, monitoring and tuning. This will comprise a very good survey of the most common areas for performance questions.

In discussing and answering our 'FAQs', we will drill down as necessary into the underlying DB2 architecture, to uncover the reasons behind the answers we give. This will help attendees get a better understanding of what's going on inside DB2.

Storage, memory and CPU factors have a large impact on performance, so we will deal with questions in these areas as well. This will provide attendees with information to help with system planning & sizing, as well as managing current systems.

The process to follow and tools to use to answer some of these questions can be as important as the answer itself. Where it's useful to attendees, we will provide best practice information on using the relevant performance diagnostic tools.



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.