Third Episode of “DB2 has Talent”
svisser1 2700018UK9 Visits (4714)
What an exciting week! With Watson winning on Jeopardy, meeting a member of the Watson team, and then today, the 3rd episode of the DB2Night Show’s competition DB2 has talent.
Today’s episode was particularly high quality. I think many of today’s contestants have enough knowledge to write books with very valuable content! Let me tell you about the contestants we met today:
John - “How to Move Data from Mainframe to LUW”
John has 39 years experience using various databases from IBM – IMS, DB2 for z/OS, DB2 for LUW, and maybe even SQL/DS… and his expertise showed. He provided scripts that could actually be used by people who are trying to accomplish what he did. His presentation was easy to follow, gave actual examples as to how he was able to move the data, and he finished in time.
Bob (Robert) – SQL Tuning Tricks – Perils of Using “not in”
OK, we didn’t actually hear from Bob, but we did see the first page of his slides. There were many technical issues with the meeting software today (I know first hand!) so hopefully Bob is able to come back next week. His topic sounds interesting and his first slide was promising. Let’s hear from you Bob!!
Naveen – Improving Database Performance by Choosing the Right Index
Naveen gave a very thorough and relevant presentation on indexing. His figures and cautions made the content very easy to follow. The only criticism is that Naveen failed to tell us that DB2 9.7 takes away the need for much of what he presented.
Ramesh – Determining which Indexes can be dropped
Ramesh was slightly less easy to understand than Naveen, but he did include information about how DB2 9.7 changes the indexing story. It’s too bad that we had back to back presenters discussing nearly the same topic, but that just tells us how important this task is.
Sameer – Optimizing Application Performance with DB2
This was Sameer’s second appearance on the DB2 has Talent competition. He was asked to cut his material down significantly and to re-present. Sameer took the challenge and excelled! His content could fill a book with truly amazing tips along with understandable explanations.
Jefferson – SAP and BufferPools
I’m sorry Jefferson, but I missed part of the title of your presentation. Jefferson gave a very detailed presentation about an important topic. He was able to gather examples that involved a very large amount of data and to demonstrate how to use bufferpools with SAP.
Thiru – Explain from Actuals
I think we all went away from this presentation realizing that Thiru had very nicely demonstrated a very little used stored procedure. It made me realize that there are problem many un-mined functions and features that DB2 offers that are not well known or well used. What an opportunity for future contestants!
Yogesh – Troubleshooting DB2 Work Load Manager
I think the only issue with Yogesh’s presentation was the sheer magnitude of the size of this topic. Yogesh wasn’t quite able to finish his presentation, but did a good job of showing the benefits of using WLM. My suggestion to Yogesh is that his presentation would have been more impactful if they had told a story from beginning to end. The way it was, there was too much time spent on the definition. Brave attempt!
Really this was a very high quality set of presentations and 96% of the attendees said that they learned something new. The tips that we were given were very much worth the price of admission! If you missed this show or the previous two, you can get the replays on the DB2Night Show page.
After much deliberation, we judges, Martin Hubel, Klaas Brant, and myself were able to inform host Scott Hayes that the following contestants should move on to the next round:
John, Sameer, and Thiru
Way to go! We are very much looking forward to seeing you present at the next round.
See also my previous blogs about the DB2 has Talent Competition: