We’re coming to the end of a very popular season on the DB2 Night Show. This
is the third season and much has happened, but take a look at what host Scott
Hayes has in store for you to end the season:
15, the guest was Sanjay Kumar, author of new book IBM DB2 9.7 Advanced Application
Developer Cookbook. Sanjay gave many tips about using OLAP, Stored
Procedures, Optimization Profiles, PL/SQL, SQL and more with DB2 for LUW.
This is one of the books I gave away earlier this week at the Central Canada DB2 User’s Group
and the recipient was very pleased to get the book. Have you taken a look yet?
It might be exactly what you’re looking for.
Next Friday, June 22, 11ET, Paul Bird and Serge Boivin join
Scott to discuss the “Best Practices for Implementing DB2 Workload Management in a Data
Warehouse”. both Paul and Serge are long time employees of the Toronto Lab
and know this area extremely well. In fact, they have so much to share with the
audience, that this is a 90-min show.
OK… 90 minutes is a good sized webinar, but Pat Bates breaks the
record. He has so much to talk about that Scott has scheduled 4 back to back
shows for Pat!
Pat is from the IBM Technical Sales Team and will share his expertise in the
InfoSphere Warehouse and Netezza area:
Monday, June 25 at 11:00 am ET
“Temporal Queries and Analytics in an IBM InfoSphere Warehouse
Tuesday, June 26, 3:00 pm ET
Data Warehousing with InfoSphere Warehouse V10.1”
Wednesday, June 27, 11:00 am ET
Warehouse V10.1 Performance Enhancements”
Thursday, June 28, 11:00 am ET
Performance Analytical Data Warehouse using IBM Netezza Appliance 1000 - Best
Click on the links for the show title to register. Join all the shows to
build your expertise in this important area.
Thanks Scott for another great season. Looking forward to Season 4!
Lots of votes came in over the past two weeks. Our final four contestants, Ember, Mohan, Eric, & Chris
know how to use their networks! It was a very close call for 2nd, 3rd,
& 4th places. A new record was set for the number of votes
received: 1367 Thanks to all who voted!! I hope you enjoy the show
and will come back to replay many of the other informative shows in the
DB2Night Show collection.
Thanks to the sponsors for offering these excellent prizes!
Prize: One FREE IDUG Conference Registration to any IDUG Conference in
2013 (North America, Europe, or Australia) provided by IDUG, plus up to $1,500 USD travel expense allowance provided by DBI. Approximate value of prize package: $3,500 USD
2nd Prize: One FREE DB2 Symposium Registration (3 Days) to any Event in 2013 provided by KBCE, plus up to $1,000 USD travel expense allowance provided by HLS Technologies.
3rd Prize: Apple iPad (approximate value $500) provided by Responsive Systems.
Prizes: Each of the top 10 Contestants that are invited by the judges
to participate in Finals Shows will win $50 Amazon.com Gift Certificates
provided by Triton Consulting.
And the winners in order are:
Congratulations to each of you. Your contributions to the community are extraordinary
and I hope to see each of you participate in many upcoming events!
Conferences, webinars, books, blogs, articles... and any other way you
can share your knowledge & your talent!
I send the same message to all the contestants who took part in the competition this year as well as the previous two years.
See my blog entry Summary of DB2's Got Talent Competition 2013
that provides links to all the shows from this year’s competition as
well as how you can reach blogs & twitter accounts for those who
like to give special attention to Mohan, our winner. I mentioned on
today’s show that I recently found out that Mohan was the author of a
great book that was recently published. He sent me the information
about his book and many other ways he’s contributed:
Michael Tiefenbacher returns
as our special guest to share his terrific IDUG EMEA Germany
presentation on "Explain Reality!" If you want to learn about DB2 LUW
Explains, don't miss this show!
DB2 V10 Hint functions for Dynamic SQL
shows how to use SPUFI to explore the Hint setting facilities for
Dynamic SQL in DB2 V10. If you had ever wanted to use hints with dynamic
SQL, be sure to attend this show!
ATTACK of the BLOB!
Sr. DBA, makes his debut on The DB2Night Show by sharing his horror
story with DB2 BLOB performance and how he conquered the monster!
Database Performance Trends!
Forrester analyst Noel Yuhanna
will share with us his perspectives on database performance trends.
Join us to hear his views on performance management challenges, server
consolidations, cost optimization, databases in the cloud, and what he
calls "the newer workload". Take away analyst insight, tips, and
valuable, actionable advice.
Agile Big Data Analytics: Implementing a 22 billion row data warehouse
discusses the design, architecture, meta-data, performance and other
experiences building a big data and analytics DW system. If you need to
build a big data warehouse, be sure to attend this show!
Breaking News from IBM on DB2 LUW!
Special guest George Baklarz, IBM, will share with us the latest news on IBM DB2 for LUW.
14 JUN 201
Extreme Tuning SQL and Performance
Sheryl M. Larsen
covers multiple versions of DB2 and covers the following areas and you
will leave the presentation confident in identifying efficient queries
for DB2 10 & 11!
DB2 LUW 10 Index Jump Scans and Index Design Best Practices
Show host Scott Hayes
wears two hats and doubles as our show guest. Learn about DB2 LUW 10
Index Jump Scans and find out the Updated Rules for Index Design Best
Practices, including DB2 compression results.
DB2 LUW Customer Success Story
DB2's GOT TALENT 2012 1st Place winner "Kohli"
joins us to share his experiences with implementing and tuning a new
DB2 LUW application at his company. His advice is priceless!
Get all previous DB2Night Show episodes in replay: approaching 260,000 downloads.
Summary of DB2's Got Talent Competition 2013
DB2 NightShow - The Grand Finale 2013
Scott’s summary of Episode 7
DB2 NightShow: Episode 6 of the DB2's Got Talent Competition
Scott’s summary of Episode 6
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
This week’s show took place today… and I missed it! I thought I still had an extra day to promote it. So, if you’re like me and missed the show, you can listen to the replays. Here’s what happened in the past week:
Thursday April 21
The DB2Night Show #50: Put on the Boxing Gloves, DB2 LUW vs Oracle, Part 1
Julian Stuhler from Triton Consulting and Rick Sobiesiak of IBM Canada presented findings from their DB2 LUW versus Oracle Usability study. The study examines the major differences between DB2 9.7 and Oracle 11gR2, and assesses the complexity of each. Very impressive results, which I’ll let you discover by reading the study or watching the replay.
Round 1: Installation
Round 2: Data Compression
Round 3: Index Compression
Round 4: Backup & Recovery
If you want to see the complete study, down load the free Whitepaper: Quantitative Complexity Analysis.
Get the commentary and the replay. In the commentary, you’ll find links to several blog entries that were written in conjunction with this study.
Monday April 25
The DB2Night Show #Z01: The history of DB2 for z/OS
The launch of the DB2 for z/OS version of the DB2Night Show hosted by Klaas Brant. The first show featured special guest Roger Miller who spoke of the history of DB2. Klaas mentions in his wrap up of the show that there were many things mentioned that he wasn’t aware of even though he had been using DB2 since V1.2. Also, this show marks the last visit Roger will make on the DB2Night Show as he will retire in a few weeks. Roger, you’ll be missed!!
Get the commentary and the replay.
Thursday April 28
The DB2Night Show #51: Put on the Boxing Gloves, DB2 LUW vs Oracle, Part 2
Julian Stuhler and Rick Sobiesiak continued presented findings from their DB2 LUW versus Oracle Usability study. Make sure you make it known as to which of the tasks covered in either show you’d like to see demonstrated on a future DB2Night Show.
Round 5: Memory Tuning
Round 6: Data Access Control
Interesting comments & questions that came up during the show:
- Scott recommended that audience members also check out The DB2Night Show #14: Crunching the Numbers and DB2 STMM.
- Question from the audience whether IBM is making DB2 so easy to put DBAs out of business or to give DBAs a chance to improve their golf game.
- Question from the audience: why is Oracle so popular if DB2 is so great?
- Many questions on STMM.
There were so many questions today, but they will be answered in the Replay Blog.
Get the commentary and the replay.
Next week: IDUG.
And, the week after IDUG:
Monday May 9
The DB2Night Show z/OS Edition #02: DB2 for z/OS Now and into the Future
Jeff Josten will share the latest news with DB2 z/OS V10 and offer his insights into what may be coming next in DB2 z/OS: The Future of DB2
Friday May 13
The DB2Night Show Episode #52 - : DB2 for LUW Best Practices: Writing and Tuning Queries for Optimal Performance
John Hornibrook from the IBM Toronto Lab will spend 90 minutes to give his query optimization talk. John is also back for another show taking place on Friday May 20. Since that is so long from now, check out a previous show with John that was ranked one of the best of the first season: Episode 11. DB2 9.7 Optimizer Updates with special guest John Hornibrook from IBM.
As always, a great learning and entertainment opportunity via the DB2 Night Show. Thanks Scott! Good luck in Nashville on the marathon.
Over the years, DB2 has become more compatible to Oracle, thus making it much
easier for people skilled on Oracle to move to DB2 jobs as well as much easier
for companies to switch their Oracle databases and applications that rely on
With DB2 10 for Linux, UNIX, and Windows, you’ll find the
PL/SQL Compatibility features and other enhancements make it even easier for you
Learn about why and how to switch by joining this latest DB2 Tech Talk that
takes place on May 31:
DB2 Tech Talk: Oracle
Database and SQL/PL Compatibility
Date: Thursday, May 31, 2012
Time: 11:30 – 1:00 pm EDT
Speaker: Serge Rielau, SQL Architect for DB2 for LUW
This webcast will discuss:
- Native PL/SQL support, plus other compatibility features including
concurrency control, PL/SQL package support, Oracle SQL dialect support, OCI,
SQL * Plus Scripts, and Oracle Forms.
- Enhanced support for triggers, new scalar functions, declared types and
procedures within local scope.
- Tooling that IBM has made available to streamline this move process.
- Case studies drawn from elements of the process with actual customers and
shown at the code level.
If you are serious about switching to DB2 from Oracle, here are some other
resources for you to consider:
OK, I thought I had produced a pretty good list of free resources, but of course, as soon as I post, I realize that I’ve forgotten to mention some really key resources. Let me try again and hope that I don’t miss anything else! (Of course if I do… please tell me!!)
PlanetDB2.com – Allow us to filter through all the blogs that are on the web to bring you only the bloggers that talk about our favourite subject: DB2, InfoSphere, Warehouse, and other Information Management technologies.
ChannelDB2.com – The single largest community of people working on DB2 and Information Management products, world-wide. You’ll be able to build your network of professionals who work in your country or who are interested in the same technology as you. The best feature is the incredibly large selection of videos of people presenting about this products. Once in awhile, save your eyes and tune into these videos.
DB2Express-C – Maybe you’ve just heard of DB2 or maybe you use a competitor’s product. No worries… give DB2 a try for free. Find out for yourself how easy it is to learn and how much better it is than the product you may be using.
Information Center – Perhaps I’m biased since I worked for 6 years on the Information Development team that produces product documentation, but I really think you’ll find the completeness and the quality of this information to be outstanding. All of the information is online, for every release, for free, and is updated regularly. The benefit of the content being online is that you can search and easily find the information you need.
developerWorks – You’ll find more articles, blogs, tutorials and other training resources than you could possibly consume in a lifetime! The link I’ve provided is for the DB2 Professional Community, but you’ll be able to find technical information about all IBM software products. Endless :)
MeetDB2 – One of the interesting things you’ll find on developerWorks is this utility that will help you analyze your Oracle database to estimate the level of compatibility with DB2. My link will take you to an article written by Serge Rielau that will help you understand how the utility works, and it provides a link the utility.
Read through my previous blog entries for more free or almost free resources:
Not quite free….
DB2Night Show - DB2 for z/OS
Today was the fourth and final show of the first round of the DB2’s Got
Talent Competition. If you didn’t participate live, I strongly encourage you to
watch the replay. We had 7
contestants as well as an extra special presentation from judge Klaas
Brant. The caliber of the presentations today blew me away. We judges had
a very hard time selecting 3 to move on and were hoping we could save a few
more. But alas, 3 was our max. Here’s how it played out.
Contestant 1 – Brian
Brian used a physical health analogy for his presentation and it worked out
really well. Good thing I was on mute as I was laughing pretty hard at some of
the graphics. In reality, indexes can get very out of shape, but there are ways
to recognize this, monitor their health, speed them up, and ultimately make them
into top physical form. The judges found the presentation to be very
professional, interesting and easy to follow. If you’re into twitter, you can
follow Brian at fairchild_db2. Also, he blogs at http://bit.ly/yGpae2 . Check it out if you’re
Contestant 2 – Ember
Testing Your Recovery Strategy
As Ember said at the beginning of her presentation, this isn’t a very sexy
topic. But as Scott said at the end, the way she presented it made the topic
kind of sexy! OK, past the crazy talk, Ember chose to present the very
valuable topic of being prepared. If you don’t fully test your recovery
strategy, you may find yourself in hot water when you actually need to use it.
Her tips were very insightful. Her presentation was interesting, very well laid
out, and professional. One of the reasons Ember was so high on our list is
because she chose a topic that cannot be found in the manuals. She came up with
these tips from personal experience and a lot of hard work. Ember also tweets
ember_crooks & blogs http://db2commerce.com/.
Contestant 3 – Mark
DB2 LUW Workload Management – Using Role-based Workload Management to
Meet your Company’s Performance Goals
Mark chose a very tough topic and made it understandable. He started with
showing how to identify the roles all the way to adding the UserIDs to the
workload. One of the judges commented that this was a very adventurous topic
and it was so well liked because we don’t often have tips related to this
Contestant 4 – Rajib
Debug High CPU Situations with DB2
Rajib works in the support area, so this is a topic that he knows very well,
from experience with many customers. Rajib gave several decision trees to help
you make the correct choice when you discover your CPU spiking. Rajib mentioned
that he had more details in a follow on presentation that maybe we’ll hear one
day. The one thing that Rajib could have done better right from the beginning
is to put his presentation into Play mode. He had it in Edit mode so we could
see less of the presentation than we wanted to see. The decision trees would
have been much easier to read had it been in Play mode. Also, Rajib mentioned a
perl script that he uses but we didn’t see the details. Rajib will find a home
for his perl script so that we can all benefit.
Contestant 5 – Jean
DebReal 24x7 Enhancement: No downtime, no slowdowns, no planned
outages, no suspending traffic, simplifies & expedites blackout, any time –
day or night
Jean worked with her colleague Chuck to create this presentation, but she
presented on her own. I found it to be a rather complex topic but with her
examples, it helped make it understandable. Jean did a wonderful job of
presenting, even though she said she was nervous. Jean, it didn’t show!
Contestant 6 – Sameer
Sameer’s been here before and I can tell you that his presentations are
improving. Not a single typo this time around and the slides were well
organized with a problem, questions a person would ask about the problem and
ways to resolve the problems. Sameer’s slides said the presentation was based
on personal experience, but during a discussion with the judges, he admitted
that he made it up. It was a good choice for a topic as this isn’t discussed or
documented in many places. Sameer tweets https://twitter.com/#!/sameerkasi200x
and blogs: http://db2performance.blogspot.com/
Contestant 7 – Jonathan
DB2 LUW Load from Cursor
There are many load options and Jonathan wisely chose one to discuss so that
he could finish his presentation on time. Another good presentation that was
well laid out and easy to follow. The best slide was the last one where
Jonathan gave a summary of the Load / Import options and under which conditions
they should be used. One of the judges commented that many of his customers
were using this option.
Extra Special Presentation – Klaas
DB2 LUW Prefect IO Configuration
This was a real presentation and a good one, at that. Klaas gave this
primarily to show the contestants a well organized presentation, that is
interesting and informative. If you are moving on, or if you simply want to
improve your presentation skills, take a look at what Klaas did to get some
ideas. The first thing I noticed and mentioned on the show is how appealing
graphics are. I’m not sure if I would have said that before, but after today’s
amazing 8 presentations I can say that the ones that captured my attention to
the fullest were the ones that had graphics. And not complex graphics, rather
simple ones that are make a connection to the technical material being
discussed. Here’s a summary of the tips we gave over the past month:
- Get rid of all typos.
- Use simple graphics.
- Finish on time.
- Run in Presentation mode.
- NEVER ever try to present without slides.
- Choose an interesting topic that is not routine or found in the manuals.
- Speak loud and clear.
- Don’t send too much time on I am and thank you for being here.
- Even if the presentation is small, give a small agenda (I’m going to talk
about x and the solution for it).
- Define the environment where the “problem” occurs.
- Clearly explain the problem and why this is a problem.
- Explain the solution (watch your time…).
- Any “extra” advice.
- Where to obtain more info (references, email me, read my blog etc.).
That’s a lot for 4 minutes! Even Klaas went over time. Remember to
The judges, Martin Hubel, Klaas Brant, and myself chose
Ember, Brian and Jean to move
onto the next round based on the relevance / uniqueness of their topic and the
quality of their presentations. These three will join Richard,
Douglas, Yonghang, Rodolpho,
Kingo, Kholi, and Elder.
Congratulations to you all. We’re looking forward to more quality
presentations from each of you.
Do you agree with our choices? So far, the survey selections have matched
the judge’s selections. 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 advice on improving your presentation skills.
That’s it for the 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. There are only
3 shows in March: 2, 16, and 30. 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
See also: Session 1 of the DB2’s Got Talent
See also: Session 2 of the DB2’s Got Talent
See also: Session 3 of the
DB2’s Got Talent 2012 Competition
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
for details. Today a special discount was announced: If you book by March 1,
use the promo code DBI12A1 to get a 20% discount.
PSS…. If any other contestants tweet or blog, let me know and I’ll publicize
you as well!
DB2Night Show featured the top 10 contestants who were chosen by the
judges in February. They each had four minutes to impress the audience
and replay listeners. That’s correct. This time the judges are giving
feedback, but are not choosing the best competitor. I must say that
I’m very glad I’m not choosing the best. If you were in the audience
today or if you listen to the replay, you’ll see what I mean: All presenters were incredible Lots of learning happening today!
Here’s a summary:
The Fragmentation of DBADM
in DB2 9.7. DBADM is still a superuser of sorts, but there are
granularities. SECADM and DATAACCESS authorities were added. Great
presentation on the permissions for each user type. Great information
presented in an educational fashion. AND, she finished in time.
Simple Steps for Substantially Reducing report execution time in a Data Warehouse Environment.
Great graphics, very clear description of the problem and how to fix it.
How to Configure an Efficient HA and DR on DB2 10.1
like that the tradeoffs slide: puts the problem in perspective. Clear
description of the solution. Seems like this could be a common problem
that needs to be solved: good reasons to upgrade to V10!
Getting Siblings to Talk - Federating DB2 LUW and DB2 for i
Synchronized DB2 LUW on AIX to their legacy iseries system. Very good description on Federation and how it is set up.
My New Moving Vehicle DB2MOVE "With more POWER and Less Gas"
Lots of situations when you'd use DB2MOVE. Good description on what the command does, its options, actions and how to use them.
How do you work with Application Development to Ensure Performance
do you do when performance problems arises after new features are
added? Problem well defined and quantitative results shown.
SQL Performance Tuning using MQT Part 2
scenario created to define problem and how it was analyzed and solved
using MQT. And... he spelled cheque correctly! Way to go!
Temporal Data Management in DB2 for z/OS
definitions and contrast between snapshot and temporal. Lots of
details in the scenario that shows the problem and how it is solved.
The topic was too large to complete in time.
= Data Manipulation Scanner. Great presentation style. I like how
different approaches were discussed with pros & cons. Good use of
examples and sample code.
The 8 Selects that All DBAs Want to Have
Unfortunately Juliano did not show up today. So without Juliano, we had 9 great presentations today.
Who was the best? Listen to the replay and VOTE. Remember if you complete the survey at the end of the replay, you’ll have a chance to win an amazon.com gift certificate.
Thanks to all the presenters for your hard work on creating these great presentations.
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.
Another great show. Five more educational and entertaining presentations. What an excellent finale. You have two weeks to watch the replay and to vote for your favourite. Remember that the overall winner gets a free pass to an upcoming IDUG conference! The winner will be revealed on the next DB2Night Show, Friday, April 8.
Let me tell you about the presenters today:
Norberto – From DBA to DBA: Tips to Make your Life Easier
Another great presentation from Norberto, filled with amazing tips that will help any DBA. Luckily for us, Norberto has started to blog about his tips and experiences. I predict that you’ll want to follow his blog: Insights on DB2 LUW database admin, programming and more
Momi – Pressure Makes Diamonds
Momi’s presentation encourages DBAs to practice and prepare for possible problem areas that can cause a DBA to be under enormous pressure. Good advice in terms of preparing for a recovery after a disaster and more. Momi’s wise tips can also be found in a blog: B-Advised DB2 Blog
JB – CIO – Best Practices
Many of us, including me, thought that CIO was Chief Information Officer, but in the context of JB’s presentation it means Concurrent I/O. As usual JB covered the topic very thoroughly and very convincingly. I don’t think that JB has a blog, but don’t worry, I’m hoping to turn her into an author so she can share her talent of explaining complex topics with everyone.
Mary – How the DB2 Load Utility is Like Green Eggs & Ham
Mary is also an amazing presenter and is a pro at making topics very interesting with appropriate comparisons to popular interests. In this case, she encourages people to try something new, like was done in the Dr. Suess book “Green Eggs & Ham”. She encourages you to use named pipes to load data. Mary is a former Oracle user and has discovered the power of DB2 and has become a huge fan. I couldn’t find a blog for Mary… but she’d be good at it!
Thiru - Data
Thiru dug deep and found another command that is not very well known but is very useful. This time he taught us about using DB2cat. I also couldn’t find a blog for Thiru, but I do know that he attended the DB2 Symposium in Dallas earlier this week, so hopefully he’ll be active in local DB2 events in the future.
We judges, Martin Hubel, Klaas Brant, and myself had a very tough time deciding which of the bottom two presenters we were going to keep. There were many conversations going on between the judges. Then Scott did the poll and found that the audience was pretty split as well. In the end we chose Thiru. We really wanted to keep both, but needed to follow the rules. This ends Mary’s amazing run and anyone who saw her presentations over the past couple of months will agree with me that Mary will do very well at anything she chooses to do!
Once again 100% of the audience said that they learned something new that would be helpful in their job! What a big win/win experience this has been: audience is learning & contestants are fine tuning their presentation skills.
Please watch or re-watch the shows from the past 4-8 weeks and vote for one of the last remaining contestants to help us choose the overall winner. My sincere thanks to Scott Hayes for creating this entertaining and educational format for learning and training.
I like that my blog entries this week have all had the theme of certification. Maybe I could do week long themes for blog entries this year….
Anyway, after I posted my Cert 101 blog entry, I was informed by Scott Hayes, host of the DB2 Night Show that Roger Sanders is his guest on next Friday’s show.
An In-Depth Look at DB2 Certification
Insider Secrets and Tips for DB2 LUW and z/OS
with IBM Champion Roger Sanders
Friday, January 20 from 11:00 – 12:00 EST.
If you are interested in getting certified, and I think you should be if you are working with a product as complex as DB2, you should join this show. Roger has been involved in the DB2 certification program for years now. He takes part in the exam development as a subject matter expert. He and the other experts create the questions that appear on the exam.
Roger takes creating questions very seriously since once he’s finished creating questions for the actual exam, he makes up a whole set of sample questions that appear in his books. He gives you the answer to the questions in the book and explains why the correct answer is correct. I think this is a great way to learn the material, don’t you?
Roger also teaches this material in the form of a Crammer Course. Many DB2 conferences throughout the year my feature Roger and his Crammer Course.
See my previous certification entries:
How to Prepare to Pass a DB2 Certification Exam?
DB2 10 for z/OS Certification Roles, Exams and Study Materials
Certification Study Guides for DB2 LUW Exams
DB2 9.7 for Linux, UNIX and Windows: Certification Roles and Exams
PS… If you like this post, consider following my blog. Thanks for reading!
On today’s DB2Night Show, we had the second set of competitors who are competing in the DB2 has Talent Competition. This week we had 6 amazing competitors who made it difficult for we judges (Martin Hubel, Klaas Brant, and I) to choose who would move on to the finals.
Before I tell you who was chosen to move on as a result of this episode, let me tell you a bit about all the competitors.
Vijay’s presentation was titled “Keeping Critical OLTP Databases Up and Running”. Vijay’s primary tip was to gather data when your database is running well and at peak. Having this data available will help you decipher problems when the database is running slower than it should. I’m reading the book “Switch” right now and one of the things the authors recommend that people do in their every day life is to look at the bright spots… that is, analyze a situation that goes well and find out why so that you can repeat it. It seems to me that Vijay’s presentation was suggesting that people do just that. Well done.
Mustafa presented “Consolidating Three Databases into One”. Mustafa ran out of time… but only by a few minutes. It seemed that the last couple of slides were critical to the presentation, but as it was, it was difficult to follow. Klaas gave Mustafa some advice to improve and I think that the presentation would be much better once Mustafa takes Klaas’ advice.
Ahmad was next with the presentation “OLTP Queries Timing Out”. Ahmad gave a very creative solution for searching for character strings in a table. He showed how he brought the search costs down significantly in his query. After Ahmad presented, both Klaas and Martin mentioned that they have many customers who were looking for solutions to this common problem.
Sameer presented “Optimizing Application Performance and Performance Monitoring”. This presentation was filled with incredible tips. Many incredible tips. The only thing I wanted to see in addition to what Sameer provided was examples and what if scenarios as to why these tips should be used and why they are better. Sameer says that he had a much bigger slide deck with that kind of content, but cut it out to fit in the 4 minutes he was allotted.
Greg’s presentation “Want to Improve Your DB2 Availability” was A++ on the definitions of HADR and HACMP, but there weren’t enough examples and pictures, so people with short attention spans, such as me, had trouble following. With a bit more effort, Greg’s presentation would have taken him to the finals.
Raja was last today. Presentation: “A Miss is as good as a Mile”. Did I get the title right? It doesn’t seem to make sense to me right now. Raja very nicely laid out problems related to performance and came up with solutions and clear details on how to get from problem to solution.
So, who did we choose? We decided that we liked Raja’s and Ahmad’s presentations best of all and asked the two of them to come back in March. We also decided to invite Sameer back next week to give us his presentation again next Friday after he takes the advice that he was given in this week’s show.
Did you miss this episode or last weeks? No worries! These are recorded and you can watch the replay. You’ll be glad that you did. One of the polling questions that we had today asked the audience if they learned something in today’s show that they didn’t yet know. 93% of the audience responded saying that they did in fact learn something valuable in the show. Even if you are an experienced DBA, I would say that you could learn something from these shows. The creativity of the people on the front line are amazingly creative!
Check out the blog entries of my fellow judge:
(I’m still waiting for new posts from Klaas Brant and our host Scott Hayes).
See you next week on the show for Episode #3!
On Monday’s DB2Night Show, join host Klaas Brant and special guest Susan Lawson as they talk about DB2 10 Table Spaces new options and migration considerations. This will take place live from the SQL Adria Conference in Dubrovnik Croatia. Susan will cover considerations for migrating to universal table spaces and the options and issues with the deferred ALTER capability in DB2 10. It will also cover considerations for decisions to use various options now available for our table spaces.
Date: Monday June 13
Time: 11:00 ET
Participants in our virtual studio audience will have the opportunity to ask questions.
Susan and Klaas are both IBM Gold Consultants. Susan is once again an Information Champion.
Susan Lawson and Dan Luksetich are beginning to update their Certification Guide and hope to have the new version of the book to match the new exam by July 2011. Note you can get the V9 book: DB2 9 Database Administration Certification Study Guide for Exam 732 at a 40% discount.
Also check out Susan & Dan’s podcasts, blog and more: YL&A Podcasts
Monday April 25 is the Kickoff
for DB2 for z/OS
shows on the DB2Night Show. As a reader of my blog, by now you know the DB2Night Show and Scott Hayes
very well. Just to be sure, here’s what you need to know about the DB2Night Show:
Scott Hayes of DBI started a series of free webinars in September 2009 with the goals to: Educate, Entertain, and Inform. There have been 48 shows already and 98% of the attendees said that they learned something new from the show. I’ve personally been involved in the past few months as part of the “DB2’s Got Talent” competition and I must say that I was blown away with the quality, variety, and depth of the education provided.
Each episode has a DB2 educational theme and speakers have been IBM experts, top consultants, IBM DB2 Gold Consultants, IBM Information Management Champions, and experienced users.
Klaas Brant of KBCE and organizer of DB2 Symposium Education has decided to turn Mondays into a must attend learning session for people who work with DB2 for z/OS. There are already 5 amazing shows on the schedule with more to come.
Remember, the DB2Night Show is completely free for participants, but there is a limit to how many attendees can attend. Make sure you register immediately so you don’t miss out. Replays will be available following each show.
Here is the current schedule:
The History of DB2
Monday April 25, 2011, 11EDT
The kickoff of the DB2Night Show z/OS Edition features legendary Roger Miller. This event shows much of the history of DB2 with milestones of new versions, new inventions, and showcases some of the people who contributed key inventions and innovations in DB2.
The Future of DB2
Monday May 9, 2011, 11 EDT
Edition #1 was a look at the history of DB2, so it is fitting to have the second show centered around the future of DB2 z/OS. Special guest Jeff Josten will share the latest new with DB2 V10 and will offer his insights into what may be coming in future releases.
DB2 10 Performance
Monday May 16, 2011, 11 EDT
This episode will look at performance in DB2 10. Special guest Cristian Molaro was recently a co-author on a new IBM Redbook about DB2 performance that will publish soon. Cristian will share his hands-on experience with DB2 10 performance during the show.
DB2 10 SQL Enhancements
Monday, May 23, 2011, 11EDT
DB2 10 is packed with new SQL features like temporal data and many others. Join special guest Terry Purcell as he walks us through these great new features and explains how to get the best from them.
DB2 10 Customer Experiences
Monday, June 6, 2011, 11EDT
Many customers are already using DB2 10 in production. Special guest John Campbell will talk about migration planning and share lessons learned from people who have already migrated.
Are you looking for more quality educational ideas? See my previous blog entries:
- FREE – Flashbook “DB2 10 for z/OS - Cost Savings ..... Out of the Box“ available; find out how to get yours: http://bit.ly/fjR4x2
- FREE - Ten new IBM Redbooks that you may be interested in: http://ibm.co/hZDwXV
- FREE - Learn from experts via Best Practice articles for DB2 for z/OS: http://ibm.co/eTXbRd
- FREE – 3 certification exams for attendees of IDUG Tech Conference: http://ibm.co/giLoQA
- IDUG Tech Conference: http://ibm.co/gqaA35
- DB2 for z/OS Events & Resources: http://bit.ly/hZDPbf
Learning is a life-long journey, so take advantage of the outstanding resources that are available for you.
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:
First Episode of “DB2 has Talent”
Second Episode of DB2 has Talent
had 4 great presentations again this week! I’d really like to thank
all participants... I know it isn’t always easy to present, but it is
very important for us to share our knowledge with others!
Mikko - Summary Table Design & Monitoring
A little trouble following the story of the problem & solution. Summary tables are a huge topic. Well presented.
Umesha - Detailed steps to configure DB2 Distributed Data Facility (DDF) for z/OS
Good slides. Not practised? Went over time. Missing the “why”. Only “how” was covered in presentation.
Sreeharsha - High Data Availability: solutions and techniques
clearly defined. Problem clearly defined. Presentation was well put
togetehr and rehearsed. This is the way it’s done!
Armando - Dare to be Different (Against all Dogmas) SQL Performance Tuning
Be open minded on how to solve problems. You may find a creative solution that wasn't’ expected
Entertaining and engaging presentation with a great amount of style.
Congratulations to Sreeharsha, Armando, and Mikko for moving to the next level.
sure to join us next week to hear presentations from me, Martin, Klaas,
and Martin. Your turn to evaluate us! Just for fun, of course. Come
and have some fun!
Over 219,000 downloads of past DB2Night Show episodes! Congratulations Scott!!
If you missed the show, see the replay!
sure to fill out the survey when you do... you may be the lucky winner
of a $25 certificate to use at Amazon.com. Perhaps there is a DB2 book
you’d like to purchase?
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:
Feb 11, 2011 11:00 AM - 12:30 AM EST
Feb 18, 2011 11:00 AM - 12:30 AM EST
Feb 25, 2011 11:00 AM - 12:30 AM EST
Mar 4, 2011 11:00 AM - 12:30 AM EST
Mar 11, 2011 11:00 AM - 12:30 AM EST
Mar 18, 2011 11:00 AM - 12:30 AM EDT
Mar 25, 2011 11:00 AM - 12:30 AM EDT
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!
- 1st Prize: One FREE IDUG Conference Registration to any IDUG Conference in 2011 (North America, Europe, or Australia) provided by IDUG, plus up to $1,500 USD travel expense allowance provided by DBI. Approximate value of prize package: $3,500 USD
- 2nd Prize: Xbox 360 250GB Console with Kinect (approximate value $500) provided by IDUG.
- 3rd Prize: $100 Amazon.com Gift Certificate provided by DBI.
- Finalist Prizes: Each of the top 10 Contestants that are invited by the judges to participate in Finals Shows will win $50 Amazon.com Gift Certificates provided by DBI.