The DB2Night Show #59: DB2 LUW Index Design, Myths, Realities, and Magic


Posted by scott on September 30, 2011, 1:55 pm
in DB2 LUW ( The DB2Night Show)

96% of our studio audience indicated they learned something! Our special guest was Martin Hubel, Owner MHC, an IBM DB2 GOLD Consultant, and IBM Information Management Champion. Martin claims to have put THREE children through college by fixing index designs. In Episode #59, you can learn Martin's secrets and advice, and score some very helpful SQL commands to aid your own analysis! Watch and learn...

96% of our studio audience indicated they learned something! Our special guest was Martin Hubel, Owner MHC, an IBM DB2 GOLD Consultant, and IBM Information Management Champion. Martin claims to have put THREE children through college by fixing index designs. In Episode #59, you can learn Martin's secrets and advice, and score some very helpful SQL commands to aid your own analysis! Watch and learn...


Host Commentary


If you don't know Martin Hubel, then you haven't been working in the DB2 world for very long. Martin is world famous, known for great presentations at IDUG, and he served the DB2 community as an IDUG volunteer for many years.


What you probably don't know is that Martin is my mentor and friend. In 1998, I was at an IDUG conference talking about "At 200GB Every Mistake is a BIG One!". Martin said to me "That was a great presentation - you're probably ahead of the bell curve in DB2 LUW performance expertise - you should be a consultant like me." I said, "I don't know how to be a consultant." Martin quipped, "It's easy. First thing you need to know is how to buy beer. Go buy me a beer and I'll teach you!" And, on the heels of his sage advice, my consulting career and first company was born.


So, let me shoot you straight. When Martin speaks, listen carefully. It's good for your skills and career.


Join The DB2Night Show™ LinkedIn Group


The DB2Night Show™ has a LinkedIn Group. The "closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!



A message from today's show sponsor



During today's quick commercial break, DBI used Brother-Panther® to demonstrate and embellish some of the important index advice that Martin was sharing. More specifically, what you'll see:


Please watch our short 2 minute 26 second video. Click Play. Thanks!











Our #1 Job is helping you look great!

Our #2 Job is giving you the documentation to prove it!


Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.


Get the Download Replay



To download a recorded replay of Episode #59, right click on the link below and choose "Save As..."

Episode 59, 30 September 2011, DB2 LUW INDEX Design, Myths, Realities, and Magic with guest Martin Hubel.


Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the M4V ( MP4 ) format!



Share a great show with your friends and followers:





REMEMBER to REGISTER for upcoming shows! www.DB2NightShow.com icon_cool Our Season #3 show schedule is published through the end of 2011!

Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=293