Articles & Content

Archives

Hunting and Eliminating Obsolete Indexes at UBS AG (B09)

Topic: DB2 for z/OS

Subtopic: 2008



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.



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.