IDUG DB2 Tech Conference EMEA 2011
Clarion Congress Hotel, Prague, Czech Republic
14 - 18 November, 2011

View Printable Version

Index Friend or Foe?

Session Number: 1847
Track: DB2 for LUW Lessons Learned (D)
Session Type: Podium Presentation
Primary Presenter: Paul Turpin [Database Architect - ACI Worldwide]
Time: Nov 15, 2011 (01:00 PM - 02:00 PM)
Room: Taurus

Speaker Bio: Paul Turpin is a senior database administrator for a software development company specializing in financial applications. He specializes in DB2 for LUW on large systems. He enjoys exploring new features and functionality in DB2. He has spoken at IDUG North America, IDUG Europe, SHARE, IBM’s Information on Demand conference, and several RUGs. Paul currently serves as past chairperson on the IDUG North America Conference Planning Committee.
Audience experience level: Select a Value
Presentation Category: Managing Database Resources
Presentation Platform: Select a Value
Audiences this presentation will apply to: Database Administrators, New Users
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Tools and Utilities, User Experiences
If Tools and Utilities was selected which products: reorgchk and db2pd
Objective 1: Why indexes are good / why indexes are bad
Objective 2: How to use reorgchk and catalog queries to examine index health
Objective 3: How to use db2pd to collect index usage information and put it into a DB2 table
Objective 4: Connect index usage information with explain information
Objective 5: DB2 9.7 index catalog information examined

Abstract:  Indexes are touted as one of the best performance inventions ever. Many times they are your friend, but they can also be your enemy. This presentation looks at how you can check the health of your indexes with reorgchk and catalog queries. For those of you on pre-DB2 9.7 release, we will look at how to use db2pd tcbstats plus catalog queries to collect index usage into a DB2 table. We will also look at how this information can be connected to explain information. For those of you on DB2 9.7, we will look at some new index information in the catalog including index usage and index statistics.

For questions or concerns about your event registration, please contact