Topic: 2011 NA
Subtopic: DB2 for LUW
DATE: 2011-5-4 (02:45 PM - 03:45 PM)
SPEAKERS: Paul Turpin (S1 Corporation )
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.
EXP. LEVEL: Intermediate
Why indexes are good / why indexes are bad
How to use reorgchk and catalog queries to examine index health
How to use db2pd to collect index usage information and put it into a DB2 table
Connect index usage information with explain information
DB2 9.7 index catalog information examined
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.