DB2’s Got Talent 2014 – Search Show #3

The entertainment and education of DB2’s Got Talent on the DB2Night Show continues. I recommend watching the download here: http://www.dbisoftware.com/blog/db2nightshow.php?id=4869 Also on that page is an extra discount code for the IDUG North American Technical conference in Phoenix in May – it’s even better than the early enrollment discount, so if you are going, check it out.


Umesh – Accelerating DB2 Performance (z/OS)

This presentation related to z/OS and SAP. Umesh read through his agenda, and it was a very generic agenda. When you only have 4 minutes, if you have an agenda slide, you don’t want to spend much time on it unless you’re doing something wild. Umesh’s problem statement was good, though a bit wordy. One of his graphics was a bit smooshed (explain plan). Then the judges got a bit confused because it appears that the only solution he presented was running runstats and clearing the statement cache (Which I assume is like DB2 LUW’s package cache). My question in this situation was mainly – how bad were the runstats for that to be the solution – and why weren’t regular runstats being collected? Maybe runstats just aren’t done as frequently on z/OS? While Umesh had decent graphics, I think he was lacking some details. He could have gone into things like how he automated runstats to keep the problem from happening again or other additional things.

The judges did not allow Umesh to move to the next round or to present again on February 28.

Shreeharsha – An Accitential Drop to an epic recovery (z/OS)

The first thing that jumped out to me about Sreeharsha is that he did not include his name on the title slide. Perhaps that only matters to someone like me who is taking notes and wants the proper spelling immediately – a minor flaw, really. Again we saw an agenda slide, which he largely read. I suppose that’s good presentation 101, but it’s hard to have time for it in 4 minutues. A few of his slide transitions were slow. I can’t really speak to the technical content, as I’ve never touched z/OS. I did feel he had a lot of slides for 10 minutes. His audio was clear, and he made excellent use of humor in the presentation

The judges selected Sreeharsha to move on to the next round.

Sreeharsha’s contact information:
Blog: http://www.db2champ.com
LinkedIn: http://www.linkedin.com/in/sreeharshanaik

Ken Shaffer – admin_move_table – the good, the bad, and the ugly

I know Ken from hanging out with him a bit at IDUG conferences. His presentation was the third one we’ve seen on ADMIN_MOVE_TABLE in the competition so far. While he focused on the older 9.7 version, he provided some good detail (and also noted the 10.1 fixpack 2 enhancements). I especially liked his graphic showing the staging table that ADMIN_MOVE_TABLE uses. He did a great job of including needed details on his slides without actually reading through them – finding exactly the right balance – which is a tough skill to master. I liked his thought of “rolling his own” ADMIN_MOVE_TABLE, and would love to see more technical details on how he accomplished that.

The judges selected Ken to move on to the next round

Ken tweets at @aerodata


Again, check out the replay at http://www.dbisoftware.com/blog/db2nightshow.php?id=486. Just one more search show to go before we get into the finalist rounds!

If any of the contestants wish for me to change the contact information shared here, let me know in the comments below. I try to pick the best forms of public communication without sharing too much, and I try to read what I can from their slides.

Ember Crooks
Ember Crooks

Ember is always curious and thrives on change. She has built internationally recognized expertise in IBM Db2, spent a year working with high-volume MySQL, and is now learning Snowflake. Ember shares both posts about her core skill sets and her journey learning Snowflake.

Ember lives in Denver and work from home

Articles: 556


  1. Hi Ember
    I downloaded the 3 GOT TALENT replays using Google Chrome and IE and they all fail to play in WMP with error message: “Windows Media Player cannot play the file because the required video codec is not installed on your computer”. I even downloaded a 4th video also today and it played fine.. so something’s weird with these last videos. Would appreciate if you can let DBI know about this funny situation.
    Thanks and great job!!

  2. Greetings to fans of The DB2Night Show,

    Regarding WMV replays, this is complicated. When you attend a live show (webinar), Citrix GoToMeeting/GoToWebinar (hereafter “G2W”) installs their secret decoder ring CODEC. When a show is recorded, it is initially recorded in the G2W CODEC (a compressed format). After a show ends, G2W is supposed to automatically convert the G2W CODEC WMV to a “Normal” Windows WMV CODEC. For the last 3 shows, the automatic (and manual) conversions have failed. We have a support issue open with Citrix. Surprisingly, our conversion of the G2W CODEC WMV to MP4 has been successful on the last 3 shows, thus we’ve suggested watching the MP4 if the WMV fails. The WMV should only fail for you if you’ve never attended a live Citrix G2W event. If you’ve attended a show in our live audience, the WMV should work. If you hate MP4 files or don’t have a player and you really want to watch the WMV file, Citrix makes it easy to install their CODEC by visiting https://support.citrixonline.com/en_US/GoToMeeting/all_files/GTM080011. Of course, this is a classic example of addressing a symptom and not a root cause problem. Since we started our shows in 2009, G2W CODEC transcoding is been a pain in our (you know where). We’re working on it. Meanwhile, watch the MP4 or install the G2M CODEC for the WMV. With love and adoration for our DB2 community, Scott

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.