Articles & Content
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.