Team with the best
Db2® LUW Performance Tools
company in the World

The DB2Night Show #117: Feelin' BLU - The HOTTEST IBM DB2 BLU video ever!

October 19, 2013, 12:38 pm
Posted by Scott in DB2 LUW
Scott Hayes' Laptop in Refrigerator
IBM BLU is so HOT that the replay videos had to be rendered in Scott's refrigerator to prevent his laptop from overheating!

Special Guests: Scott Hayes, DBI, and Randall Ibbott, QBE

Feelin' BLU - Beyond the Marketing Hype
DB2 Users Test Drive BLU!

95% of our studio audience learned something! During this episode of The DB2Night Show™, we skipped the marketing BLAH BLAH BLAH and real IBM DB2 BLU users shared their performance science projects and experiences! Watch and learn...


A message from our sponsor:
DBI Software

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 #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.

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 BLU

Unicode 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!

Footnotes

This 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 Information

Here'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! icon_biggrin

Share a great show with your friends and followers:

Printer friendly