Articles & Content


Diet DB2 with Twist (D05)

Topic: 2009 NA

Subtopic: DB2 for LUW

DATE: 2009-5-13 (09:45 AM - 10:45 AM)
SPEAKERS: Vijay Sitaram (McKesson Corp)

Diet DB2: (60 minutes - DBA talk on Memory, CPU and Storage optimization)When everyone around the world is talking carbs and calories, why not DB2?Let's take a look at layers of trimming down the extra CPU usage, reclaiming wasted memory and save on disk space. DB2 V9 offers some excellent features to control resource consumption across the board. Over the course of presentation, we will talk about different ways of getting our DB2 database system in shape. What we will discuss and share our findings in areas related to OS tuning related to memory, storage optimization and performance bottlenecks that can cause systems to run hot. We will also talk about what not do & best practices to maintain a healthy system. Finally, we wrap up this session with some tid-bits of information that makes DBA's smile ;) At the end of 60 minutes, you will have one lean mean database machine!

EXP. LEVEL: Beginner,Intermediate


Foundation for getting DB2 on DIET! The Nutrition Facts, what it takes to get DB2 DataWarehouse running efficiently with the resources available on the system. Practices such as BCU is discussed here to set the foundation for the next 60 minutes.

Where did my memory go? Optimizing on memory usage and allocation is the most important part of tuning the system. We look at different ways to gather metrics on memory usage and allocation to validate the current system and it's usage.

How can I maximize my storage? We discuss efficient storage layout, optimization and utilization. We discuss best ways to lay the database for DPF, pick part the features such as HASH/RANGE/MDC keys with compression.

Do I need more horsepower? In this section, we will identify ways to burn the CPU and how to avoid them by using simple tuning efforts on DB2 and application side. What are the top cpu consumers and how to go after them?

Lesson's learned & Tid-Bits...This section is a compilation of some interesting facts/PMR resolutions/tried and tested and proven methods of running a successful data warehouse.

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.