Articles & Content
Topic: 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.
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.