Articles & Content


DB2 LUW Design Advisor - db2advis ? Miracle-Worker or Monster-In-Law (D13)

Topic: 2010 NA

Subtopic: DB2 for LUW

DATE: 2010-5-14 (08:30 AM - 09:30 AM)
SPEAKERS: Alexander Kopac (Home Depot)

The DB2 LUW Design Advisor is cool tool designed to help define suitable indexes and for testing SQL workloads. Here's a presentation that covers both the command line syntax basics and the GUI approach for making both miracles and monsters. Based on many real life user experiences, you learn how to discern the miracles from the monsters in order to dramatically improve overall DB2 LUW database performance. You will see & learn a step-by-step process on how to develop that 'discerning eye' needed to evaluate the index recommendations and cast away the less than useful monster index recommendations. This presentation will show frequently found and common user experience 'opportunities' for rather large databases - i.e. 30,000-80,000 tables in DB2 LUW systems supporting Peoplesoft, BAAN, SAP and other large table/index systems. DB2 LUW indexing best practices and guidelines will be provided.

EXP. LEVEL: Beginner


db2advis - Design Advisor Command Line junkie feature basics

Design Advisor Graphical Interface feature basics

Techniques for evaluating Index Strengths and Weaknesses

Spotting miracles and monsters

DB2 LUW Index Best Practices & Guidelines

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.