, best-selling author of Outliers, Blink and The Tipping Point will be the keynote speaker at this year's IBM Information on Demand 2009 conference that is taking place at the end of October in Las Vegas.
Malcolm has also agreed to do a book signing, so this is a chance for you to meet him and to get your books signed. If you already own one or more of his books... bring them along and get them signed. If you don't yet own them, they will be for sale at the conference bookstore. His books are very insightful and interesting to read, so you won't be disappointed in any of the titles. They also make great gifts.
From the conference website:
Malcolm Gladwell has an incomparable gift for interpreting new ideas
in the social sciences and making them understandable, practical and
valuable to business and general audiences alike. He’s become so
successful at this that, in 2005, Time Magazine named Malcolm one of its 100 Most Influential People.
Malcolm's most recent book promises to have an even greater impact
on both business and society than his first two books. With his first
book Malcolm embedded the concept of The Tipping Point in our everyday
vocabulary and gave organizations new tools for understanding how
trends work. In Blink he analyzed first impressions—the snap judgments
that we all make unconsciously and instinctively—and he explores how we
can master this important aspect of successful decision-making. Now in
his stunning new book Outliers, the bestselling author reveals the
real—and mostly overlooked—secrets to extraordinary success. He reveals
that we pay far too much attention to what successful people are like,
and too little attention to where successful people are from: their
culture, their family, and their generation. Gladwell explains what
Bill Gates, the Beatles and other world-class successes have in common,
how culture affects their careers and performance. Along the way,
Gladwell overturns many of our conventional notions about what makes a
person successful. He creates an entirely new model for nurturing
success and suggests ways to give people the best opportunities to
succeed. Because we so profoundly personalize success, we squander
human potential. We miss opportunities to lift others onto the top
rung. Malcolm is a staff writer for the New Yorker magazine. His editor
describes his work as a new genre of story, an idea-driven narrative
that’s focused on the everyday and combines research with material
that’s more personal, social and historical. He was previously a
reporter for the Washington Post.
Have you registered for the IOD conference yet? Register BEFORE July 31 to get the early -bird discount:.
My lucky role at the conference is to arrange for the book signings, so I'm very much looking forward to meeting Malcolm in person! I hope you are too!
Today was the second show of the finals for the DB2’s Got Talent 2012
Competition. I wasn’t able to participate, so IBM Champion, Cristian
Molaro filled in for me. Like many of you, I’m listening to the replay a
few days after the live show.
If you didn’t participate live, I strongly encourage you to watch the replay. We had the
top 10 contestants from Round 1 present 4-minute technical presentations to us.
Once again, we ended up with very high quality presentations from very
experienced users of DB2 products.
The control is now in the hands of you, the audience. You
must vote for who you think should go on in the upcoming shows. Here’s what you
need to do. If you were in the audience, vote in the survey provided for who
you thought was the best. If you weren’t able to make it to the show today,
watch the replay, and then VOTE. The top 6 contestants based on your votes will
present again on March 30 and the judges will save one contestant from the
bottom 4 (again based on your votes). Don’t watch just to vote, watch to learn
great DB2 tips as well as examples of excellent presentation skills. Here’s a
summary of what happened:
Contestant 1 – Yonghang
DB2COS and Related Commands
Yonghang had a slide for “what is db2cos”, but I wasn’t able to figure out
from his presentation as to what this command is and what it is used for. Most
of his presentation centered around customizing the command to use it most
efficiently. Yonghang was nervous during his presentation, but the judges found
that the command was a little known command and the presentation was useful.
Contestant 2 – Rodolfo
Discovering DETAIL Option in DISPLAY Command
Rodolfo chose to present about the DB2 for z/OS command and its options. The
DETAIL option is only available on DB2 V10. This was a good topic with good
slides with pointers to additional information. Clear and to the point.
Examples were easy to follow. Cristian mentioned that there is also a Redpaper
about this topic. You can follow Rodolfo on twitter: https://twitter.com/#!/_rodc
Contestant 3 – Kingo
DB2 for z/OS Access Path Verification by REBIND command
Kingo, being from Japan, missed that North America is now on daylight savings
time. We’ll have to be sure to warn international contestants when times change
in the future. Very good presentation about how you can clone your system and
find the differences.
Contestant 4 – Richard
Unfortunately Richard has needed to leave the competition due to
Contestant 5 – Kohli
Command was clearly defined regarding its purpose and when to use it. I
liked that he showed how he uses the command and why. Very good presentation
with a summary and good examples. The format of the presentation was perfect
for this type of venue. Succinct and clear. Great job!
Contestant 6 – Elder
DB2top Collector, Auto-Performance Analysis, and Replay
Very clear definition of the command and why you’d want to use it. He
contained his presentation by discussing only 3 options that are available for
this command. He got caught up a bit in the introduction and ran out of time
for some of his examples, but otherwise it was a very good presentation.
Contestant 7 – Brian
Top 10 db2pd
Intro was excellent and humorous! The history of the command was also
interesting. Brian presented on the top ten options that he uses on a regular
basis. Interesting and dynamic slides with animation. Clearly presented with
the command, option, along with an example. Brian clearly has much experience
using this command and its options. Brian tweets at https://twitter.com/#!/fairchild_db2
and blogs at http://bit.ly/yGpae2 .
Contestant 8 – Ember
DB2caem: The Untold Story
Ember gave a clear introduction to the command and its benefits and then
wondered aloud what this command is doing to her databases. Her presentation
focused on this. She does a fine job investigating the command to find out how
it does what it does. She gives very clear conclusions regarding the
consequences of using the command, and give all sides of the story. As usual,
Ember did a very fine job with her slides, presentation, and was enthusiastic
and professional throughout. This is a relatively new command, so the topic was
very valuable to all. Ember tweets ember_crooks & blogs http://db2commerce.com/.
Contestant 9 – Jean
Dynamically Generating Scripts and Control Cards
Jean worked with her colleague Chuck to create this presentation, but she
presented on her own. Again this was a cross-platform topic. Clearly Jean and
Chuck have much experience using this command and its options. They clearly
defined the command and when it is used and how it helps. A lot of information
was given, very clearly, in only 4 minutes. Conclusion: If you are a DBA and
know your SQL, you can perform miracles. Some of the SQL showed new features
of the product.
Contestant 10 – Douglas
DB2 LUW 9.7 CLPplus Command Line Processor
The preamble to Doug’s presentation was very interesting. We know from
Doug’s previous appearances on this show that he is a DB2 & Oracle expert.
Doug’s screen saver is a photo of a motorcycle he received as a birthday gift
upon the return from an Oracle conference. He then gave us a couple of
interesting comments about the conference. I’ll let you listen to the replay to
hear what those comments are! The presentation focused on why you’d want to use
CLPplus versus CLP. Great slides, clearly presented topic, but he ran out of
The judges, Martin Hubel, Klaas Brant, and Cristian were
asked to save one of the bottom 3 presenters based on the voting from the past
two weeks. It was a tough decision, but the judges decided to save
While the judges were deliberating, Scott showed us some of the amazing
feedback people have been providing about the contestants, the show and of
course the learning opportunities. Keep giving feedback, we find it very
96% of the listening audience said they learned something new today. How
about you, listening to the replay? Did you learn something new?
Now the control is with you the listeners. After you watch the
replay, VOTE! I’m glad I don’t get to choose… there is such great
talent appearing on this show that it will be very difficult to choose.
March has one more show for the finals where those who have moved on will
present for the final time and the audience can choose the winner. Be sure to
join us March 30. If you get reminders for March 23, please ignore this
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 2012 Competition
See also: Session 2 of the
DB2’s Got Talent 2012 Competition
See also: Session 3 of the
DB2’s Got Talent 2012 Competition
See also: Session 4 of the
DB2’s Got Talent 2012 Competition
See also: DB2’s Got Talent
Finals – Round 1
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
Last May a bunch of us were in Rome for the IBM IOD EMEA conference. This year there is a smaller conference that is more technical in content and is being held in France this July:
6 - 8 July 2011
Register now and learn how to reduce costs, manage risk, optimize customer insight, and increase operational efficiency. Learn the latest about information management, Enterprise Content Management , Business Analytics, Smart Analytics Systems, and network with your peers. Learn how to turn your Information, Content, Analytics into a strategic driver of innovation and business optimization.
Featured are all the new major versions of IBM products announced in 2010 & 2011, such as
- DB2 10 for z
- Informix 11.7
- Cognos 10
- InfoSphere Information Server 8.5
- FileNet P8 5.0
- IBM Case Manager 5.0
- Change Data Capture 6.5
- ... and more
What you can expect:
- Thought-provoking general sessions from leading industry commentators and IBM executives Technical & Business Leadership
- Compelling speakers, including business and technical luminaries, analysts and customers. See the Agenda for a complete list of the sessions and the confirmed speakers.
- Ability to meet one-to-one with IBM executives
- Opportunity to meet the experts, providing solution, industry and technical insight
- Expo Solution Center showcasing information management solutions
- World-class technical training, free certification testing and education Extensive networking opportunities
- Hands-on Labs and Usability Labs
This is the event for gaining unique insight into the value that information Management, Content, Business Analytics technologies are
delivering today. To cover your specific needs, this Technical Conference offers two tracks – Business Leadership and Technical.
Move between tracks and create a personalized agenda to ensure you get the most value from your Conference attendance.
The Business Leadership Track
- The Business Leadership Track includes industry sessions, line-of-business managers looking to become more competitive, reduce
costs, enhance customer satisfaction, manage risk and deliver value.
The Technical Track
- The Technical Track focuses on the implementation of Information Management, Content, Business Analytics solutions, the latest
technical developments, plus the most recent innovations from entire portfolio. Together with certification and education, there are technical
demos and opportunity to meet with product and software development experts.
- The Conference fee is 1450 € exclusive of local VAT. This fee provides access to all keynote and elective sessions, workshops, panel
discussions, conference proceedings, meals, refreshments and conference events mentioned in the conference agenda.
For more information and enrollment: ibm.com/training/conf/europe/IMSSTC
Some additional incentives to attend:
25% Discounts on Public Training*
- Take your skills to the next level. Attend a Business Analytics, Enterprise Content Management or Information Management public class and save 25% off the tuition. This offer is valid for the IMSSTC EMEA attendees from July, 15, 2011 until March 30, 2012.
- * This offer is only for European public scheduled courses and can not be used in combination with other discounts. Please contact Education representative for complete details
Free Web-based training
- Receive your card to have web-based training for free, offered to the EMEA attendees of the
Free Certification Testing at IMSSTC**
- Validate your skills with an IBM Professional Certification. Attendees can take some of the available tests at no charge.
- ** Visit the Conference website to know more about the available tests and conditions.
Free Education Planning
- Success begins with having a plan. Building a custom Training plan helps to ensure that you and your team have the skills to maximize the value of your IBM software. Meet with one of our training experts to build a training plan that includes role-specific training and certification recommendations as well as cost saving strategies to get the most out of your training budget.
PS… I haven’t been to France yet, but plan to go this summer. Wish I were going to this conference, but I’m not. For those of you who do go, have a fun “geeky” vacation.
Join Sal Vella and Matt Huras from the Toronto Lab to learn how to leverage the latest DB2 for LUW features such as DB2 pureScale and Storage Optimization. Sal and Matt will be broadcast in high definition directly to select IBM Technical Exploration Centers across North America.
12:30pm – 1:00pm Welcome
1:00pm – 2:00pm Break Free with DB2,
2:00pm – 3:00pm DB2 pureScale
3:00pm – 3:30pm Refreshment Break
3:30pm – 4:30pm DB2 Storage Optimization
Where you can attend:
San Francisco, CA;
Costa Mesa, CA
This event is the first that I've heard of that is using the IBM Technology Exploration Centers which are high-quality facilities across North America that allow our customers to explore IBM software technology and collaborate with our subject matter experts.
ABOUT THIS EVENT:
Attend this seminar to learn how to leverage the latest DB2 for LUW features such as DB2 pureScale and Storage Optimization. DB2 pureScale provides unlimited capacity, continuous availability and application transparency. It delivers levels of database scalabililty and availability previously unmatched on distributed systems. The DB2 Storage Optimization Feature gives you the ability to transparently compress data on disk in order to decrease disk space and storage infrastructure requirements.
WHO SHOULD ATTEND:
This event has 3 hours of content, and has been organized to be of interest to database administrators, data architects, and anyone who has an interest in running OLTP systems without having to worry about changing their application code when adding system capacity. Interested in Active-Active? Come and learn more.
Sal Vella is the Vice President, Development, Distributed Data Servers and Data Warehousing based in the IBM Canada Laboratory in Toronto, Canada. In this role, he is responsible for the world-wide development of DB2 for Linux, UNIX and Windows and for solidDB.
Matt Huras, Distinguished Engineer, is the lead architect of the DB2 pureScale feature. Matt has had extensive experience with DB2 for LUW storage engine, including indexing, data management, buffering, memory management, threading and scheduling, utilities and high availability.
Thanks to event organizer Lily Ryzebol for this information.
get asked this question all the time. What are we doing to prepare the
next generation in terms of up and coming technology. You’ll be happy
to know that plenty is going on. Even at IOD. Key
faculty who are collaborating with IBM on advanced Big Data and
Analytics curriculum and programs are gathering for a two day special
Big Data and Analytics Academic track at IOD. They will attend several
sessions together to share their current programs as well as brainstorm
about their next steps and their challenges. They will learn about IBM
academic programs and hear from IBM experts in two panels. All of this
will strengthen the community amongst these leading academic
institutions. The Big Data panel with Big Data leaders, includes:
- Richard Hale - IBM Big Data Evangelist
The Analytics panel with Analytics leaders includes:
- Sunil Soares - Founder & Managing Partner at Information Asset, LLC
- Paraic Sweeney - IBM VP Product Management, InfoSphere
- Dave Wilkinson - IBM VP, InfoSphere Development
- Tracy Harris - Senior Manager, Business Analytics
I’m glad to say that we have faculty from some top schools involved with this initiative, including:
- Richard Rodts - Manager, SPSS Solutions Specialist team
- Bob Bry - IBM Academic Initiative Analytics lead
If you think you should be on this list, let me know and I’ll pass your information to the Academics Team.Beyond
these sessions, the faculty will still have time to experience and
learn from the wealth of other IOD events and sessions. The faculty will also have the opportunity to attend a special, invitation only roundtable session::
- Beijing Jiaotong University, China
- Boston University, USA
- Dalhousie University, Canada
- ITAM, Mexico
- ITESM, Mexico
- Radford University, USA
- Ryerson University, Canada
- Simon Fraser University, Canada
- Southern Methodist University, USA
- State University New York at Buffalo, USA
- Syracuse University, USA
- University of Connecticut, USA
- University of Ottawa, Canada
- University of South Carolina, USA
"Watson Heads to the Class" - Preparing a New Generation of Thinkers for Next Generation JobsRecognizing
that a practical understanding of analytics, cognitive computing and
big data is key for 21st century jobs and economic competitiveness, this
round table will bring together a panel of leaders that can discuss the
new ways IBM is working with academia to develop new degree programs,
case competitions, case study programs and internships. A key focus of
this panel will be how IBM is providing academic organizations and
students access to the Watson technology and Watson 'thinkers' in order
to foster greater interest and knowledge in cognitive computing,
analytics, natural language processing technologies; as well as explore
new ways these technologies can be used to address major societal
challenges.ParticipantsIBM Executives: Manoj Saxena, General Manager, IBM Watson SolutionsUniversity
partners: Professor Girish Punj, University of Connecticut, Dr. Thomas
Fomby, Southern Methodist University, Rajiv Dewan, Sr. Associate Senior
Associate Dean for Faculty and Research, University of RochesterSMART program participant: Matthew Canon, Business Planning and Analysis Manager, Andrews Distributing Company====================================================================Beyond IOD, there are many initiatives underway to educate the future, including:Big Data University
IBM DB2 Academic Associate ProgramIBM DB2 program for students and the academic communityThe
IBM DB2 Academic Associate program is exclusively for the university
community. The preparation course teaches relational database concepts
while also providing students with critical, hands-on database skills on
IBM’s DB2 and Data Studio software. Smarter Planet solutions rely on an
ever growing amount of data. Learn how to be smart about managing that
data with this no-charge academic course and IBM exam. IBM Student PortalStudents can find out about jobs, competitions, and discounts on certification exams.Susan
- Easy and Affordable
- Learning Hadoop and other Big Data technologies has never been more affordable! Many courses are FREE!
- Latest industry trends
- Acquire valuable skills and get updated about industry's latest trends right here. Today!
- Learn from the Experts! Big Data University offers education about Hadoop and other technologies by the industry's best!
- Learn at your Own Pace! Find everything right here when you need it and from wherever you are.
Yesterday I read this article “How Employers Can Help Solve the Skills Gap” by David Smith
which discusses the skills gaps that are appearing throughout the world. A
big part of the problem is the lack of corporate funding for education. This
leaves employees to take initiative to keep their skills sharp. But how does
one do so?
My suggestion is to get skilled digitally. IBM is good at digital…
have you noticed? And, I hope that I can give you some direction in
how to do this.
IBM Education is known for its high quality content and excellent
instructors. Take this education digitally, with your choice of the amount of
interaction you want.
Instructor-led online (ILO)
ILO courses are taught by a live
instructor with whom you can interact and ask questions using Voice Over IP
(VOIP). Courses are taught on a specific day and time, some of which may even be
scheduled after business hours to minimize time away from work. Most courses are
exactly the same as their classroom equivalent, including the course duration,
content, hands-on labs and student materials. ILO classes can be delivered in
both Public and Private settings.
Self-paced virtual (SPVC)
SPVC are online courses that include the
same quality course content, exercises and hands-on labs as our classroom
courses. These courses can be taken any time of day or night allowing students
to study when and where they want. Start your training by studying the lecture
content of the course. When ready, log into the lab environment to complete your
hands-on lab assignments working with IBM software. Self-paced virtual courses
are the perfect training method for students who can't travel or prefer the
flexibility of self-paced training. Experience this eLearning method with a free
Web Based (WBT)
WBT allows you to learn at your own pace and on
your schedule with training that is completely self-contained from your desktop.
Most courses provide introductory and overview training that serves as the
foundation for more technical and follow-on training. Courses include expert
instruction but do not include hands-on labs.
I hope you like reading as much as I do… because look at all the choice that
These very popular books have been digital for more than 40 years now! Here
are 10 that you may be interested in: http://ibm.co/hZDwXV
We publish books about IBM products and technologies via a bunch of highly
reputable publishers. Every one of these publishers creates their books in
digital format. Thanks to the popularity of iPads and Kindles, these books can
be inexpensive and available as soon as the printed versions are available.
Here are a few books that you may be interested in: Books, books, books
Electronic Book Libraries
There are three big electronic book libraries that I know of: Safari,
Books 24x7 and PacktLib. Sadly this is publisher-driven, so you will not be
able to find all possible books in any of these libraries. For instance IBM
Press books will be in both Safari and Books 24x7; MC Press books will be only
Books 24x7; and Packt books only in PacktLib. Check to see if you have a
corporate license to any of these libraries. If not, check out your university
or public library. You may be surprised at the number of technical books at
Flashbooks are short targeted books that are handed out to conference
attendees at certain conferences. We also produce these books in electronic
format for you to read them digitally. Here are a few you will want to check
out: Free e-book versions of Flashbooks
DB2 on Campus
DB2 on Campus Series of ebooks - Thanks to an amazing
team of authors led by Raul Chong, we have high-quality ebooks available for
university students to learn about DB2 and related products. The authors who
have worked on these books are experts in their area and they have volunteered
to share their expertise with you for no financial gain to themselves. The
authors can be found around the world, so as a result, you’ll see that many of
the titles have already or will one day be translated to another language. We
at IBM want to make sure that everyone in the world is able to benefit from the
knowledge that is being shared.
Take Certification Exams
You could debate that this topic doesn’t belong here, but consider this: the
assessment and certification exams are delivered electronically. You can take
the assessment exams from anywhere, but you must be at a testing location to
take a high stakes certification exam. There are digital ways to learn and
assess your skills and many exams to choose from. Best of all, the
certification roadmaps take the guessing out of what you should study and what
is important. The Certification Roadmaps give you very clear guidance as to how
grow your skills. Here are a few blog entries you may want to read:
I personally enjoy webinars and find that they are an easy and effective way
to learn something new or to get deeper into a topic. There are so many choices
available that you could set aside an hour a week to catch them all.
DB2Night Show – This is a 2 session per week webinar
produced by IBM Champions Scott Hayes and Klaas Brant. Mondays are when the DB2
for z/OS topics take place and Fridays, the LUW topics. Here are replays of
the top rated shows from the past year on the DB2Night Show: http://bit.ly/i8qP49 and information about the
DB2Night Show's DB2's Got Talent Competition: http://ibm.co/hcCH90
DB2 for z/OS Series – You can find these webcasts
promoted by Surekha via her tweets: https://twitter.com/#!/IBMDB2.
TechTalks (Formerly Chat with the Lab) – This free
webinar series was designed to help you discover practical insights on
deeply technical topics, learn about breakthrough technologies, learn best
practices from the pros, chat with subject matter experts during live Q&A,
and access prior sessions in the OnDemand archive. See the replays of the "Chat
with the Lab" webcasts: http://ChannelDB2.com
Interact with a Community
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 subjects: DB2, InfoSphere, Warehouse, and other Information
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
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
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 :)
DB2University.com – Some of the courses
are free, but not all. The idea behind DB2University is to offer you very low
cost training opportunities.
Facebook – if you participate in Facebook, do a search and
you’ll find IBM well represented.
Twitter – I tweet
and love it. I find that it is a very fast and easy way to stay on top of many
things that are going on.
Blogs – Follow my blog to
get tips like the ones you’re reading now.
So you see, there is much available for you to learn digitally. Try to fit
in a bit a time and you’ll be able to keep your skills strong.
What a great year it’s been for those involved in the DB2Night Show this year! The successes include:
1) First running of the “DB2’s Got Talent” Competition
The DB2Night Show’s “DB2’s Got Talent” competition. This took place in the first few months of the year and continues to please me and others. Last Friday the winner of the competition, Norberto Gasparotto Filho, gave a presentation about what he learned at the IDUG Prague conference in November. Norberto won the IDUG pass as a prize for winning the competition and it was his first IDUG conference and his first time in Europe. I was lucky to be at the conference as well and met Norberto in person. His smile says it all. He is very grateful for his chance to go to the conference, but he earned it. The competition was so successful that it will be repeated in 2012. If you think you can teach people something they didn’t know about DB2, make sure you become a competitor. I also think this competition was successful in building talents in many other people as well. Congratulations to all who took part… you should be proud of your successes.
I suggest that you read my blog entries about the competition… as well as Norberto’s blog.
2) Addition of a DB2 z/OS only series hosted by Klaas Brant.
18 episodes took place this year! What a wonderful first season for Klaas and his guests who included Sheryl Larsen, Dan Luksetich, Namik Hrle, Phil Grainger, Dave Beulke, Cristian Molaro, Julian Stuhler, Surekha Parekh, Susan Visser and Willie Favero, Susan Lawson, John Campbell, Roger Miller, Jeff Josten, and Terry Purcell.
Did you miss any of these shows? Don’t worry! All of them are available in replay.
3) Guest speaker list to die for!
I’ve already listed the guests for the z/OS series of shows. Check out who was a guest of the show for the Cross-Platform or LUW series of episodes: Norberto Gasparotto Filho, Dirk de Roos, Dan Dubriwny, Thiru Swamy, Nadir Doctor, Iqbal Goralwalla, John Hornibrook, Kate Kurtz, Gregor Meyer, Haider Rizvi, Jim Seeger, Max Petrenko, Burt Vialpando, Julian Stuhler, Keith MacDonald, Bryan Paulsen, Paul Turpin, Susan Gausden, Terry Mason, Paul Zikopoulos, and Pat Bates.
Again, if you missed any… or simple wish to listen again, all of the episodes are available to be replayed.
4) Scott Hayes winning IBM Champion award for his outstanding service as a partner.
These awards were given out at IOD, but I can’t find an online page to point you to. I’ll work with Beth Flood to make sure we are aware of the awards. Scott’s award was: Social Media Contribution (Single Social event) of the Year. Congratulations Scott!
To celebrate, join Scott, Klaas and a very large group of DB2 experts (top industry speakers, bloggers, champions and more) at the upcoming Eggnog Party: Celebrating 2011 DB2 Successes and sharing tips and insights for 2012. We’ll share success stories, both DB2 LUW and z/OS, and give our thoughts and tips for 2012. The studio audience will have the opportunity to ask questions.
Date: Tuesday, Dec 20, 2011; Time: 11:00 EST
Why Tuesday December 20th? It will be Scott Hayes' 50th birthday! And... his eggnog might have something special in it!
This is sure to be an entertaining and informative show, so join to celebrate the many successes of the year, plus wish Scott a very happy birthday!
A few interesting things about the IOD Conference in Berlin
that I wanted to share with you.
First of all, apparently attendance for this conference is tracking to be higher than last year's conference in Den Haag, Netherlands. This is excellent news especially given the fact that there are 12 days remaining before the conference begins. I've been told that it is quite normal for attendees of European conferences to sign up just before or the day the conference begins. So if you can make it, you won't be disappointed.
I will NOT be attending the conference, but I have set up a bookstore for you to browse and buy the latest book titles. The bookseller is Andreas Cwienk
I'm disappointed that I won't be able to hear guest speaker Frans Johansson
Entrepreneur, Thought-Leader and Author of "The Medici Effect"
The intersection of business and innovation
Johansson is an entrepreneur and thought-leader. He is also a
consultant and the managing director for a hedge fund. Frans previously
co-founded and managed two companies, a Boston-based software company
and a medical device company operating out of Baltimore, Maryland and
Raised in Sweden by
his African- American and Cherokee mother and Swedish father, Frans
earned an MBA at Harvard Business School and a BS in environmental
science at Brown University.
Frans is a
successful author and has written on a variety of topics, from business
management to healthcare to sport fishing to how to save our oceans.
His bestselling book, The Medici Effect, has been translated into 17 languages and was named One of the Ten Best Business Books of 2004 by Amazon.com.
will be signing copies of The Medici Effect on Thursday, 4 June during
the Coffee Break at 15.45 – 16.15 in the Marketplace
If you need more reasons to attend the conference, see the website for lots of great ideas!
If you are planning to attend, I hope you have a good time, enjoy the speakers, meet lots of people, and best of all, increase your skills.
My TV is on its last legs, so what did I do? I searched several websites for
possible replacements and only considered those that had customer feedback and
multiple stars. I do this for books, movies, electronics, cars, just about
anything I consider buying. Do you do the same thing?
If the feedback from someone with actual experience is positive, I am more
likely to seriously consider buying the item myself.
If the feedback is
overwhelmingly positive from many people, my buying decision gets easier. If the
feedback is negative, it helps as well... but only if a clear description of the
problem is described and multiple people have experienced the same problem /
So... will you be willing to provide feedback to others regarding the
books that you've read? Let's face it, making a decision to buy a book isn't
only made based on the price of the book, but also on whether it is worth your
valuable time to read the book. We're all short on time, so we want to be sure
that we aren't wasting our time by reading a book that won't help
Where can you post your feedback? For books, amazon.com is likely the
most useful place. I'm in Canada, but still chose to read the feedback that is
posted on amazon.com rather than one of the Canadian sites. Why? Simply because
there tends to be much more feedback on amazon.com than anywhere else. But, you
can still provide feedback on any of the sites that take feedback. Even db2inbooks is a
good site to post feedback.
What should you avoid? It won't help anyone if your feedback is
negative, but you haven't actually read the book. Yes, it does happen. For
instance, my first book had a negative comment made by a reader because of the
title. I don't think the reader read a single word of the book, but decided to
trash it based on the title alone. Is this fair? Absolutely not. I'm sure most
people would disregard this type of feedback, but save yourself some time, if
you didn't actually read the book, don't bother posting comments... positive or
is of more use than just saying that you liked the book. For example, you could
say... "I read the certification guide and was able to learn everything that
I needed in order to pass the exam with an excellent score. I believe that my
success was based on how easy it was to read the information as well as the
sample questions that explained to me why my first answer was incorrect."
This is actual feedback that I've personally received from a reader who read one
of Roger Sander's books.
If you find errors in the book that aren't very serious but that should be
corrected.... I suggest that you contact the author directly if you can. It is
near impossible to produce an error-free book. Most of the authors who I work
with make it easy for you to reach them. Check in the front of the book... you
may find an email address. Also check on ChannelDB2.com as many of our
authors are members and would be happy to hear from you. If you'd rather not
contact the author directly... you can always go directly to the publisher... or
to me. I'll make sure your comments are sent to the author who can then make the
corrections for future iterations of the book.
If you really like reviewing books... and think that you are good at it....
did you know that you may qualify to get free books from the publisher? In some
cases we ask people to review the book before it publishes and ask reviewers to
provide a comment that may be included on the cover of the book. If this
interests you, let me know.
Share your opinion... everyone will appreciate it :)
Beyond books, your opinion about the presentations being
delivered at conferences or webinars is also extremely valuable. Right now on
the DB2Night Show, we are in the Final Rounds of the “DB2’s Got Talent
Competition”. During the finals, the power is in the hands of you the listener
to choose who will win a very lucrative prize as the overall champion. Don’t
miss your opportunity, see DB2’s
Got Talent Finals – Round 1 for further information.
I’d be remiss if I didn’t add that your feedback on blogs is
also important. You can show your “like” of a blog by following it, making
comments on the content, reshare it via twitter or other social media sites, or
add a “like” to the entry.
Join Burt Vialpando and Rav Ahuja on Thursday September 29, 2011 where they will do a comparison on autonomic computing between DB2 and Oracle:
Many database professionals ask how DB2 and Oracle compare regarding their autonomic capabilities. That is, how do they make things easier for the DBA with smart, automatically implemented features. They also wonder if there is a clear advantage of one over the other in this respect. This DB2 Chat with the Lab webinar will answer those questions and include a comparison of following autonomic capabilities in DB2 and Oracle:
- Memory Management
- Storage Management
- Utility throttling
- Automatic Configuration
- Automatic Maintenance
DB2 and Oracle - An Autonomic Computing Comparison
Date: Thursday, September 29, 2011 (29.9.2011)
Time: 12:30 PM - 2:00 PM Eastern Time (ET) ; 11:30 AM Central / 9:30 AM Pacific / 17:30hrs London / 18:30hrs Frankfurt, Paris / India 10 PM
Speakers: Burt Vialpando Host: Rav Ahuja
The session will be recorded, but attend live to get your questions answered.
Presentation charts will be available just before the webcast starts.
To register and receive instructions for attending this webcast: Register
Thanks to Rav for this information.
The conclusion of an intensive IDC study
and in Linda Musthaler's
article "Is certification valuable, or not? We have the definitive answer
" is YES certifications are important! Companies need high-functioning teams that are able to transform and grow the business like never before. These teams consist of highly skilled professionals who have current and relevant knowledge. Certifications are designed to encourage people to keep learning and then to validate their skills.
Although the report doesn't specifically mention database or DB2 certifications, I would say that the same holds true. I've personally seen the performance of a team improving as a result of the entire team earning DB2 certifications. The DB2 program grew 29% in the past year and is expected to grow this year as well. Are you on board?
To help you navigate through this certification program, I've created the following entries:
1) Certification 101
that links to articles about the benefits, where to start, how to prepare, and what to do once you've passed.
2) Certification Checklist
where you learn to use a checklist within developerWorks that leads you through the entire certification process.
Don't be left behind! Jump onto the Certification bandwagon so you can begin seeing the improvements in your skills and the skills of your teams.
PS. Don't forget that earning a certification benefits you personally as well. It can differentiate you from others, but will also give you the confidence that you do have the skills that you need to do your job!!
The initial response to DB2 10 has been extremely positive. An early adopter of DB2 10 said, “We could not have been more thrilled with all the performance improvements! There is definitely gold in this version and you don’t even need to spend time to find it. It’s truly right out of the box.”
Have you moved to 10 yet? Or looking at migrating to DB2 10 this year ? Join John Campbell, IBM Distinguished Engineer for a special 2 hour presentation on February 21st & 22nd: IBM DB2 10 Migration Planning and Very Early Experiences – PART 1 & PART 2. This will be a LIVE webcast with LIVE Q&A.
To help facilitate your migration, John Campbell will provide planning information about migrating to DB2 10 for z/OS from either DB2 9 or DB2 Version 8. This webcast will be a two part series on February 21st and 22nd.
Join us for this webcast series which will
- Share surprises, pitfalls and lessons learned
- Provide hints and tips
- Discuss enabling fast start
- Introduce and discuss some further enhancements
- Share the latest news about migrations
All participants will receive complimentary DB2 10 Migration Planning whitepaper written by John Campbell
IBM DB210 is here and while early adopters have already upgraded to the new version and are reaping the business benefits, others are just beginning to think about upgrading with DB2 Version 8 been withdrawn from marketing on April 30th 2012. Attending this webcast will give you valuable information for your migration. Bring your questions as there will be plenty of opportunity for live Q &A.
Register Now: IBM DB2 10 Migration Planning and Very Early Experiences – PART 1 & PART 2.
Part 1 - February 21, 2012 at 11:00 a.m. Eastern Standard Time, 4:00 p.m. GMT / UTC
Part 2 – February 22, 2012 at 11:00 a.m. Eastern Standard Time, 4:00 p.m. GMT / UTC
Don't be left behind, upgrade to DB2 9.5 now
..... before DB2 8.2 for Linux, Unix, and Windows is put out to pasture.
Why should you upgrade to DB2 9.5 now
DB2 9.5 offers a lot of good reasons to upgrade
- 35% Improvement in DBA Efficiency
DB2 automatically performs time-consuming database administration tasks like memory management and storage allocation.
- Lower Server and License Costs
DB2 needs fewer processors, which means less hardware to purchase. It also means less software to license and maintain.
- Lower Storage Costs
DB2 customers are reporting compression ratios of up to 83%, which means less storage to buy and maintain.
- Easier XML projects
Customers are reporting that XML projects require between 30% and 66% fewer people.
- Peace of Mind
DB2's world class security and audit features ensure that you meet your current needs, as well as your evolving future needs.
- Free update for customers with DB2 support!
Need even more reasons? See the technical reasons to upgrade.
Just released: "Unleashing DB2 10 for Linux, UNIX, and Windows", and
available for downloading in either PDF format or EPUB format for use on ebook
This IBM® Redbooks® publication provides a broad
understanding of the key features in IBM DB2® 10 and how to use these features
to get more value from business applications. It includes information about the
- Time Travel Query, which you use to store and retrieve time-based data by
using capability built into DB2 10, without needing to build your own solution
- Adaptive compression, an enhanced compression technology that adapts to
changing data patterns, yielding extremely high compression ratios
- Multi-temperature storage, which you may use to optimize storage costs by
identifying and managing data based on its “temperature” or access requirements
- Row and column access control, which offers security access enforcement on
your data, at the row or column level, or both
- Availability enhancements, which provide different DB2 availability features
for different enterprise needs; high availability disaster recovery (HADR)
multiple-standby databases provide availability and data recovery in one
technology, and the IBM DB2 pureScale® Feature provides continuous availability
and scalability that is transparent to applications
- Oracle compatibility, which allows many applications written for Oracle to
run on DB2, virtually unchanged
- Ingest utility, a feature-rich data movement utility that allows queries to
run concurrently with minimal impact on data availability
This book is for database administrators and application developers who are
considering DB2 10 for a new installation, an upgrade from a previous version of
DB2, or a migration from a vendor product. It explains key features and
illustrates concepts with real-world examples to provide a clear idea of how
powerful these features are.
Together, these features provide functionality that lower operational
costs, ease development, and provide greater reliability.
As one of the
authors of the Redbook, I would appreciate any assistance in spreading the word
about the new book to interested people in the larger DB2 community. The book
has examples of how to use the various features, along with sample output, and
detailed explanations of the major new features such as Time Travel Query,
Multi-temperature storage, and RCAC, along with several other features.
Table of Contents
Chapter 1. Introduction to DB2 10
Chapter 2. Time Travel Query
3. Adaptive compression
Chapter 4. Multi-temperature storage
Row and column access control
Chapter 6. Availability enhancements
7. Oracle compatibility
Chapter 8. Ingest utility
Appendix A. Ingest
I have so much that I want to tell you about last week’s IOD11 conference, but I keep running out of time! I wasn’t able to connect last week while at the conference, so I had much mail to respond to today. So, here are the highlights, but look for more entries in the next few weeks.
1) People. Wow… were there a lot of people at the conference! I spoke to many people and made so many new friends. I’m already looking forward to IOD 2012 to see them again. Last year was amazingly well attended, and this year had more attendance. Thanks to all of you who attended! And… sorry for not spending time with the many people who have emailed me saying that they came to the bookstore to see me, but I wasn’t around!
2) Books. We sold more books this year than we did last year… and last year was a record for us. Shortly I’ll have all the details and will be able to tell you which books were best sellers. I can tell you from what I witnessed at the signings that the most popular books were Moneyball, Cognos 10, and Bold… followed closely by Netezza, Data Warehouse, and Data Integration. More on these books later.
3) Michael Lewis and Billy Beane. One of the highlights for me was meeting Michael and Billy. I’ve read two of Michael’s books and fully intend to read others. I really like his style of writing and encourage you to pick one up if you haven’t. Billy is amazing… friendly, good looking, athletic… I found it hard to believe he has a temper! The talk that the two of the had in the opening session on Wednesday was a lot of fun and for those who missed it, I can only guess that it will be edited before it is releases as a video, if it is released at all. The signing was truly amazing… never have I seen such excitement for a book. For those who missed the fact that there was a signing…. make sure you keep reading my blog as I’ll know in advance who the speaker will be and if it is an author, will read their books before the conference.
4) Jeff Jonas. He opened the conference with a short but amazing talk on Monday morning. In my opinion, he was the highlight of the day.
5) Train. The event on Tuesday featured the band Train. They were great. The lead singer knows how to work a crowd. The food was lacking, but everything else rocked! Sal Vella and I hung out and made the best of the opportunity to meet & greet as many people as we could.
6) Women. The WIT event on Wednesday night was the best attended WIT event I’ve ever attended! Is it because it was just announced that Ginny was taking over from Sam as CEO? Or was it better promoted? In any case, we have more reason than ever to celebrate women at the event. Inhi took a photo of the 300 attendees and sent it to Ginny who was touched by the gesture. The one shadow over the event was the tribute we had for one of our female colleagues who had just passed away due to breast cancer. Many of us at the event knew her well and were deeply saddened by her suffering and our loss. RIP Linda!
7) Champions. We have new champions this year and more coming. I am very lucky to know many of them… but there are many more who I’d like to meet. I had breakfast with Susan and Terry, who I nominated to be champions.
8) Flashbooks. We produced 3 new flashbooks for this conference and were blown away at the response. Let’s start with the Big Data book. We gave out 3000 copies after the Monday opening session. I couldn’t believe that we went through all the books, so spent the rest of Monday looking for the rest of my shipment. It was proved beyond a shadow of a doubt that I did in fact receive all the books and yet, it is possible to give away that many books in half an hour! I then ordered 1000 additional copies to give out to the many disappointed people who were unable to get a copy on Monday. The other two Flashbooks also generated a huge amount of excitement and I was very pleased to see us “sell out” of every single copy. If you missed your copy, watch for another entry from me about how you can get an e-version of any of these books free of charge.
9) Walking. Last year I wore a pedometer and walked 99 miles. I inspired my team who were running the “Services, Support & Education Zone” to have solar-powered pedometers as their giveaway. I’m sure that there are several people who were able to beat my distance from last year! Let me know if you did. I didn’t wear a pedometer this year, but know that I walked many a mile. I still say “ouch” with nearly every step!
10) Social Media. I gave two presentation about social media and received positive feedback from these sessions. I have more to tell you about this topic, but wait for another entry. Before the conference, I created 25 blog entries to help promote the many events that were planned. I’m happy to say that I have had the more views this month than any other month since I began blogging. I hope that means you find my entries helpful. I wasn’t able to tweet while at the conference, so I thank those who tweeted about my entries. Long live blogging!
More to come!
It's been awhile since I blogged about the ChannelDB2.com
. I've noticed that we now have cool posters on the walls of the lab to build awareness for ChannelDB2.com. The poster says
ChannelDB2.com now has 2,388 members, 71 groups, 259 videos and presentations, discussions, and links to free books and software. Are you a member yet? I've noticed that the university relations teams are reaching out to people in universities across the world and encouraging people to join groups that are specific to their country or university. If your country / university isn't represented, add it!
The videos are very interesting interviews and presentations featuring various people inside and outside of IBM. You'll find topics on just about everything covered in these videos. The best thing? If you have an educational video that you would like to share, you can add it to the collection.
The groups allow you to give and get information about related topics. For instance, one of my groups is DB2 in Books
where I post information about the latest published books, events related to the books, and discounts if they are available. If you are a member of the group, you are able to ask questions that can be answered by me or perhaps an author of one of the books. If you aren't yet a member of this or other groups, it is easy to join... and you won't get too much mail as a result of joining.
You can also create groups yourself. If you feel that there is a topic that isn't yet covered, create a group and invite people to join.Raul Chong
and his team have been busy creating e-books for you to download for free. These are full books in the 300-page range and can be read on your computer. The two latest titles include "DB2 Express-C: Updated for 9.7" and "IBM Data Studio for DB2". These books are part of the "Getting Started" series and will introduce you to the software and how to use it. The books are full of screen captures and are easy to read.
In conjunction with the books is the free software. From ChannelDB2.com, you'll find links to the Express-C software that you can download for free to try all the latest features. If you haven't tried DB2 yet, this is the best way to get your hands on it to see how easy it is to use and learn.
Lastly are the blogs. You may already know that PlanetDB2.com is an aggregate of all DB2 related blogs. These blogs are also pulled into ChannelDB2.com, so you can come to one place for all kinds of important information.ChannelDB2.com
is a way for you to actively participate in learning, sharing, and discussing the DB2 products.
If you are a member, ask me to be your friend :)
Modified on by svisser1
Today is the start of Labour Day weekend in Canada… and surprisingly, Labor Day weekend in the US. Here in Canada this is the official “end” of summer since school begins once the long weekend is over.
I’ve been gathering details on the events that are coming for September and I found so many that it feels we’re all back to school in September. Take a look at what I mean:
Sept 4: TwitterChat:"Speeding Up Transactions & Analytics with In-Memory Processing"
Sept 6 - DB2Night Show webinar Performance Experiences and Best Practices with DB2 BLU - Berni Schiefer, Jessica Escott, Michael Kwok
Sept 12 - IBM & InformationWeek Webcast - A Simple and Affordable Path to Speed of Thought Analytics - Bernie Spang, Andrew Jaurez, Bob Friske
Sept 12 - For partners: “Deep Dive into DB2 with BLU Acceleration”
Sept 17: webinar: Streamlined Operational Efficiencies - John Park, IBM
Sept 18: Twitterchat on Handling the Potential Volume: Managing growing data with BLU Acceleration.
Sept 19: DB2 Tech Talk: DB2 with BLU Acceleration Competitive Advantages
Chris Eaton (presenter), Rick Swagerman (host)
Sept 19: Think Big: What Your Database Software Can Do for You in the Era of Big Data - Kelly Schlamb and George Baklarz
Sept 20 - DB2Night Show webinar DB2 BLU Experiences at **** - Kent Collins
Did I miss any? I’m sure I did. If you have other events you’d like me to promote, let me know. Let’s get everyone up to speed on the incredible new software that is DB2 10.5 with BLU Acceleration!
PS. Follow us on Twitter to have reminders of these and other events as they are about to take place.
Breaking News! We now have a hub for everything BLU! We took what we learned running other hubs and created the “BLU microsite”. Check it out!
Join Sal Vella and Steve Rees for the next Chat with the Lab event: The Latest in Advanced Performance Diagnostics on Tuesday May 31. DB2 Chat with the Lab is a free webinar series from the IBM labs that invites experts to speak to you about DB2-related breakthrough technology, best practices, and to answer your questions.
Recent releases of DB2 for LUW have continued to introduce improved ways to monitor the performance of your system, and uncover & solve performance problems. This presentation will review the gamut of performance tools on offer in DB2, focusing on recent additions such as the new 'time spent' metrics in DB2 9.7, new table functions to access monitor data, and the latest in db2pd options to see what's going on "under the hood" . The emphasis will be on the practical use of these tools to solve typical performance problems.
- Sal Vella, VP Database Development
- Steve Rees, DB2 Performance Architect
Presentation charts will be available on ibm.com/db2/labchats just prior to the event.
Date: Tuesday, May 31, 2011 (31.5.2011)
Time: 12:30 AM - 2:00 PM Eastern Time (ET) 11:30 AM Central / 9:30 AM Pacific / 17:30hrs London / 18:30hrs Frankfurt, Paris / India 10 PM
There have been many episodes in this series. You find them and watch the replays on ChannelDB2.com. To tempt you, here is a list of what you’ll find:
Someone has been very busy! And the best part? They’re all FREE! Learn & Enjoy.
You may have noticed that I’ve added a new link onto my blog page today.
This link will take you to the DB2 for z/OS Exchange.
The DB2 for z/OS Exchange was launched today. The Exchange is intended to
play a similar role to the old "zHotline" as we strive to
better equip customers to help themselves by pushing critical technical
information out on a regular(monthly) basis. This content can take many forms,
such as: technical best practices, critical issues seen in the field and
recommendations of how to handle them, notifications of undocumented
incompatible changes, highlighting critical HIPERs, sample code and more. We
will use the Exchange as a mechanism to share high value/high importance
Sounds like a very helpful place to visit for important information. Get the
RSS feed or add a bookmark to the Exchange so you can visit often.
Thanks to Lisa Johnson for this information.
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:
First Episode of “DB2 has Talent”
Second Episode of DB2 has Talent
Third Episode of “DB2 has Talent”
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!
Tech Talk Details:
Best Practices in DB2 for Linux, Unix and Windows Application
Thursday August 30, 12:30 PM ET
Speakers: Holly Hayes and Cliff Leung
Join host Serge Rielau with guests Holly Hayes and Cliff
Leung for a deep dive into IBM InfoSphere Optim
solutions that offer the state of art performance monitoring
and optimization technology for DB2 for LUW.
Rigorous performance monitoring and management are crucial for business
critical applications. Even with premier in-engine query optimization,
application performance for DB2 is dependent on factors like available
resources, good database design and data access best practices.
Using these performance management solutions for DB2, Holly and Cliff will
show you how to:
- identify emergent performance related problems
- diagnose where the problem resides
- resolve issues in the application or database design
- proactively prevent performance problems from re-occurring.
The featured offerings include:
- IBM InfoSphere Optim Performance Manager
- InfoSphere Optim Query Workload Tuner
- InfoSphere Optim Configuration Manager
- InfoSphere Optim pureQuery Runtime
which are also part of DB2 Advanced Enterprise Edition and
InfoSphere Warehouse Advanced Enterprise Edition.
Have you missed any of the previous TechTalks? No worries, they were
recorded and are available whenever you are:
PS: Thanks Serge Rielau and Cindy Russell
for your dedication to this program.
Thanks to Leons Petrazickis
for reminding me about the DB2 Wiki
. Leons was able to add a recently written white paper to the site and I thought this would give me a good opportunity to tell you what you can find on this site.
The white paper that was just added is:
Authors: Andre Albuquerque, Irina Delidjakova
This paper will help you get started with DB2 Express-C and Virtuozzo Containers for Linux. Combined with Parallels Virtuozzo Containers 4.0 for Linux®, DB2 Express-C software can be a powerful addition to your information management infrastructure. Virtuozzo Containers offers a high-performance, space-efficient operating system virtualization solution that you can use to create new virtual machines, also known as containers,within seconds.
What else can you find on this wiki?
This wiki contains an extensive list of articles, publications, tutorials, and other DB2 material. Check the appropriate document in this wiki to see the full list.
These are our latest featured DB2 articles and tutorials. This is just a small subset of all the material available in the wiki, so if you don't see what you need in this list, check the complete listings.
I hope you find something of interest on this site. If you have or know of content that should be placed here, let me or Leons know and we'll see what we can do.....
Great articles by amazing contributors. Make sure you read every article in the latest edition of the DM Magazine. I’ve read the article about Roger Sander’s contribution to the DB2 Certification Exam Development team and the announcement of his latest certification guide, which is a supplement. I’ve bookmarked many of the other articles so I can read them over the coming week. I hope you find something interesting and useful in this edition!
Taming Big Data - The realm of huge information flows is governed by new rules. What changes in the multi-petabyte, microsecond response, multimedia world? And how will Big Data change your job?
by Lisa Stapleton
It’s not just huge volumes. It’s not just microsecond response times, it’s not just incredible variety. It’s all three. Dealing with “nice” data, stored in well-defined data warehouse structures and handled sometimes months or years after it is first collected, is an increasingly smaller part of the job of data management. Here’s how folks are learning to handle the rest of it—the unstructured data, and the data that constantly changes as customers take actions and applications process input.
Tuning SQL at the Senate: E Pluribus Unum - When the SQL flow in the United States Senate went from static to dynamic, the database team had to see many queries, but tune them as one.
by Ives Brant
“High-performance government” may sound like an oxymoron, but for the teams that monitor and tune databases for the U.S. Senate, high performance is absolutely necessary to handle the huge number of queries that hit the Senate’s financial management system. InfoSphere Optim Query Workload Tuner software running on IBM DB2 z/OS helps the U.S. Senate DBAs and software specialists reduce query response time from 20 to 30 seconds to less than 2 seconds when they generate new statistics for a workload of SQL queries.
The Man to See About Certification - The guru of DB2 certification tests talks about how he puts them together—and how they can help your career
by Howard Baldwin
Q&A with Roger Sanders who has helped IBM develop 17 DB2 certification exams, more than any other individual. Want to know why certification is important? Roger Sanders is the man to ask. We talked to him about how the tests are put together, how they can help a DBA’s career, and—oh yes—about the certification test he failed.
Get Your Head in the Clouds - Data Pros are adopting cloud computing concepts to offer databases as a service - easing management burdens and sending users to cloud nine.
by Jin Zhang
Tactics and strategies for moving away from traditional provisioning models in which DBAs function solely in reactive mode—responding to user requests in nonstop “database, clone, database, clone” activities—towards a database-as-a-service, or DBaaS (pronounced as “D-Baa-S”), model employing cloud computing practices.
To offer DBaaS on the cloud, enterprise IT departments must undergo a process of constructing and managing a private enterprise “data cloud”—a platform consisting of storage hardware, virtual images, database schemas and more—and making that cloud available to users through a services interface.
Smarter is… Making Watson Smarter…Faster
by Howard Baldwin
A deeper look at the Jeopardy-winning system and the technology that enables it to process information in near real-time.
IBM Information Governance Council - Information Governance Community growing worldwide - IGC draws 1500 members, solicits best practices ideas
by the Magazine Team
The wisdom of crowds isn't an oxymoron. Large groups have an uncanny ability to get the right answer - just see James Surowiecki's book on the subject for proof. So it's not unreasonable to say that the Information Governance Council (IGC) is getting smarter with each passing month.
Data Architect - Securing DB2 Data - Grant privileges to a what, not a who
by Robert Catterall
These days executives are more concerned than ever about unauthorized access to data entrusted to their organization. Their fears are justified: a recent study showed that a third of those polled would quit doing business with a company they perceived to be guilty of a data security breach.
Distributed DBA - Using the DB2 Problem Determination Tool
by Roger E. Sanders
Sooner or later, every DBA encounters problems. Consequently, a skill that every DBA must possess is the ability to perform a logical, systematic search of a database system for the source of any problems that might arise. The DB2 Problem Determination Tool can help.
Programmers Only - New Order by Information: Part 2. The Impact of using the RANDOM index option on ORDER BY sort avoidance
by Bonnie Baker
In the last issue, Bonnie Baker began a series of columns concerning new aspects of ORDER BY. This column - Part 2 - covers the impact of using the CREATE / ALTER INDEX RANDOM order option on sort avoidance.
Performance tuning on Informix - Fastest Informix DBA Contest III - Performance tuning an OLTP system
by Lester Knutsen
Performance tuning is a continuous process for every DBA. Advanced DataTools Corporation conducted three fastest Informix DBA contests to highlight and learn what goes on in this process.
Imagine What You Could Do - Free your mind, and your business will follow
by David Buelke
Big Data, Big Time - Series data, warehouse acceleration, and 4GLs
by Stuart Litel
Modified on by svisser1
Rick Swagerman who took over as the DB2 Tech Talks Host from Serge Rielau has just recorded two Tech bits. Tech bits are shorter recordings on topics related to DB2. These two bits are both conversations with IBM Champions to hear their impressions of the latest technology being delivered in DB2 10.5.
These champions have taken part in the early access beta program for the past few months and were very impressed with what they found and were excited to share their impressions with you:
IBM Champions Jean-Marc-Blaise and Iqbal Gorawalla on BLU Acceleration in DB2 10.5
This is a single Tech Bit and is 24 minutes in length.
See also Iqbal’s blog on this topic: DB2 10.5 Addresses Big Data Challenges with BLU Acceleration
IBM Champion Tony Winch on BLU Acceleration in DB2 10.5
(about 10 mins in length)
For more about DB2 10.5 with BLU Acceleration, see my previous blog entry Do you know BLU? and look for another blog entry that I’ll post shortly.
Thanks Tony, Iqbal and Jean-Marc for sharing your impressions of this new technology!
MDM for Customer DataOptimizing Customer Centric Management of Your Business
Author: Kelvin K. A. Looi
ALL THIS FOR $14.95!
Master Data Management (MDM) is a fascinating, up-and-coming IT
solution approach that allows an organization to run a customer-centric
business operation. Since MDM is a relatively new concept in the IT
world, its real capabilities, purposes, and values are easily
misunderstood. If you’re looking for an easy way to understand what MDM
really is and how it came about, then this is the book you’ve been
after. Beyond providing a simple understanding of MDM, it also
describes how an organization can implement an MDM solution in phases
to enable the business operation
to be customer-centric, with each phase showing a positive return on
book will also clear up the many misconceptions of what MDM is and how
it is different from Client Information File, CRM, and Data Warehouse
solutions. The differences are clearly explained, and the authors
further show how MDM can co-exist with these other solutions with and
optimize their operations by providing them with trusted data.
With MDM for Customer Data, you will:
• Know the different MDM implementation styles and approaches
• Understand the importance of data governance for successful implementation
• Be prepared to implement the first phase of an MDM project
• And much, much more
Chapter 1: The Elusive Customer-centric Operation
Chapter 2: The Application Agenda Era
Chapter 3: The Information Agenda Era
Chapter 4: MDM for Customer Data
Chapter 5: How Other Organizations Use MDM for Customer Data: Case Studies
Chapter 6: Data Governance
Chapter 7: Be Careful What ou Ask For: Your IT Might Actually Deliver
Chapter 8: Other Master Data Management Data Domains
Congratulations to Kelvin on this amazing accomplishment!
Modified on by svisser1
This is the third book from in the series of Master Data Management books led by author Martin Oberhofer:
Beyond Big Data: Using Social MDM to Drive Deep Customer Insight
Author team: Martin Oberhofer, Eberhard Hechler, Ivan Milman, Scott Schumacher, Dan Wolfson
If you are attending the IBM Insight Conference, be sure to attend the book signing to meet the authors on Tuesday October 28 from 2:45pm – 3:45pm. If you are one of the lucky ones, you’ll get a free copy of the book! There is only a limited amount available, so add this event to your calendar so you don’t miss it.
About the book:
Enterprises have long relied on Master Data Management (MDM) to improve customer-related processes. But MDM was designed primarily for structured data. Today, crucial information is increasingly captured in unstructured, transactional, and social formats: from tweets and Facebook posts to call center transcripts. Even with tools like Hadoop, extracting usable insight is difficult—often, because it’s so difficult to integrate new and legacy data sources.
In Beyond Big Data, five of IBM’s leading data management experts introduce powerful new ways to integrate social, mobile, location, and traditional data. Drawing on pioneering experience with IBM’s enterprise customers, they show how Social MDM can help you deepen relationships, improve prospect targeting, and fully engage customers through mobile channels.
Business leaders and practitioners will discover powerful new ways to combine social and master data to improve performance and uncover new opportunities. Architects and other technical leaders will find a complete reference architecture, in-depth coverage of relevant technologies and use cases, and domain-specific best practices for their own projects.
How Social MDM extends fundamental MDM concepts and techniques
Architecting Social MDM: components, functions, layers, and interactions
Identifying high value relationships: person to product and person to organization
Mapping Social MDM architecture to specific products and technologies
Using Social MDM to create more compelling customer experiences
Accelerating your transition to highly-targeted, contextual marketing
Incorporating mobile data to improve employee productivity
Avoiding privacy and ethical pitfalls throughout your ecosystem
Previewing Semantic MDM and other emerging trends
Other books in this series:
Enterprise Master Data Management: An SOA Approach to Managing Core Information
A very interesting story about this book! I spoke with several of the authors at the IBM IOD conference this fall and learned that when they visit customers to help them implement complex MDM solutions, they find that their clients are using this book as the ultimate guide.
I read the book cover to cover and can see why it is so valuable. The authors have put great care into creating “patterns” for specific industries that cover every conceivable detail about the data and the world around it. I think this is a must read for anyone with a complex environment.
About the authors:
Martin Oberhofer works as Executive Architect in the area of Enterprise Information Architecture with large clients world-wide. He helps customers to define their Enterprise Information Strategy and Architecture solving information-intense business problems. His areas of expertise include master data management based on an SOA, data warehousing, Big Data solutions, information integration, and database technologies. Martin delivers Enterprise Information Architecture and Solution workshops to large customers and major system integrators and provides expert advice in a lab advocate role for Information Management to large IBM clients. He started his career at IBM in the IBM Silicon Valley Labs in the United States at the beginning of 2002 as a software engineer and is currently based in the IBM Research and Development Lab in Germany. Martin co-authored the books Enterprise Master Data Management: An SOA Approach to Managing Core Information (IBM Press, 2008) and The Art of Enterprise Information Architecture: A Systems-Based Approach for Unlocking Business Insight (IBM Press, 2010) as well as numerous research articles and developerWorks articles. As inventor, he contributed to more than 70 patent applications for IBM and received the IBM Master Inventor title. Martin is certified by The Open Group as a Distinguished Architect and holds a master’s degree in mathematics from the University of Constance/ Germany.
Eberhard Hechler is an Executive Architect who works out of the IBM Boeblingen R&D Lab in Germany. He is currently on a three-year assignment to IBM Singapore, working as the Lead Architect in the Communications Sector of IBM’s Software Group. Prior to moving to Asia, he was a member of IBM’s Information Management “Integration and Solutions Engineering” development organization. After a two-and-a-half year international assignment to the IBM Kingston Development Lab in New York, he has worked in software development, performance optimization and benchmarking, IT/solution architecture and design, and technical consultancy. In 1992, he began to work with DB2 for MVS, focusing on testing and performance measurements. Since 1999, he has concentrated on Information Management and DB2 on distributed platforms. His main expertise includes the areas of relational database management systems, data warehouse and BI solutions, IT architectures and industry solutions, information integration, and Master Data Management (MDM). He has worked worldwide with communication service providers and IBM clients from other industries. Eberhard Hechler is a member of the IBM Academy of Technology, the IBM InfoSphere Architecture Board, and the IBM Asset Architecture Board. He coauthored the books Enterprise Master Data Management (IBM Press, 2008) and The Art of Enterprise Information Architecture: A Systems-Based Approach for Unlocking Business Insight (IBM Press, 2010). He holds a master’s degree (Diplom-Mathematiker) in Pure Mathematics and a bachelor’s degree (Diplom-Ingenieur (FH)) in Electrical Engineering (Telecommunications).
Ivan Milman is a Senior Technical Staff Member at IBM working as a security and governance architect for IBM’s Master Data Management (MDM) and InfoSphere product groups. Ivan co-authored the leading book on MDM: Enterprise Master Data Management: SOA Approach to Managing Core Information (IBM Press, 2008). Over the course of his career, Ivan has worked on a variety of distributed systems and security technology, including OS/2® Networking, DCE, IBM Global Sign-On, and Tivoli® Access Manager. Ivan has also represented IBM to standards bodies, including The Open Group and IETF. Prior to his current position, Ivan was the lead architect for the IBM Tivoli Access Manager family of security products. Ivan is a member of the IBM Academy of Technology and the IBM Data Governance Council. Ivan is a Certified Information Systems Security Professional and a Master Inventor at IBM, and has been granted 14 U.S. patents. Ivan’s current focus is the integration of InfoSphere technology, including reference data management, data quality and security tools, and information governance processes.
Scott Schumacher, Ph.D., is an IBM Distinguished Engineer, the InfoSphere MDM Chief Scientist, and a technology expert specializing in statistical matching algorithms for healthcare, enterprise, and public sector solutions. For more than 20 years, Dr. Schumacher has been heavily involved in research, development, testing, and implementation of complex data analysis solutions, including work commissioned by the Department of Defense. As chief scientist, Scott is responsible for the InfoSphere MDM product architecture. He is also responsible for the research and development of the InfoSphere Initiate matching algorithms, and holds multiple patents in the entity resolution area. Scott has a Bachelor of Science degree in Mathematics from the University of California, Davis, and received his Master of Arts and Doctorate degrees in Mathematics from the University of California, Los Angeles (UCLA). He is currently a member of the Institute for Mathematical Statistics, the American Statistical Association, and IEEE.
Dan Wolfson is an IBM Distinguished Engineer and the chief architect/CTO for the Info- Sphere segment of the IBM Information Management Division of the IBM Software Group. He is responsible for architecture and technical leadership across the rapidly growing areas of Information Integration and Quality for Big Data including Information Quality Tools, Information Integration, Master Data Management, and Metadata Management. Dan is also CTO for Cloud and Mobile within Information Management, working closely with peers throughout IBM. Dan has more than 30 years of experience in research and commercial distributed computing, covering a broad range of topics including transaction and object-oriented systems, software fault tolerance, messaging, information integration, business integration, metadata management, and database systems. He has written numerous papers, blogs, and is the coauthor of Enterprise Master Data Management: An SOA Approach to Managing Core Business Information (IBM Press, 2008). Dan is a member of the IBM Academy of Technology Leadership Team and an IBM Master Inventor. In 2010, Dan was also recognized by the Association of Computing Machinery (ACM) as an ACM Distinguished Engineer.
What an author team! What will their next book be about? Wait and see!
I asked my wonderful friend Rebecca Bond to give me her IDUG Conference
schedule for the Tampa conference during the week of May 10th. I asked Rebecca because she is working as a DBA and has for many years. I figure that her schedule will more closely match the target audience than a schedule I'd put together.
I had to make some REALLY difficult decisions. There are some EXCELLENT speakers and sessions this year.
These are the ones I finally decided to attend. I seriously hope that the ones I am going to miss will be presented at IOD so I can try to attend them then. IDUG has outdone themselves with this line up.
I may look at taking one of the classes on Monday. Just depends on how my writing projects are going and if they have any available spaces left when I make the determination.
I can't decide on which restaurant to sign up for on the Dine Around evening. Several good choices and I want to have dinner with everyone so I think I'll just have to put a blindfold on and throw darts at the sign up board....you might want to warn your readers to steer clear of the sign up board if they see a crazy lady in great shoes start to put on her blindfold.
May 11, 2010
8:00 K01: DB2 INNOVATION: POWERING INFORMATION WORKLOADS FOR SMARTER IT
10:00 S02: DB2 FOR LINUX, UNIX AND WINDOWS - TRENDS AND DIRECTIONS
12:30 D01: CAPITALIZING On DB2 LUW V9.7 Capabilities - A Data Management Feature Presentation
1:45 D02: Varsity SQL for the Busy DBA
3:00 C03: Enabling Oracle Applications on DB2 - an Early User Experience
4:15 D04: A VISUAL TOUR OF DB2 9.7 SQL AND PL SQL ENHANCEMENTS
May 12, 2010
8:30 C05: An Indepth Technical Look at DB2 pureScale
9:45 D06: DB2 SECURITY – AMMO FROM THE TRENCHES -- Presenting
11:00 D07: UPGRADING DB2 9.7 – BEST PRACTICES AND LESSONS LEARNED
1:30 V05: You Killed the ELEPHANTS but MOSQUITOES are Killing YOU!
2:45 D08: STUFFED WITH GREAT ENHANCEMENTS - DB2 9.7 FIX PACK 1 NEW FEATURES
4:00 I01: Data Privacy, Security and Audit Compliance -- Panel Participant
May 13, 2010
8:30 C09: pureScale - Why It's So Much Better than Oracle RAC
9:45 D10: LOCKING - WHAT LOCKING? CURRENTLY COMMITTED AND OTHER LOCK AVOIDANCE ENHANCEMENTS TO INCREASE PERFORMANCE AND THROUGHPUT
11:00 V10: END-TO-END MONITORING & PROBLEM DETERMINATION WITH OPTIM PERFORMANCE SOLUTION
1:30 D11: ENABLING FROM ORACLE TO DB2 COBRA THE EASY WAY.
2:45 F12: DB2 Back and Recovery - What Do I Really Need to Know?
4:00 I05: DB2 FOR LUW - HIGH AVAILABILITY & DISASTER RECOVERY
May 14, 2010
8:30 E13: All the FREE Things you can Do with Data Studio
9:45 E14: Diagnosing & Curing? Lock, Wait and Performance Bottlenecks
11:00 B15: Auditing options on DB2 for z./OS (Moderator)
Thanks Rebecca! I wish I was going so I could attend all these amazing sessions with you!
If you missed my posts in the past week, here's the rest of the IDUG coverage that you can find:
The educational seminars
are taking place that on Monday, May 10. Be sure to check out the offerings.
Check out the bookstore that will be onsite where you can purchase the book that Rebecca wrote:
We now have more than 2000 members of the ChannelDB2.com site
! Are you one? I am... and I have joined many of the groups, created some groups and discussions. If you're not a member yet... take a look and consider joining.
What is ChannelDB2?
It is a social networking site that collects people who are interested in IBM's database technologies. Members can build a network of "friends" as you can do on most social networking sites. What is unique is that there is an aggregate feed of a bunch of bloggers... so this is an easy way to keep up with all the latest news. There are videos, papers, presentations, photos, and free books that can be accessed from this site. Really it is the most complete collection of DB2-related content.
There are groups for niche groups. You can even create a group if you have a niche that you'd like to communicate with. I've noticed that the site is heavily used by students around the world who are trying to learn DB2, get certified on DB2, and perhaps looking for work too.
The group that I take part in the most often is DB2 in Books
. Given that my job is to get books published, it isn't surprising that this is my group. I've invited every author who I've worked with to also join the group so you can interact directly with me or authors via this group.
Colleagues on my team run the certification, education, tutorials, and Redbooks programs as well, so I try to relay to you the information that I get from my team so that you are aware of the latest news as it happens.
I'm also actively working on the My developerWorks site to add content where needed. Right now there may be duplication between My developerWorks and ChannelDB2... but I'm sure that eventually one of these will become more prominent.
One question for you ... I'm happy to see that there are more than 2000 members to the site, but not many people have joined a group. I wonder why? If you are a member of a group you can take part in discussions and can control the amount of information you get back from the other group members.
So, if you aren't a member, I hope you check it out... and join: ChannelDB2.com
And join a group! Specifically, join my group: DB2 in Books
and add me as your friend!
See you on ChannelDB2
I missed last week’s show due to vacation and thank Cristian Molaro for filling in for me. I haven't had a chance to watch the replay yet. If you’re in the same situation, you can find all the replays on the DB2Night Show Blog.
Today we heard from 8 contestants on a variety of topics. If you are thinking of creating a presentation, I highly recommend that you watch what these people do as they are becoming quite expert at showcasing technical information.
Here is a brief description of today’s show:
Mary – db2move
Loved her photos of elephants. Very well organized presentation.
Momi – The Report Utility for DB2 for z/OS
The usability for this function has improved in V10, but the function is still necessary.
Norberto – DB2TOP Tips
Tips for using DB2TOP to find out what’s going on in your database. I was really impressed with how Norberto explained a very complex screen capture. As he was going through each concept, he would highlight the corresponding text on the screen. I highly recommend using this technique during presentations as well as written documents. This is exactly how a complex diagram should be explained.
JB – DB2dart Techniques
JB has a knack for telling a good story. She lead listeners through her presentation via a story of how she was able to reclaim much space & improve performance. If you are looking to improve your presentations or writing in this area, pay close attention to how JB does it. I told her that she’d make an excellent author given this skill.
Raja – DB2Advise Utility
We couldn’t find Raja, so unfortunately had to miss his presentation.
Ahmad – db2look
Ahmad presented his experience in using the db2look command and as a result gave very creative uses for the command. The only thing that could have improved his presentation is with a comparison of using db2look vs the traditional method.
Thiru – db2caem tool for performance analysis
This is a very new command, from V9.7. caem stands for “Capture Activity Event Monitor” and this tool is used to capture activities with details of SQL Statements. I like the way Thiru compared traditional monitoring to using db2caem to monitor.
John – Db2look for z/OS with Federated Tables
Although Ahmad’s presentation was on the same topic, John’s was regarding the DB2 for z/OS version of the tool. I like the way John referred to Ahmad’s presentation where he could. John asked if “IBM was listening” as he had an option he’d like to see added to the command. I was listening, but I’m sure there were others who are more influential than me!
Bob – db2dart techniques
This presentation covered the same topic as JB covered , but from the perspective John’s experience. He wanted to reduce wasted disk space and the size of his backup. He gave the steps he used and marked up his presentation as he spoke to lead people through the data.
Only 8 finalists go to March 18 Finals, so we had to choose between Bob and John as they received the lowest number of votes. I can’t understand why either of these guys were at the bottom as both had very strong presentations this week. The audience asked that we save John, and the judges wanted to as well, but there was a leaning towards Bob…. so Bob it is.
Thanks very much to all contestants. I find this forum to be amazing for the learning and fun experience. I’ve seen some of the comments that were given by voters and see that they agree. I’ll go through the data and blog again. Can’t wait till next week’s show!
IBM Press Earth Day Sale
Save 50% on eBooks with Coupon EDIBM
You don't necessarily need paper products to learn—step into electronic
learning with digital products from IBMPressbooks.com. From eBooks to
online-only content, we have a wide range of environmentally-friendly options
that provide the answers you are looking for, without the paper. And now you can
save when you stock up—buy any 2 eligible eBooks, and save 50% with coupon
EDIBM. Offer valid through 04/24/2012. Start
Need some suggestions? Here’s what I’d recommend: