The DB2Night Show #210: Db2 Performance Tuning- Indexes vs Prefetch


Posted by scott on December 21, 2018, 2:56 pm
in DB2 LUW ( The DB2Night Show)







title="Martin Hubel on LinkedIn">
Martin Hubel, MHC, IBM Gold Consultant



@mhubel


Special Guest: Martin Hubel

Owner, MHC

IBM Gold Consultant



Db2 LUW Performance Tuning: Indexes versus Prefetch!



100% of our audience learned something! Famous for putting his kids through college by Dropping Db2 Indexes, Martin covers a wide variety of Db2 Performance Tuning topics with focus on indexes, prefetch I/O, bufferpools, Db2 MDC and ITC tables, and much more (detailed below). Watch and learn from a top Db2 performance pro!








title="Martin Hubel on LinkedIn">
Martin Hubel, MHC, IBM Gold Consultant



@mhubel


Special Guest: Martin Hubel

Owner, MHC

IBM Gold Consultant



Db2 LUW Performance Tuning: Indexes versus Prefetch!



100% of our audience learned something! Famous for putting his kids through college by Dropping Db2 Indexes, Martin covers a wide variety of Db2 Performance Tuning topics with focus on indexes, prefetch I/O, bufferpools, Db2 MDC and ITC tables, and much more (detailed below). Watch and learn from a top Db2 performance pro!






Show Host Scott Hayes Commentary



This is definitely one the best, most helpful, most robust shows we've offered on the topics of Db2 LUW Performance Tuning. Martin and I have been friends since Db2 UDB V5, and, in fact, it was Martin who inspired me to become a Db2 consultant way back in 1998. We had a lot of fun producing this show. I drank eggnog and Martin enjoyed some specially flavored coffee. Santa Claus came to visit too - you'll hear his HO HO HO laughter. Enjoy our replays!


Speaking of replays, we are now publishing The Db2Night Show Replays to our YouTube Channel. Please subscribe!






A message from our sponsor:

DBI Software


In the interest of time, we didn't do a commerical today! You're welcome. icon_lol However, we did point out that Database Trends and Applications Magazine (DBTA) has now recognized DBI Software as a "Top 100 Trend Setting Products for 2019" solution provider - this is SIX years in a row!! icon_biggrin









Magic Hat Money

Working with DBI is like making money magically appear!


Typical customers enjoy 40-60% CPU utilization reductions in the first week, plus measurably faster
transaction and query response times. More importantly, your time savings will be substantial!
Read our newest title="Press Release: DBI and HealthPlan Services celebrate DB2 LUW successes!">SUCCESS STORY with
HealthPlan Services, do your target="NEW" title="Learn about the high cost of 'free' tools and do your due diligence">due diligence,
and speak with as many references as you have time to call.


We saved a health care company $250,000 in one afternoon, solved a performance problem in two hours that two senior
DBAs were unable to solve in six months, and we have helped top brand name retailers achieve top ranked e-Commerce
performance on Black Friday multiple years in a row. 8 of the Top 25 Retailers, plus others, plus top Banks,
State Governments, Manufacturers, Insurers, and more rely on DBI. How can we help you?
target="NEW" title="Let's have a conversation - Contact DBI">Contact DBI






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! href="http://www.linkedin.com/groupRegistration?gid=2761037" target="NEW" title="New Window: Join The DB2Night Show LinkedIn Group">Join The DB2Night Show LinkedIn Group!



The Agenda for "Db2 Performance Tuning-Indexes versus Prefetch"




Topics Discussed Include:





Get the Download Replays


WMV Format - approximately 85MB


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



Episode #210, 21 December 2018,
Db2 LUW Performance Tuning-Indexes versus Prefetch



MP4 Format - standard resolution - 154MB



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


NEW! Watch on YouTube!







PDF Handout



Martin generously agreed to share a PDF of his presentation, so you can get your copy here:

GET the PDF!




Sharing is Caring!


Share a great show with your friends and followers!

















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