Articles & Content

Archives

Hunting and Eliminating Obsolete Indexes at UBS AG (B09)

Topic: 2008 EU

Subtopic: DB2 for z/OS



DATE: 2008-10-15 (09:30 - 10:30)
SPEAKERS: André Goetschy (UBS AG)

The purpose of this presentation is to show and explain what has been performed with a taskforce at UBS AG, one of the largest DB2 for z/OS environment in the world, in order to detect and eliminate redundant, duplicate and obsolete indexes in a huge DB2 for z/OS production environment and what are the early wins as well as the constant benefits of such an action. - How to detect obsolete indexes - The reasons and negative impacts of the duplication/redundancy - Real life findings - Benefits of the cleanup action.

EXP. LEVEL: Intermediate

OBJECTIVES:

How to detect obsolete/redundant indexes ?

What are the impacts of the index duplication/redundancy on the performance and the availability ?

What are the reasons and causes of the index duplication/redundancy ?

Real life findings

Benefits of the cleanup action.



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.