Special Guests: Scott Hayes, DBI, and Randall Ibbott, QBE
Feelin' BLU - Beyond the Marketing Hype
A message from our sponsor:
During Scott's presentation on IBM DB2 BLU you'll see an example of how DBI can compare SQL workloads across two different timeframes. Thinking about trying BLU? How about using DBI to help you compare the SQL performance benefits?
Our #2 Job is giving you the documentation to prove it!
Show Host Scott Hayes Commentary
Despite testing in advance, we had some technical audio difficulties with sharing Randall Ibbott's EXCELLENT IDUG AP Melbourne presentation on his BLU evaluation. The live show included Scott's presentation materials on his BLU tests plus bonus feedback from another BLU evaluator - "Charles in France". The replay video that you are about to thoroughly enjoy has been edited to incorporate Randall's presentation and I'm pleased to report that the audio quality is good!
What you'll learn about IBM BLUUnicode databases required. INTRA_PARALLEL YES required. Repeatable Read (RR) Isolation not supported. Comparing ORGANIZE by ROW and ORGANIZE by COLUMN performance, side by side, on the SAME servers. SAVECOUNT on LOAD is not supported, so "LOAD and PRAY." RUNSTATS observations. LOAD performance. COMPRESSION results. Use BLU for Analytics queries, not OLTP. Some Queries run faster, some don't. HARDWARE recommendations. Individual results will vary. You must test!
FootnotesThis was our first attempt to have a "virtual" guest appear via pre-recorded video. It should have worked splendidly well, except bloody Microsoft Windows decided to download 28 or so updates during the show, and the anti-virus software was compelled to do a system scan. Murphy's Law strikes again. The good news is that the replay includes Randall's EXCELLENT presentation on his BLU testing.
The rest of the story. Editing the replay video was no easy feat, though it should have been. Start with the show replay, cut out the bit where we struggled with Randall's piece, insert Randall's video, and then render the video. Initially I used Camtasia Studio. The editing was easy, but rendering the video would just "hang". I abandoned that effort, and used AVS4YOU video editor instead. Editing was even easier. Rendering, however, is so CPU intensive that my laptop overheated and shutdown/crashed without warning. TWICE. On my third attempt to render the video, I set the Processor Affinity of the AVS process to only 4 of my 8 CPUs, then I put the laptop into the refrigerator. Success! However, due to the fine print and excellent performance numbers in Randall's presentation, this replay had to be rendered multiple times at various high resolutions. There are three replay links instead of our usual two, and the WMV video, rendered in HD, is 4X larger (about 430MB) than our usual WMV. Meanwhile, I confess I enjoyed the beer that was evicted from the refrigerator to make room for the laptop. What a day!
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!
Insider InformationHere's another great reason to join The DB2Night Show LinkedIn Group: SECRET INSIDER INFORMATION. Every once in awhile, we run shows where EVERYONE in our studio audience can be a prize winner! JUST SHOW UP and COLLECT! We only announce these special shows within The DB2Night Show LinkedIn group!
Everyone that attended Episode #110 Database Performance Trends and gave us the prize word SLIPPERS won a $10 gift certificate to Amazon.com, Lowes.com, or Starbucks, or we made donations to the American Red Cross or Big Brothers Big Sisters - at the choice of each show attendee! IT PAYS TO LEARN DB2 on The DB2Night Show!
Congratulations!Congratulations to Paul Costa at Physicians Mutual in Omaha Nebraska! You've won a $25 Amazon.com gift card! Thank you for completing the survey after show #116 on BLU Intimate Details with IBM Master Inventors!
Get the Download Replays
WMV HD Format - approximately 433MB
To download a recorded replay of Episode #117 in WMV HD format, right click on
the link below and choose "Save As..."
Episode #117, 18 October 2013, Feelin' BLU with Scott Hayes, DBI, and Randall Ibbott, QBE
MOV - Quicktime Format - High Resolution
Have Quick Time player? This replay option offers high quality resolution at roughly 131MB. Right click and download the QT ( MOV ) format! 21 OCT 2013 11am CDT Update: This is a new format for us. One user has let us know they have audio problems. We are checking. If you have trouble with a replay, let us know at @db2nightshow. 11:08am CDT Update: Audio works for us!
MP4 Format - standard resolution - 123MB
Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!
Did you learn something from this show?See that "Mail this" link below? Click it and do a friend a favor - share this blog post and show with one of your friends or peers. THANKS!
Share a great show with your friends and followers: