Articles & Content

Archives

DB2 LUW Performance - You've got (frequently asked) questions, we've got answers! (D11)

Topic: 2010 EMEA

Subtopic: DB2 for LUW



DATE: 2010-11-10 (13:00 - 14:00)
SPEAKERS: Steve Rees (IBM)

You might think that DB2 performance question you have is a new, never-before-seen one, but chances are, someone's been there before you - so why not take advantage of that, and find out what they did to solve it? Following on from previous 'performance FAQ' sessions, this year's edition will bring you a new set of common DB2 performance questions (and answers!), to help save you time, should these problems come your way. Topics will include how to get the most out of the latest monitoring features, how to optimize utility performance, what are the best uses in a DB2 system for solid-state disks, what kind of a performance boost can be expected from the latest CPU architectures like Power7, as well as questions about DB2 pureScale.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

What's the best way to exploit these mysterious, new performance monitoring elements, such as 'time spent' metrics?

What's the best way to configure and run DB2 utilities like LOAD and BACKUP, to maximize performance?

What kind of a performance boost can I expect to get from moving up to a newCPU architecture like Power7 or Intel Nehalem?

Solid-state disks can provide amazing I/O performance. How do I use them,to get the most 'bang for the buck' ?

How are performance considerations for DB2 pureScale different from other DB2 configurations?



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.