Session 2 of the DB2’s Got Talent 2012 Competition
svisser1 2700018UK9 Visits (4255)
Were you able to join today’s DB2 Night Show webinar? Today was the second show of this year’s very popular competition. If you missed it, I strongly encourage you to watch the replay. Here’s what you’ll get:
Contestant 1 – Kohli
Kohli’s presentation showed how you can backup your database on one filesystem and redirect it to another. He very clearly went through a scenario where he did so and showed the errors that can result and how to solve the issues. Unfortunately Kohli ran out of time during the critical part of the presentation where he was explaining how to resolve the issues that resulted from using the restore redirect command. It was a good presentation, but needed more pictures and more focus on solving the issues rather than defining the process.
Contestant 2 – Elder
Yet Another db2imigr Command Alternative
Elder’s topic showed how to version migration when there is no window for an offline backup and restore. This wasn’t an elegant solution, but is a great trick to use if that’s the only option. It was a good presentation and very clearly delivered. Elder came in on time and admitted that he practiced his timing in order to come in on time.
Contestant 3 – Renu
How to Use Statistical Views to Optimize and Tune SQL
Renu showed us how she tuned a 200 line SQL statement for her client. Her client wanted her to use MQT, but she chose to use Statistical Views instead. She defined both MQT and Statistical Views and explained the pros and cons of using each. As a result of her tuning, she was able to show a 99% improvement in running time. I thought it was a very easy to follow presentation and was well done.
Contestant 4 – Rajesh
Tip for DB2 Instance Check
This happened once last year as well, Rajesh had a good topic, but decided not to create slides to present the topic to us. He showed us source code, but it was hard for me to follow. Rajesh mentioned that he didn’t have PPT installed, so I want to suggest that Google has a free presentation software that he should look into. Another alterative is to increase the fonts in a word document so that it looks like a slide deck. I think it would have been a great presentation if he had used the slides.
Contestant 5 – Sharad
MQT – Friend or Foe? How to turn Foe into Friend
Sharad defined the terms and showed a case study for overcoming MQTs limitations of using too much log space. I found it hard to hear Sharad and therefore found it somewhat hard to follow the presentation. My more technical co-judges found the topic interesting especially when you have Big Data stored in your tables.
Contestant 6 – Srini
Move Table Online Using admin_move_table
Srini’s presentation showed how to use a new DB2 9.7 command to move a table that is growing more than 64 GB. I found it hard to follow the presentation. Maybe the slides were too busy. Maybe Srini didn’t project when speaking. My co-judges really liked the topic and found the presentation very valuable and topical.
The judges, Martin Hubel, Klaas Brant, and myself chose Kohli and Elder to move onto the next round based on the relevance of their topic and the quality of their presentations. We had much trouble choosing who should move on since many of the presentations were superb. If there is still room in the schedule, those who didn’t get chose should see if you can get another contestant slot. Talk to Scott.
Do you agree with our choices? If you watch the replay, you’ll be able to fill in a survey to let us know if there is someone else who should also move on. Listen for the great tips and for your opportunity to advance another excellent contestant.
Join us every Friday in February for contestant presentations. March is reserved for the finals where those who have moved on will present a second time and the listeners can choose the winner rather than the judges. The commitment for March has lessened in that there will only be 3 shows in March rather that the originally planned 5. We still have openings for a couple of contestants, so if you’re interested, sign up to join!
Thanks to host Scott Hayes for this opportunity for me as a judge and for the contestants for helping them build technical presentation skills that are so valuable.
For details on the prizes for this competition… and a summary of last year’s
event… see my blog entry: http