We’ve all heard the expression that practice makes perfect. I can prove that this is the case. Watch the seven episodes that we’ve done so far on the DB2’s Got Talent Competition on the DB2Night Show and you’ll see how each presenter and presentations gets better & better. You know what this show is actually doing? This competition is grooming many people to become future speakers at conferences such as IOD and IDUG.
The theme for today’s show was Personal DB2 Success Stories. Seven people presented. Let me tell you briefly about each:
Norberto – A Handmade ETL Solution
ETL = Extracting, Transforming, Loading. Like the pro he is now, Norberto laid out the problem, the need, and a creative solution using triggers, procedures and functions. Very well done.
Momi – Old School Table Partitioning
Momi used a fair amount of humour in today’s presentation and it worked very well. He clearly described the problem of having a table that continued to have more data coming in. Restrictions included a need to keep the table size constant and no time for maintenance. Momi gave us a few possible solutions and advantages of each.
JB – A Terabyte of Data & Trouble with I/O
This sounds like it could be a very common problem. JB showed us how she used the DB2 V9.7 rebalance feature to improve performance and contention by 90%.
Mary – Using SQL to Write SQL
Mary gave us a very creative way to use scripting. She gave very clear instructions with pointers as to what to watch out for. With a small amount of work, these scripts could be used on the mainframe as well.
Ahmad – Fix Runaway Job & Change Developer’s Mindsets
The SQL examples that Ahmad showed were very complex, but he did a nice job of taking us through the details. The suggestion that DBAs need to work with their developers was a good one.
Thiru – Influencing Optimizer for Success
Although this is a risky thing to do, Thiru did a fine job of taking us through how to create an optimizer profile that can improve performance of a statement that ran 4 hours. He succeed using the DB2CAEM utility (which he said is like a flight simulator) and now the statement takes 4 minutes to run.
Bob – Searching for the Needle in a CLOB Haystack
Last, but not least, Bob showed us how he created a Java application to do string manipulation to improve performance over using the LIKE option. This was a cookbook type of presentation that gave many tips on how to perform the actions.
This episode we had to send two people “home”, unfortunately. And just as it is on American Idol, this gets harder to do each week because the quality of each presentation is amazing and 100% of the audience said they learned something new during this show. The judges, Martin Hubel, Cristian Molaro (sitting in for Klaas Brant this week), and myself were in agreement with the results from the audience poll. We decide to send Thiru to the finals and said good bye & thank you to both Bob and Ahmad.
Now we need your help… now, more than ever. We need you to watch the replays and to decide which presentation you think is best. Vote for the best to decide who will go on and will get a free pass to an IDUG conference of their choice.
To vote, use this URL: https://www.surveymonkey.com/s/DB2TalentFinals3
Thanks to Scott Hayes for putting this show together to Entertain and Educate us. Thanks to all the participants for your dedication to DB2 and for sharing your experiences with all of us. All of you are quite talented and should consider presenting to a live audience at a future IDUG event.
Join us next week for the final show of the competition. There will not be a show on April 1. The winner will be announced on the show on April 8.