Keep on Learning
Did you attend The DB2Night Show on Friday? We had the second show in this year’s DB2’s Got Talent Competition. I was on vacation during the first show, so IBM Champion Cristian Molaro was kind enough to fill in as a judge for me. I’ve listened to the replay, so here is my summary of both the first and second shows in this series.
Feb 1 - Show 1 of the DB2’s Got Talent Competition - watch the replay.
There were supposed to be a few other contestants on this show, but they were no-shows. We were still able to hear from Ember Mohankumar and Eric. All three gave great presentations.
Ember - tips for running db2haicu. Ember is moving on to the finals.
Mohankumar - DB2 LUW data movement utilities. Mohankumar is moving on to the finals.
Eric - the best ways to build an audit table using the partitioning feature of DB2 LUW. Eric was chosen as an alternate.
Feb 8 - Show 2 of the DB2’s Got Talent Competition - watch the replay.
We had 5 contestants on this show: Adam, Chris, Renu, Juliano and Sanjay.
Adam - The Real Benefit of Solid State Disks (SSD) Hardware Upgrade.
Adam’s story was about doing a hardware upgrade that greatly benefited a DB2 9, SAP, and WebSphere Commerce system. Adam’s presentation provided the basics, but didn’t give enough information to see why an upgrade of this kind was necessary. Adam was chosen as an alternate.
Chris - Making Life Easier - Letting DB2 Manage your Backup and Archived Transaction Logs.
Chris provided great times that are very easy to follow. They have 2 DBAs in their office and many databases, tables, and data to manage. Great story about how they were able to handle such a workload. Chris has been chosen as a finalist.
Renu - Small Changes, Big Results - Load Performance
Another presentation with great tips. Renu is moving on as a finalist.
Juliano - Efficient Aspects of Deleting Data in DB2 LUW
So many ways to delete data! Juliano will be a finalist.
Sanjay - Plan Management
This was a DB2 for z/OS topic... and a huge topic it is. Sanjay was chosen as an alternate.
Coming up on the show:
Feb 15 - Episode 3 of the DB2’s Got Talent Competition. There may still be room for one additional contestant.
Feb 22 - OK... now the judges are being put to work on this show. Martin Hubel, Klaas Brant and myself have been asked to put together presentations to share with you!
Thanks again to our amazing host for putting this show together: IBM Champion Scott Hayes!
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:
Today on the DB2Night Show, host Scott Hayes introduced us to the first 5 contestants on the “DB2 has Talent” competition. Scott tapped fellow IBM Gold Consultants Martin Hubel and Klaas Brant to be judges, as well as me. I must say it was put together very professionally and I think all participants and listeners had fun.
Here’s the lowdown on what we experienced.
First contestant Ramesh presented about db2top. Ramesh was clearly very skilled and passionate on this topic and it showed. Unfortunately for Ramesh, he went first, on the first show, so he was at a big disadvantage. Ramesh included too many slides to cover in the measly 4 minutes that he had available. As a result, we were not able to see his conclusion. There is much interest in the topic, so maybe we’ll have to have Ramesh back with a smaller set of slides.
Contestant two was JB. JB is clearly an experienced presenter since she didn’t sound nervous and she did a fabulous job. Here presentation was about using HADR to migrate low level hardware, OS, and software to more current levels. JB’s experience is something many people can learn from and she did a very nice job of explaining the problem, how she convince the team leads to try her solution and the amazing conclusion.
Mary was the third contestant and she presented on Identity vs Sequence. Mary as well was very comfortable with presenting and with her material. It was laid out very nicely giving the pros and cons of using each. I found her presentation to be very educational.
Norberto was the next contestant and he was from hot Brazil. He chose to present on the DB2Night Show instead of going to the beach, and we thank him for that! Norberto said that he learned English by becoming a DB2 DBA. We all know and love the database, but now we can give it credit for encouraging people to learn and become proficient in English. I really liked the humour that Norberto used in his slides, but Klaas cautioned him on using humour when the audience got really big and diverse. You don’t want to offend people! Norberto gave tips on improving SQL statements. His presentation led us through his journey of having very poorly written code to him debugging it and finally finding a way to improve the code so now it runs in 5 minutes versus the previous 10 HOURS! Way to go!!
The final contestant for today was Rob. Rob clearly reads self-help books, like I do, and chose to do a parody on a famous book by entitling his presentation “The 7 Habits of a Highly Effective DBA”. I thought the presentation showed much promise one of the first pieces of advice was to “not sweat the small stuff”. But Rob got too detailed in explaining the power of the db2diag.log and ran out of time. Rob could have used an entire hour to present his material and it would have been very well done. I hope that Rob is able to boil his material down to 4 minutes and that Scott allows him to redo his presentation… it has real promise. I suggested he write a book… but he could certainly turn this into a presentation that IDUG would be happy to have on it’s conference agenda.
All in all I was very happy meeting the contestants today and working with Scott, Martin and Klaas. In the end we invited 3 of the presenters back for a second presentation of the same material. This will allow them to fine tune their work and show us again. The three who are moving on are Mary, JB, and Norberto. Not to be sexist… but doesn’t that mean that the ladies rule????
If you weren’t able to take part in today’s show because of a conflict, I encourage you to get the replay. There are 3 more episodes like today’s and then the finale for 4 weeks in March. Hope you can join us! Oh, I think Scott is still looking for a few more contestants as well. Join in the fun.
Oh, if you do want to be a contestant, make sure you have headphones with a mic for your computer. Unfortunately there were two other people who we tried to hear from, but they weren’t set up correctly. I hope they are able to try again for one of the other weeks.
A reminder about the other shows in this series:
DB2 Night Show in February & March: DB2'S GOT TALENT CONTEST.
Join us on the following dates:
We’re looking for contestants…. are you up for it? Check the site for eligibility. Maybe this will convince you to become a contestant: the prizes!
Were you able to join today’s DB2 Night Show webinar? Today was the third show of this year’s competition. If you missed it, I strongly encourage you to watch the replay. Here’s what you’ll get:
Contestant 1 – Rodolpho
Tips for End of DB2 Log & Reset RBA Process
The problem Rodolpho discussed in his presentation was about the end of logs… which is like the end of the world! This shouldn’t happen as quickly as it is, but data is being added to databases at unprecedented rates, so it is happening. Rodolpho’s presentation was therefore timely. His slides very clearly laid out the problem and tips to solving the problem. Very well done.
Contestant 2 – Kingo
Hybrid Database Environment Introduction – DB2 plus Oracle LUW
This is a huge topic and Kingo’s presentation was meant to be only an introduction to it. As an introduction it was well done. There was a clear representation of the problem and how to solve it. The slides were clear and the graphics were good. We were able to see Kingo’s screen savers before and after his presentation. They were lovely! Also on his screen was a clock and thermometer. I’m not sure where Kingo was presenting from, but it was 1:30 am his time and the temperature was 0C.
Contestant 3 – Saravana
Predicting Production Access Path
Perhaps I shouldn’t mention Saravana. We weren’t able to hear her so clearly there were microphone problems. We saw the slides with the title and were looking forward to the presentation. Saravana, I hope you can fix your audio problems and come back in the future.
Contestant 4 – Fahim
Performance Tuning – Business Process Choreographer Database
I really liked Fahim’s graphics. They made the slides interesting to look at. I didn’t find the presentation very clear though. I wasn’t able to fully understand the problem that he was solving. The solution was a bit more clear, but still I was lost. Part of the problem was the acronyms that weren’t defined. Good attempt Fahim.
We were looking for contestants Lloyd, Carlos, and one other person, but we couldn’t find them. Most of the contestants today were from distance places, so maybe these people fell asleep or were confused by the time zone differences, but we’d like to hear from them if they can come to a future show. Scott mentioned that some people sign in with an alias so their name may not be recognized when we are looking for you. I hope this didn’t happen to the people we were looking for today. If this does happen to you, use the chat function to tell us what name to look for.
The judges, Martin Hubel, Klaas Brant, and myself chose Rodolphe and Kingo to move onto the next round based on the relevance of their topic and the quality of their presentations. Congratulations to you both. We’re looking forward to more quality presentations from each f you.
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. Note that this means there is a show on March 2, 16, and 30 only. If you get reminders for March 9 and 23, please ignore these reminders.
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://ibm.co/AnZxb4
PS… If you are in the NY area, make sure you look into attending the DB2
Symposium that is taking place March 28-30 in this area. See DB2 Symposium for details.
Winning a free trip to an IDUG conference of your choice is the first prize in this year’s “DB2’s Got Talent” Competition. The IDUG locations that you’d choose from are Denver, Berlin or Sydney. It would be pretty difficult to choose from such wonderful places, but that’d be a tough problem to have!
What do you have to do to win?
You will need to create short technical presentations about DB2 and present them to attendees on the DB2 Night Show’s webinar. If the judges choose you, you’ll get yet another chance to create a presentation. In the finals, your peers vote to select the ultimate winner.
Sound easy? If you know DB2 well, it should be easy. Beyond winning a trip to IDUG, you’ll be improving your technical and presentation skills, building a very strong network, and making a name for yourself as an expert.
Learn from past presenters. Those who take part in this year’s competition have it much easier than last year’s contestants. Those who participate this year can review all the great presentations (especially those from the top 5: Mary, JB, Thiru, Momi, and Norberto)that were delivered last year and can learn from them. Here are my blog entries with links to the replays:
Interested? I hope so! Here are all the nitty gritty details: DB2’s Got Talent.
This year there are also great runner up prizes:
Once again I’ve been asked to be a judge for this competition. I’m thrilled to be invited and am looking forward to meeting the many talented people who will take part in the show.
Good luck to all!
A whopping 730 votes were cast for our finalists before Friday’s show! As a result, we have our top 6 and bottom 3 contestants. The task for the judges is to save one of the bottom 3 and then to hand off the voting to you the listeners again. Let’s try to beat the number of votes from last week!
Two of our bottom three:
How I successfully, designed, implemented and monitored IBM InfoSphere Event Publisher.... My Experience.
Event Publisher is a Subset of Q Replication. Rene provided a good definition of this tool with very detailed slides. This is a big topic, but Renu covered it quite well, despite running out of time. The judges chose to save Renu... so she’ll be back next week!
Hash Access to DB2 Data: Faster, Better & Cheaper
Very informative presentation with good & detailed slides. He provided the benefits of using hash organization along with how to convert to this. This is another big topic. If you’re interested, check out the DB2Night Show presentation starring Phil Grainger who did a 1 hour presentation on this topic previously. (see replays)
Our topic six:
How DB2 10.1 Changed the Data Warehouse Terminology ETL to ETi
Mohan covered the Ingest feature of DB2 10. He covered this feature in detail along with a comparison study. He finished on time. Interesting topic. Well done.
Save me in, locks you out.
Finished early. Nice presentation. Simplicity. Well done.
Counting your Carbs: Watching for the little things that add up
Keeping watchings on tables and indexes that are growing.
Seems like this technique could be a huge time saver!
Great presentation... very good topic that many people struggle with.
Nice solution provided!
Mon_Get_Pkg_Cache_Stmt: Tips for Finding Problem SQL
These functions were introduced in 9.7 and are strategic.
Good guidance on setting the parameters for optimal use.
Related blog entry available.
Ember is a pro. Awesome job. More people should be using these monitoring tools!
Unfortunately our hosting service had technical difficulties, so there were many people who could not join today... including two of our top 6 contestants. Host Scott Hayes was able to get links to where you can preview their presentations:
When casting your votes, please give these finalists earnest consideration.
Time to VoteLive studio audience and replay viewers can access the show’s survey to vote and for a chance to win our $25 Amazon.com gift certificate drawing. The survey is embedded at the bottom of the replay blog. After you complete the survey, it will close automatically. Only one entry per computer is allowed. Also, to minimize the "I'll just vote for my friend effect", we are now requiring that you must vote for TWO or more finalists. You can still vote for your friend, but be sure to cast a vote for at least one other good presentation!
Coming Next:We have two more shows in the “DB2’s Got Talent Competiton”. March 15 and 22. Join us to learn, to support up-and-coming presenters, and to have some fun!
Scott’s summary of the show and to access the replay.
DB2 NightShow: Episode 5 of the DB2's Got Talent Competition
Judges present on the DB2Night Show "DB2's Got Talent" Competition
DB2 NightShow: Episode 3 of the DB2's Got Talent Competition
DB2 NightShow's 2013 DB2's Talent Competition
Promote yourself and DB2 with the help of my slides in SlideShare. Here’s where you can get them: Db2 night social_promoting_susan.