Earlier this year I wrote a blog entry entitled Year of the e-Book. Indeed it has been a very popular year for people trying or switching to ebooks. In the recently published article Top Trends of 2010: Growth of eBooks & eReaders, author Richard MacManus states that “eBook sales almost doubled over 2010 and now make up 9% of total consumer book sales”.
Although this is significant, there is still a long way to go before ebooks become widely accepted. I’ve owned my Kindle for a year now and my son has a Sony, so from personal experience, two bookworms from different generations were able to make the switch and love the experience. When I ask people if they’ve considered one of the ebook readers, they tell me that they would never be able to give up the feel of an actual book in their hands. My answer to this is that most of us have converted from snail mail to email, so the conversion from printed books to ebooks will happen eventually, but it will need people to first step outside their comfort zone.
One of the things I really liked about Richard’s article was his comparison between printed books and ebooks. I’ve copied his pros & cons here to add my own opinions:
5 Ways That eBooks Are Better Than Paper Books
1. Social Highlighting
3. Look-up of words
4. Ability to Tweet & Facebook quotes
I’ve used all of these features on my kindle, but would like to add that my favourite features are 1) the ability to get sample books. When I’m out with people and we’re discussing books that we recommend, I can easily build a wish list of books by getting sample chapters for free from amazon.com. On a recent vacation, I read 5 of the samples that I had recently downloaded and decided that 4 of the 5 were books that I was interested in reading further. 2) The price of a new release in kindle format is much cheaper than the hardcover. Along with this is the weight. My wrists hurt when reading those heavy hard cover books! So now I don’t need to wait for the paperback or trade version of the book, I can read it inexpensively and weightlessly on my kindle!
5 Ways That Paper Books Are Better Than eBooks
5. Second-hand books
I still share books with others… mostly other people lending me their printed books. I will still pick up used books when I see one that I’d like to read. But for me, most of the books I’ll buy it the future will be gifts or keepsakes. At the IOD conference I was able to get books signed by the authors. Even though I already owned e-versions of these books, I purchased the printed copies to get their signature. I purchased a few as gifts as well. One guy had the Freakonomics authors sign his Kindle in permanent marker!!
There are so many choices for e-readers now and the prices appear to be dropping, so I presume many people will be getting these as gifts this Christmas. If you do get one, step outside your comfort zone and give it an honest try. You might learn that you like it… like I did!
How about technical books? Well, I’ve noticed that some of the kindle sample books for technical books are not perfect yet. One book I downloaded, I ended up with only the Front Matter. I guess looking at the TOC is important, but I wanted to see what the chapters and diagrams looked like. I contacted the publisher to suggest that they fix this.
Not all publishers have put their books in Kindle format. There are still issues that need to be worked through with the profits and graphics quality. The ipad fixes the graphics quality… so that might make technical ebooks more accepted.
From my perspective, all of our books are in electronic format. Really if you think about it, IBM has been a leader in electronic formats for information. IBM Redbooks have been a major source of high quality content for forty years now. Product documentation with IBM products such as DB2 has been delivered in electronic format through the Information Center or online help for more than 10 years now. Our published books are made available in Books 24x7 and Safari Books Online which are electronic book libraries. IBM subscribes to Books 24x7 meaning that all IBM employees can access published books electronically, at no charge. All IBM Press books and all of our Certification Study Guides are available in Kindle format as well as epub format that can be used on any e-reading device.
Check out another blog entry I wrote entitled “The Mainstreaming of e-Books” that gives a bit more information about some of the e-readers. Also check out my blog entry from yesterday “DB2 on Campus Book Series” which is a set of books that are only available in electronic format.
As a follow-on to yesterday's blog entry The Year of Change
, I'd like to point out some additional resources in the areas of high availability and pureXML:High availability High Availability Feature in DB2 9 for Linux UNIX and Windows
This Web site lists the main features of DB2 which include high availability High Availability Guide for DB2
(Book)This book provides an easy-to-read, illustrated way to learn about high availability concepts and configuration. However, it does not provide much information about high availability of clusters. High Availability and Scalability Guide for DB2 on Linux, UNIX, and Windows
(IBM Redbooks, html and pdf)This guide provides an in-depth and detailed analysis of DB2 high availability features, including high availability for clusters. This book describes DB2 UDB Version 8.2 and therefore does not showcase the many improvements made in DB2 9 to simplify configuration. DB2 9 DBA exam 731 prep, Part 6: High availability: Backup and recovery
(Tutorial)This tutorial is part of the educational materials related to high availability that are part of DB2 certification education materials. It provides a concise summary of the key benefits and uses of the backup and restore utilities. DB2 9 DBA exam 731 prep, Part 7: High availability: Split mirroring and HADR
(Tutorial)This tutorial is part of the educational materials related to high availability that are part of DB2 certification education materials. It provides a concise summary of how to implement a split mirroring implementation.pureXML DB2 pureXML technology
(Product Web site)This is the main DB2 product Web site for pureXML. Information Management and XML technology developerWorks domain
(IBM community Web site)This is the main developerWorks Web site from which you can access articles, online tutorials, and other technical resources about DB2 and XML standards and technologies. IBM DB2 9 pureXML Guide
(IBM Redbooks, html and pdf)This IBM Redbooks publication describes the pureXML data store, hybrid database design, and administration. It explains what XML schemas are, how to use industry standards to implement them, and how to manage XML schemas. It covers how to use SQL/XML, XQuery, and XPath for querying XML data by providing easy-to-understand examples and how to use XML technology efficiently in business applications. Get started with XPath
(Tutorial)This tutorial introduces the W3C standard XPath Version 1.0. This tutorial is intended for people who do not know XPath or who want a refresher. If you plan to use XSLT, you should take this tutorial first. You will learn what XPath is, what the syntax and semantics of the XPath language are, how to use XPath location paths, how to use XPath expressions, how to use XPath functions, and how XPath relates to XSLT. DB2 9: pureXML Overview and Fast Start
by Cynthia Saracco
, Don Chamberlin
, Rav Ahuja
(IBM Redbooks, html and pdf)This IBM Redbooks publication provides a concise introduction to pureXML, with short, precise examples and explanations that provide a distilled version of the knowledge essential to start working with pureXML. This book is a compilation of many of the IBM published articles on pureXML. Native XML support in DB2
(White paper, pdf)This white paper provides a technical overview of XML support in DB2 products. It explains how XML data has been stored in relational database systems in the past using data type mappings and explains the limitations of these approaches. It then introduces the concept of pureXML and what it means for XML data to be stored natively within a database. It explains the benefits of this approach and how this implementation can be complemented with features such as XML indexes, a full XQuery language, SQL/XML, XML schema support, and utilities that support the bulk loading of XML data. pureXML in DB2 9: Which way to query your XML data?
(Article)This intermediate-level article discusses DB2 pureXML support and compares the two methods by which you can query XML data in a DB2 database: SQL/XML and XQuery. By providing examples, this article explains the relationship between these two query access language syntaxes, the circumstances in which each method is preferred, the benefits of using each independently, and the use of them together to perform more complex queries. pureXML wiki
(Wiki)This Web site contains links to numerous articles, demos, webcasts, and other information about DB2 pureXML published by IBM and other parties Alphaworks DB2 pureXML download and demo site
(Download)This Web site contains industry-specific DB2 pureXML software offerings and resources. DeveloperWorks DB2 pureXML forum
(Forum)This DeveloperWorks forum is one of the fastest ways to get any pureXML questions answered.
Thanks to Farzana Anwar
for pulling this list together!
This morning I received a note from Leon Katsnelson saying that ChannelDB2.com was just shy of its 3000th member! I just checked the site and we are still 3 people short of this number... but I'm sure we'll reach it soon.
Are you a member? I've blogged several times about this site, so I'm sure if you've read my blog in the past, you've heard about this site, and perhaps have joined. If not....consider joining so you can take part in ChannelDB2.com - THE social network for the DB2 community!
If you are a member, you likely already know about the great information and resources that are available to you... including content for DB2 on Linux, UNIX, Windows, System z, and System i:
Did you also know that there are 79 groups that you are encouraged to join! The topics range from country-related groups, to certification prep groups, to conference groups. All the groups are open for you to add comments and discussions, but also provide you with targeted information that will surely be very beneficial!
So, join ChannelDB2.com if you aren't currently a member, and if you are a member, get the most from this active social network by joining and participating in the groups.
The groups that I have created (and highly recommend) is DB2 in Books. I'm also a member of the following groups:
- IDUG Europe 2009
- DB2 9 Fundamentals Certification Workshop
- DB2 for z/OS - What's On !
- DB2 in Canada
- DB2 for Linux, UNIX, Windows
- DB2 for z/OS
- DB2 pureXML
I look forward to seeing you join as a member of one of these groups or more!
The next Chat with the Lab session will
focus on DB2 pureScale:
DB2 pureScale - Always-on, Elastic Database
Date: Tue, August 31, 2010
Time: 11:30 AM - 1:00 PM Eastern
10:30 AM Central / 8:30 AM Pacific / 16:30hrs London /
17:30hrs Frankfurt, Paris / India 9 PM
Speakers: Sal Vella (IBM),
Drew Bradstock (IBM)
Host: Rav Ahuja
Last year IBM released DB2 pureScale, an integrated database cluster solution
that provides continuous data availability, virtually unlimited capacity,
elastic scalability, and all this with easy setup and management but without
requiring any applications changes. IBM has recently updated DB2 pureScale and
announced that it will now also be available to run on Intel-based commodity
hardware and Linux. In this webcast we will cover various DB2 pureScale related
topics including: architecture, benefits, demos, experiences, and getting
To learn more and get your questions answered, join Sal Vella (VP,
Development), and Drew
Bradstock (Product Manager) on Tuesday August
31, 2010 at 11:30 AM Eastern.
Presentation charts for this Chat will be available for download from
ibm.com/db2/labchats 1-2 days prior to the event.
To register and receive instructions for attending this webinar,
point your browser to:
If you are attending the IBM Information on Demand conference this October,
you are eligible to pick up the latest Flashbook about DB2:
DB2 pureScale: Risk Free Agile Scaling
by Paul Zikopoulos, Matthew Huras, Paul Awad, and Aamer Sachedina
This succinct guide will show you how DB2 with pureScale can provide you
transparent application scalability, the ability to deliver agile-like computing
to your transaction systems, and extreme availability.
Also check out these sites for details about DB2 pureScale:
DB2 pureScale Unlimited capacity with continuous availability
A Technology Preview
pureScale: Scaling Databases without Limits
DB2 pureScale - Always-on, Elastic Database
Cluster – **NEW**
Application Scaling with IBM DB2 pureScale
databases size does matter: introducing DB2 pureScale
unveils DB2 pureScale on IBM Power Systems
pureScale Technology Redefines Transaction Processing Economics
DB2 pureScale to Eliminate Over-Provisioning of Database Software
As always, if you think I’ve missed something… let me know. I’ll be happy to
promote any resource related to this new technology.
Modified on by svisser1
DB2 for Linux, UNIX and Windows 10.5 with new BLU Acceleration
Technical Immersion Workshop
Fees: No Charge
Date: Friday, May 3, 2013
Hours: 8 AM to 2 PM
Presenters: Chris Eaton, Danny Arnold and Eric Alton
IBM is sponsoring a technical DB2 workshop at the upcoming IDUG DB2 Tech Conference in Orlando, Florida. Taught by IBM DB2 technical experts Chris Eaton, Danny Arnold and Eric Alton, this workshop covers key features from the recently announced DB2 10.5 with BLU Acceleration as well as the compression features of DB2 10.1 as previously announced.
This FREE technical workshop is an ideal way to extend your technical skills to include the best capabilities of DB2 for Linux, UNIX and Windows. Specifically:
DB2 10.5 with BLU Acceleration - This hot new technology helps deliver decision-making information to your organization with precision that is termed “speed of thought” analytics. We’ll explain how BLU Acceleration implements new column organized tables and how compression works on these tables along with other new processing techniques to deliver superior performance for analytic workloads.
New improvements in DB2 pureScale that handle maintenance and capacity expansion needs more easily—plus new integration with HADR capabilities to support always available transactions.
SQL and Oracle Database compatibility enhancements added in DB2 10.5
DB2 compression technologies introduced in DB2 10.1 that offer key advantages in managing and better utilizing costly storage resources.
And of course there will be time for your questions and active discussion with these DB2 experts. Don’t miss what is sure to be a lively session. It is an excellent opportunity to update your knowledge of DB2 for LUW and the techniques that are increasingly required in a Big Data world.
If you are planning to attend the conference, make your travel arrangements so you can take advantage of this workshop. If you cannot attend the IDUG conference, you can still attend the workshop only at no charge.
Full details and registration. Register soon, as space is limited and filling quickly.
Have you ever been to a DB2 Symposium? They are quite different than
a normal conference since they provide 3 full days of learning. This one takes
place in Chicago from October 16-18 and provides three-days of training with
three parallel tracks.
Each day there are three one day seminars presented by industry leading
consultants. You may join for 3, 2 or just 1 day(s), depending on your needs
There are nine great sessions lined up with award-winning speakers:
- Bonnie Baker
- Susan Lawson
- Craig Mullins
- Cristian Molaro
- Klaas Brant
Tuesday 16 October
Wednesday 17 October
Thursday 18 October
October 16-18, 2012 – Chicago DB2 Symposium
- Location: Downers Grove – Chicago, IL
For further information, use the menu on the left hand side of the DB2 Symposium webpage where you
can navigate to the sessions, pricing, location and more.
Thanks to Klaas Brant, KBCE – DB2 Symposium Organizer, for
providing me with this information.
Modified on by svisser1
Congratulations to Jacques Roy for the completion of his latest book:
The Power of Now
Real-Time Analytics and IBM InfoSphere Streams
This book will launch at the IBM Insight conference in Las Vegas. You can get a free book and have it signed by Jacques if you are an attendee of the conference. Jacques will be signing the books at the IBM Insight Conference Bookstore on Tuesday October 28 from 9:30 – 10:30 am. There are only a limited number of copies at the conference, so if this is a book you want, you should make sure you put the day and time in your schedule.
What’s the book about? It is about the really great product from IBM called InfoSphere Streams. I attended a few tweetchats in the past year and was happy to see the number of people who mentioned this product and the value it brings to them as they analyze data-in-motion. InfoSphere Streams is the world’s fastest and most flexible platform for streaming data. Sounds interesting, doesn’t it!
I was asked to help write the content for the covers of this book and read several chapters of the book and I find the topic quite interesting. Here is what we put on the cover of the book:
Read this book to:
Understand how the integration of multiple technologies form a big data architecture that can process data, both at rest and in motion
Learn how real-time distributed analytics can provide insights to create a business advantage and currently unseen opportunities
Discover the ways to implement a data-in-motion solution that works for your environment
Explore the characteristics that make a good real-time distributed analytics platform
Learn understand how to apply InfoSphere Streams technology to your business problems to get solutions faster
IBM InfoSphere Streams provides a new approach to processing information by providing an easy-to-program platform for distributed real-time analytics that can answer the need to generate information from the huge amount of data that comes at businesses rapidly.
In “The Power of Now: Real-Time Analytics and IBM InfoSphere Streams”, discover how distributed real-time analytics can uncover opportunities in your enterprise providing more efficiency and a business advantage. Technology is changing rapidly, and there is so much of it to learn. This book gives you a shortcut to becoming proficient with InfoSphere Streams so that you can dive into implementing a solution for your enterprise.
About the author:
If you’re not going to be at the conference, you’ll still have a chance to get a copy of the book, but in electronic format. I’ll write a new blog entry when the PDF version is available so you can download your free copy.
by Doug Vucevic and Wayne Yaddow
About the book:
quality of a data warehouse (DWH) is the elusive aspect of it, not
because it is hard to achieve [once we agree what it is], but because it
is difficult to describe. We propose the notion that quality is not an
attribute or a feature that a product has to possess, but rather a
relationship between that product and each and every stakeholder. More
specifically, the relationship between the software quality and the
organization that produces the products is explored. Quality of data
that populates the DWH is the main concern of the book, therefore we
propose a definition for data quality as: "fitness to serve each and
every purpose" Methods are proposed throughout the book to help readers
achieve data warehouse quality.
About the authors:
Vucevic: Upon an early retirement from the IBM Development Lab in
Toronto, where he had worked as a software developer, Doug has been
working as an independent consultant to major banks, insurance and
retail companies in Toronto, in the field of Software Engineering.
Doug's consulting assignments have been in leading quality assurance and
testing efforts for: data warehousing, BI and Data Mining in financial,
insurance and retail industries. Doug holds Masters' Degree in
Electronics and Telecommunication and is a member of the Registered
Professional Engineers of the province of Ontario.
Yaddow: Wayne Yaddow has spent more than twenty years developing and
testing operating system code at IBM. During the most recent ten years,
he devoted his time as an IT consultant, conducting QA on data migration
and data integration for large data warehouse projects in the financial
industry. While working as a consultant, he shared his data warehousing
knowledge with many colleagues on the Internet and in work assignments
in New York City.
More blog entries about Data Warehouse:
DB2Night Show, Nov 30: IBM DB2 LUW Data Warehouse & DPF Performance
Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
Largest data warehouse – Guinness World Record
April 30, 2012: GA of Version 10 products: DB2 for LUW and InfoSphere Warehouse
Best Practices: Active Data Warehouse Topology using InfoSphere Warehouse
The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights
Modified on by svisser1
Kevin Spacey, the awesome actor, star of great movies such as “American Beauty” and “The Usual Suspects” and star and producer of the “House of Cards” series is the keynote at the IBM Insight Conference. Does that sound strange to you? I’ve mentioned Kevin’s involvement to a few people and they wondered what an actor has to do with a conference about data??
Lucky for me, I was at an IBM Conference earlier this year and had the opportunity to see Kevin Spacey in action. My point of view: Kevin is brilliant! He apparently met with conference organizers to get an idea of what the main topics of the conference were and built his own speech. He delivered his speech with humour, insight, and with many sound bites. I was one of the people live tweeting during the event and I was thrilled to see the excitement on twitter.
Kevin focused on the way Netflix handled the “House of Cards” series: they analyzed data and realized that political dramas tend to be quite popular. They realized that it often takes more than a single season for a show such as this to find its audience. Audiences will look for inexpensive ways to get great content and often like to binge watch a TV series. What do you think? This sounds right to me, and clearly the success of “The House of Cards” shows that many people agree with the Netflix model.
I must admit that I hadn’t watch “House of Cards” before I saw Kevin’s keynote, but I have since and really like the show. I was a fan of Spacey’s before, but became more of a fan after seeing him at the conference.
I was so impressed with the great tweets that I created a summary via Storify. Check it out: http://bit.ly/SpaceyatImpact I hope this makes you feel like you were there in the audience! I often get to meet guests of the conference, and I hope I’m able to meet Kevin at IBM Insight, but since he’s not an author doing a book signing, the chances are slim.
Remember, Kevin’s keynote takes place Wednesday October 29, 8:15 – 9:30 am. You won’t want to miss it… and I can predict.. the room will be full!
Monday April 25 is the Kickoff
for DB2 for z/OS
shows on the DB2Night Show. As a reader of my blog, by now you know the DB2Night Show and Scott Hayes
very well. Just to be sure, here’s what you need to know about the DB2Night Show:
Scott Hayes of DBI started a series of free webinars in September 2009 with the goals to: Educate, Entertain, and Inform. There have been 48 shows already and 98% of the attendees said that they learned something new from the show. I’ve personally been involved in the past few months as part of the “DB2’s Got Talent” competition and I must say that I was blown away with the quality, variety, and depth of the education provided.
Each episode has a DB2 educational theme and speakers have been IBM experts, top consultants, IBM DB2 Gold Consultants, IBM Information Management Champions, and experienced users.
Klaas Brant of KBCE and organizer of DB2 Symposium Education has decided to turn Mondays into a must attend learning session for people who work with DB2 for z/OS. There are already 5 amazing shows on the schedule with more to come.
Remember, the DB2Night Show is completely free for participants, but there is a limit to how many attendees can attend. Make sure you register immediately so you don’t miss out. Replays will be available following each show.
Here is the current schedule:
The History of DB2
Monday April 25, 2011, 11EDT
The kickoff of the DB2Night Show z/OS Edition features legendary Roger Miller. This event shows much of the history of DB2 with milestones of new versions, new inventions, and showcases some of the people who contributed key inventions and innovations in DB2.
The Future of DB2
Monday May 9, 2011, 11 EDT
Edition #1 was a look at the history of DB2, so it is fitting to have the second show centered around the future of DB2 z/OS. Special guest Jeff Josten will share the latest new with DB2 V10 and will offer his insights into what may be coming in future releases.
DB2 10 Performance
Monday May 16, 2011, 11 EDT
This episode will look at performance in DB2 10. Special guest Cristian Molaro was recently a co-author on a new IBM Redbook about DB2 performance that will publish soon. Cristian will share his hands-on experience with DB2 10 performance during the show.
DB2 10 SQL Enhancements
Monday, May 23, 2011, 11EDT
DB2 10 is packed with new SQL features like temporal data and many others. Join special guest Terry Purcell as he walks us through these great new features and explains how to get the best from them.
DB2 10 Customer Experiences
Monday, June 6, 2011, 11EDT
Many customers are already using DB2 10 in production. Special guest John Campbell will talk about migration planning and share lessons learned from people who have already migrated.
Are you looking for more quality educational ideas? See my previous blog entries:
- FREE – Flashbook “DB2 10 for z/OS - Cost Savings ..... Out of the Box“ available; find out how to get yours: http://bit.ly/fjR4x2
- FREE - Ten new IBM Redbooks that you may be interested in: http://ibm.co/hZDwXV
- FREE - Learn from experts via Best Practice articles for DB2 for z/OS: http://ibm.co/eTXbRd
- FREE – 3 certification exams for attendees of IDUG Tech Conference: http://ibm.co/giLoQA
- IDUG Tech Conference: http://ibm.co/gqaA35
- DB2 for z/OS Events & Resources: http://bit.ly/hZDPbf
Learning is a life-long journey, so take advantage of the outstanding resources that are available for you.
Apparently this is happening to many of our customers. They move from Oracle
to DB2 and achieve improved performance. Could this happen to you as well?
Here are some of the details of this particular case study:
JSC Rietumu Banka achieves faster database performance moving from
Oracle and Sun to IBM DB2 on Power Systems
With the worldwide recession placing pressure on banks to reduce costs, JSC
Rietumu Banka's CIO was concerned with total cost of hardware, software
and administration supporting the company’s online banking
applications. The bank’s web applications ran on Oracle Database and Sun servers
and it found that the annual fees were costly and administration time consuming.
With its migration to IBM DB2 on IBM Power Systems, it
reduced the total cost of ownership for its online banking
infrastructure and dramatically improved query performance and
data availability. On average, user queries are now executed up to 3 times
faster, with some queries completed up to 30 times faster (for
example, some queries that before took 30 seconds now take less than one
second). During the migration process, the bank reported an out-of-the-box
compatibility rate of more than 90 percent.
Thanks to the solution, JSC has:
• Reduced total cost of ownership by
• Achieved 3-30 times faster query performance
Improved data availability by 200 percent
"By migrating to IBM DB2 on IBM Power systems, and using IBM services, we
expect to decrease total cost of ownership for our mobile device banking
applications by 20-30 percent." - Sergey Golubev, Head of IT Maintenance
and Networking Department, JSC Rietumu Banka
To learn more about how JSC Rietumu Banka addressed its business challenges,
read the full case study.
I get the impression that this type of improvement is happening in many
shops. I base this impression on some of the comments that have been expressed
on the DB2Night Show. Has this happened to you as well? Do you want to share
Thanks to Dave Pittman and Paula Williams for providing me with the details
of this case. Watch for a few more that I’ll write about.
Today on the DB2Night Show, host Scott Hayes introduced us to the first 5 contestants on the “DB2 has Talent” competition. Scott tapped fellow IBM Gold Consultants Martin Hubel and Klaas Brant to be judges, as well as me. I must say it was put together very professionally and I think all participants and listeners had fun.
Here’s the lowdown on what we experienced.
First contestant Ramesh presented about db2top. Ramesh was clearly very skilled and passionate on this topic and it showed. Unfortunately for Ramesh, he went first, on the first show, so he was at a big disadvantage. Ramesh included too many slides to cover in the measly 4 minutes that he had available. As a result, we were not able to see his conclusion. There is much interest in the topic, so maybe we’ll have to have Ramesh back with a smaller set of slides.
Contestant two was JB. JB is clearly an experienced presenter since she didn’t sound nervous and she did a fabulous job. Here presentation was about using HADR to migrate low level hardware, OS, and software to more current levels. JB’s experience is something many people can learn from and she did a very nice job of explaining the problem, how she convince the team leads to try her solution and the amazing conclusion.
Mary was the third contestant and she presented on Identity vs Sequence. Mary as well was very comfortable with presenting and with her material. It was laid out very nicely giving the pros and cons of using each. I found her presentation to be very educational.
Norberto was the next contestant and he was from hot Brazil. He chose to present on the DB2Night Show instead of going to the beach, and we thank him for that! Norberto said that he learned English by becoming a DB2 DBA. We all know and love the database, but now we can give it credit for encouraging people to learn and become proficient in English. I really liked the humour that Norberto used in his slides, but Klaas cautioned him on using humour when the audience got really big and diverse. You don’t want to offend people! Norberto gave tips on improving SQL statements. His presentation led us through his journey of having very poorly written code to him debugging it and finally finding a way to improve the code so now it runs in 5 minutes versus the previous 10 HOURS! Way to go!!
The final contestant for today was Rob. Rob clearly reads self-help books, like I do, and chose to do a parody on a famous book by entitling his presentation “The 7 Habits of a Highly Effective DBA”. I thought the presentation showed much promise one of the first pieces of advice was to “not sweat the small stuff”. But Rob got too detailed in explaining the power of the db2diag.log and ran out of time. Rob could have used an entire hour to present his material and it would have been very well done. I hope that Rob is able to boil his material down to 4 minutes and that Scott allows him to redo his presentation… it has real promise. I suggested he write a book… but he could certainly turn this into a presentation that IDUG would be happy to have on it’s conference agenda.
All in all I was very happy meeting the contestants today and working with Scott, Martin and Klaas. In the end we invited 3 of the presenters back for a second presentation of the same material. This will allow them to fine tune their work and show us again. The three who are moving on are Mary, JB, and Norberto. Not to be sexist… but doesn’t that mean that the ladies rule????
If you weren’t able to take part in today’s show because of a conflict, I encourage you to get the replay. There are 3 more episodes like today’s and then the finale for 4 weeks in March. Hope you can join us! Oh, I think Scott is still looking for a few more contestants as well. Join in the fun.
Oh, if you do want to be a contestant, make sure you have headphones with a mic for your computer. Unfortunately there were two other people who we tried to hear from, but they weren’t set up correctly. I hope they are able to try again for one of the other weeks.
A reminder about the other shows in this series:
DB2 Night Show in February & March: DB2'S GOT TALENT CONTEST.
Join us on the following dates:
Feb 11, 2011 11:00 AM - 12:30 AM EST
Feb 18, 2011 11:00 AM - 12:30 AM EST
Feb 25, 2011 11:00 AM - 12:30 AM EST
Mar 4, 2011 11:00 AM - 12:30 AM EST
Mar 11, 2011 11:00 AM - 12:30 AM EST
Mar 18, 2011 11:00 AM - 12:30 AM EDT
Mar 25, 2011 11:00 AM - 12:30 AM EDT
We’re looking for contestants…. are you up for it? Check the site for eligibility. Maybe this will convince you to become a contestant: the prizes!
- 1st Prize: One FREE IDUG Conference Registration to any IDUG Conference in 2011 (North America, Europe, or Australia) provided by IDUG, plus up to $1,500 USD travel expense allowance provided by DBI. Approximate value of prize package: $3,500 USD
- 2nd Prize: Xbox 360 250GB Console with Kinect (approximate value $500) provided by IDUG.
- 3rd Prize: $100 Amazon.com Gift Certificate provided by DBI.
- Finalist Prizes: Each of the top 10 Contestants that are invited by the judges to participate in Finals Shows will win $50 Amazon.com Gift Certificates provided by DBI.
What an exciting week! With Watson winning on Jeopardy, meeting a member of the Watson team, and then today, the 3rd episode of the DB2Night Show’s competition DB2 has talent.
Today’s episode was particularly high quality. I think many of today’s contestants have enough knowledge to write books with very valuable content! Let me tell you about the contestants we met today:
John - “How to Move Data from Mainframe to LUW”
John has 39 years experience using various databases from IBM – IMS, DB2 for z/OS, DB2 for LUW, and maybe even SQL/DS… and his expertise showed. He provided scripts that could actually be used by people who are trying to accomplish what he did. His presentation was easy to follow, gave actual examples as to how he was able to move the data, and he finished in time.
Bob (Robert) – SQL Tuning Tricks – Perils of Using “not in”
OK, we didn’t actually hear from Bob, but we did see the first page of his slides. There were many technical issues with the meeting software today (I know first hand!) so hopefully Bob is able to come back next week. His topic sounds interesting and his first slide was promising. Let’s hear from you Bob!!
Naveen – Improving Database Performance by Choosing the Right Index
Naveen gave a very thorough and relevant presentation on indexing. His figures and cautions made the content very easy to follow. The only criticism is that Naveen failed to tell us that DB2 9.7 takes away the need for much of what he presented.
Ramesh – Determining which Indexes can be dropped
Ramesh was slightly less easy to understand than Naveen, but he did include information about how DB2 9.7 changes the indexing story. It’s too bad that we had back to back presenters discussing nearly the same topic, but that just tells us how important this task is.
Sameer – Optimizing Application Performance with DB2
This was Sameer’s second appearance on the DB2 has Talent competition. He was asked to cut his material down significantly and to re-present. Sameer took the challenge and excelled! His content could fill a book with truly amazing tips along with understandable explanations.
Jefferson – SAP and BufferPools
I’m sorry Jefferson, but I missed part of the title of your presentation. Jefferson gave a very detailed presentation about an important topic. He was able to gather examples that involved a very large amount of data and to demonstrate how to use bufferpools with SAP.
Thiru – Explain from Actuals
I think we all went away from this presentation realizing that Thiru had very nicely demonstrated a very little used stored procedure. It made me realize that there are problem many un-mined functions and features that DB2 offers that are not well known or well used. What an opportunity for future contestants!
Yogesh – Troubleshooting DB2 Work Load Manager
I think the only issue with Yogesh’s presentation was the sheer magnitude of the size of this topic. Yogesh wasn’t quite able to finish his presentation, but did a good job of showing the benefits of using WLM. My suggestion to Yogesh is that his presentation would have been more impactful if they had told a story from beginning to end. The way it was, there was too much time spent on the definition. Brave attempt!
Really this was a very high quality set of presentations and 96% of the attendees said that they learned something new. The tips that we were given were very much worth the price of admission! If you missed this show or the previous two, you can get the replays on the DB2Night Show page.
After much deliberation, we judges, Martin Hubel, Klaas Brant, and myself were able to inform host Scott Hayes that the following contestants should move on to the next round:
John, Sameer, and Thiru
Way to go! We are very much looking forward to seeing you present at the next round.
See also my previous blogs about the DB2 has Talent Competition:
First Episode of “DB2 has Talent”
Second Episode of DB2 has Talent
Yesterday there were so many blog entries regarding the announcement of DB2 9.7 for LUW AND InfoSphere Warehouse 9.7
And... it was Earth Day and apparently my blog was featured on the top page of developerWorks
But, I missed it all! I spent the day with Grant Hutchison
teaching a grade 7 class about investing, saving, and finance: "Junior Achievement - Dollars & Sense
". I've been a volunteer for Junior Achievement for a few years and like the fact that IBM has teamed with Junior Achievement to educate the future generation!
The material is amazing and the kids were very engaged in the new concepts they were learning. JA has ensured that the curriculum is very interactive which is a great way for kids to learn. For example, the last thing we did yesterday was an investment game. Everyone in the room was pumped and enjoying the game! Fun all around!
Speaking of interactive learning
.... I'm going to remind you of two that you should consider:
- DB2 9.7 Overview webcast (Chat with the Lab) on May 6, 11:30 AM ET where people will be able to get additional details about the new release. Be sure to register for this webcast.
- If you or someone you know needs to learn DB2... or if you like to volunteer to teach high school students, you need to check out the DB2 games.IBM DB2 Detective GameGetting started with DB2 9 and SQL can be easy with this new interactive game. Using an crime investigation theme, this introductory level game teaches relational database concepts and shows how technology can be applied to solving real-life problems.IBM DB2 Business GamePut your DB2 and SQL skills to the test with this intermediate level game! Jump into a “run your own business” scenario, where your company’s future depends on a key report needed to secure funds for a critical upgrade. Play the game and you may be ready to transfer your skills into action!
Pass the word by teaching!
IOD EMEA which took place in Rome last week was a huge success. I'm working on my trip report and will post some of it here.
Monday and Tuesday next week, I'll be at the Toronto conference CCDB2UG where the Central Canada DB2 Users Group is celebrating their 25th anniversary! I'm quite looking forward to my annual visit with some of the most amazing people I've ever met. For more information, see this blog entry I did recently: Local Conference - Central Canada User Group.
I've already began planning for our huge IOD event that will take place in Vegas the last week of October. I'm looking forward to see the sessions and speakers who have been chosen for the event. The bookstore is arranged already, so just the signings are left to plan. I'm hoping this year that we have the book signing events included in the agenda builder so you won't miss what the signings that you want to attend. More on this conference coming up.
I've talked to a few people about the IDUG conference that is taking place in Vienna the second week of November. I'm not sure what my involvement will be at this point, but it would be a nice one to attend, don't you think?
There are many free webinars that are coming up soon... I hope you are able to take advantage of the amazing content that is available to you for free! I know time is always a factor, but most of the webinars are recorded so you can benefit from the content after the fact.
My favourite ones are:
1) DB2Night Show
- tomorrow is Sam Lightstone
, and there are several more speakers planned for the coming weeks.
2) Chat with the Lab - there was an event today, but you can keep on top of the scheduled and recorded events by joining this group: Channel DB2 Chat with the Lab
3) Surekha Parekh
does a fine job of informing the world of the events surrounding DB2 for z/OS. I strongly suggest that you join one of the groups that she posts to in order to stay on top of what's happening. The World of DB2 for z/OS
is one of the places she updates regularly.