The Inside Scoop on DB2 LUW MDC Tables
IBM Guests Paul Z and Pate Bates Reveal How MDC Works, Best Practices, and Success Stories
In episode #37, special IBM guests Paul Zikopoulos and Pat Bates talked about how MDC tables work, some design best practices, and shared some impressive customer success stories. If you have a Data Warehouse database, this show is a "Must See". If you have an OLTP database, there are situations where MDC can make you a performance rock star. Watch this replay and learn!
On 21 January 2011, The DB2Night Show™ will take another look at MDC tables with "MDC Tables in The Real World". Our guests include IBM DB2 GOLD Consultants from the UK.
To download a recorded replay of Episode #37, right click on the link below and choose "Save As..."
Episode 37, 14 January 2011, DB2 LUW MDC Tables - Technical Details with guests Paul Zikopoulos and Pat Bates, IBM.
Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the M4V ( MP4 ) format!
Want a PDF of the slide deck? Keep reading...
Join The DB2Night Show™ LinkedIn GroupThe DB2Night Show™ now has a LinkedIn Group. The 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!
Our Shameless Marketing Moment
Our guests mentioned that the IBM DB2 Design Advisor can help you analyze potential MDC tables that would benefit performance.
During DBI's quick commercial, we showed just how easy this analysis can be. DBI's Brother-Panther® accurately identifies the SQL statements that are the most harmful to your database's performance - in just ONE mouse click!. One or more costly statements can be passed to the Design Advisor as a workload to obtain optimum results. And powerful trend charts make it easy to document the performance benefits achieved from any tuning changes you make.
DBI is offering a free educational webinar "TEN SQL Snapshots you MUST run TODAY" on Friday, 21 January, 2pm Central (3pm Eastern, 1pm Mountain, 12pm Pacific, 8pm GMT). Attendees will receive the SOURCE CODE for the SQL Snapshots! For details and the registration link to this free event, visit DBI's EVENTS page.
Our #2 Job is giving you the documentation to prove it!
To protect the intellectual property of our guests, we don't usually make the slide decks available. However, in this case, the slides contained a great deal of helpful technical content and our guests have willingly shared a PDF for our audience. We still recommend you watch the recorded replay first to hear what our IBM guests have to say, then use THIS PDF as a reference.