Fourth Episode of "DB2 has Talent"
svisser1 2700018UK9 Visits (2906)
Today marked the 4th episode of the popular “DB2 has Talent” series of webcasts featured on the DB2Night Show. This was the first of the episodes that featured presentations for DB2 for z/OS. MISSED IT? No worries. Replays HERE.Let me tell you about the contestants we met today:
Mobi -“DB2 Online REORG”
Mobi stepped us through the reason to use REORG, the process for using it and problems that can be experienced. His conclusion gave tips on how to resolve and fix common problems with using this utility. If you’re interested, Mobi gave links to his blog entries about the topic.
David– High Performance Application Reusability Techniques
David is clearly very experienced in using DB2 and has been working with it for 26-27 years. His talk discussed encapsulating stored procedures into COBOL programs. The main issue with David’s “talk” is that there were no slides. There are some talks that can be done audio only, but I don’t think this one was. I listen to audible books in my car and am about to work on a series of podcasts…so I like audio only, but not all topics will work.
Vivekanadan – DB2 Administration Server for z/OS (DAS)
Vivek gave very complete information on this subject, but there wasn’t much in the way of personal experience from what I saw. I was having a case of Deja Vu when I was looking at the slides. I wrote the book “Teach Yourself DB2 in 21 Days” for DB2 LUW V8. I remember researching and documenting the DAS and am pleased that I still remember and that the DAS works the same on all platforms. My colleagues tell me that DAS is no longer in DB2 V10, so many people will no longer need this information.
Haris – DPF Communication between Sharing on DB2 z/OS Data Sharing Group
Haris stepped us through all the steps of setting up the parameters and other items that needed to be customized to use DPF Communication. The presentation seemed a bit too much like documentation rather than tips from experience. Martin suggested that the presentation would have been more valuable if it gave information on using DPF without RACF.
Shashank – Save Time, Cut Costs and Work Smarter: Monitor Mission Critical DB2 LUW Processes
This was the first presentation today that covered LUW. Shashank did very well by giving us the impact to the business if there are problems and then suggested using db2pd to discover the cause of the problems. I got lost during Shashank’s presentation as I didn’t see a clear link from the problem stage to the solution stage. It more seemed like a guide as to what db2pd is, without showing an example of db2pd being used to solve an actual problem. Shashank ran out of time, and Scott mentioned that there will be an entire show about this utility later this fall.
Bob (Robert) – SQL Tuning Tricks – Perils of Using “not in”
If you read my blog last week, you’ll remember that Bob had tried to present, but ran into technical difficulties. I’m happy that Bob was able to overcome these issues to present to us today. Bob did something that I’ve never seen before. He interactively underlined text in his slides to emphasize the point he was trying to make. I’m going to see if I can figure out how to do this! As to his actual content… it was very good. He showed SQL statements that used the very inefficient “not in” clause and how to change it to “except” clauses. My only suggestion to Bob is that he make his conclusion crystal clear… which was his first statement took 20 minutes to execute, but the revised one… only 5 seconds. If you hear this conclusion, it is very clear that this simple change is very worth the effort!
If you attended, you can fill in our survey.
If you missed this show or the previous three, 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:
Momi and Bob
First & last of the day :) 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:
Next week we begin the finals. The format will continue to be 4 minute presentations by the contestants, but only contestants who we have moved to the second round will present. That means we’ll hear from:
Mary, JB, and Norberto – 1st Episode
Raja and Ahmad – 2nd Episode
John, Sameer, and Thiru - 3rd Episode
Momi and Bob – 4th Episode
Congratulations to all TEN finalists. I am looking forward to hearing you present again. I’ll be away on March 4 (on vacation), so Christian is sitting in for me. I’ll make sure to listen to the replay as soon as I return.
Voting will be done by other attendees… so if you are one of the finalists, you may wish to invite everyone you know to join the show to vote for you!
Good luck all!