Session 1 of the DB2’s Got Talent 2012 Competition
svisser1 2700018UK9 Visits (4050)
Were you able to join today’s DB2 Night Show webinar? Today was the start 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- Richard
How to Find all DB2 Instances on an LUW Server
If you only have one instance, this is very easy to do and not really worth talking about. But, if you have multiple instances and versions and fixpacks, db2ilist is not that helpful. Richard suggest that you use a command to view the DB2 Global Registry to see all the instances. This command only works on Linux and Unix and is not documented. Richard’s presentation was very informative and well laid out. The content focused on a little-known, but useful command.
Contestant 2 – Sameer
Physical DB Design is the Foundation of Your Database: Plan it Well
You may remember Sameer from last year’s competition. Sameer chose a very broad topic and we’ve seen large books and 4-day courses that have covered this topic. As a result of so much material to cover, Sameer wasn’t able to finish in time. The presentation and material was very laid out and the tips that were provided were well thought out and useful.
Contestant 3 – Douglas
Oracle to DB2: After Migration Tuning Tips
Douglas chose a great topic, in my opinion, and given the thoroughness of how it was covered, I think that many people will benefit from this presentation. Douglas wasn’t planning on covering the whole topic in his 4 minute allotment, but he did prepare material for future presentations if he is kept on as a contestant. In this presentation he covered data type issues. A quote from Douglas that I loved and Klaas repeated: Oracle on DB2 runs faster than Oracle on Oracle.
Contestant 4 – Lenin
Rooting out Transactional Log Full Error in DB2 LUW
Lenin’s presentation was very thorough and provided definitions and examples. Martin thought that there might be a slight error in Lenin’s logic. The slides were great, but he ran out of time. He also spoke faster than I was able to listen.
Contestant 5 – Yonghang
Lock, Chain, and Deadlocks – In One Shot
Yonghang showed the many ways that problems can happen, gave examples and excellent tips to overcome the problems. The commands that Yonghang researched and presented today are new and not very commonly used. The presentation was very well done.
The judges, Martin Hubel, Klaas Brant, and myself chose Richard, Douglas and Yonghang to move onto the next round based on the relevance of their topic and the quality of their presentations.
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