Keep on Learning
IBM Press Memorial Day Sale: Save 50% on purchase of 2 books with Coupon MEMDAYIBM
Warp Speed, Time Travel, Big Data, and more
DB2 10 for Linux, Unix and Window New Features
Last week at the IDUG Conference, we handed out 250 copies of this new Flashbook to attendees. It was fun & exciting. Here’s a photo:
What an awesome group of authors on this book: Paul Zikopoulos, Walid Rjaibi, George Baklarz, Matt Huras, Matthias Nicola, Dale McInnis, and Leon Katsnelson. Can you imagine a stronger author team!
Here are a couple of details about the book:
Warp Speed, Time Travel, Big Data, and more
DB2 10 for Linux, Unix and Window New Features
Save Time and Money with DB2 10 for LUW
Even travel through time and shrink data
How would you like to compress data, store it in a cloud, and analyze your data as though you are traveling through time? Do all this, plus experience lower costs and faster performance. Sound good? Read this book to understand the power of DB2 10 and get started immediately!
This book provides you with the comprehensive knowledge you need to get started with the latest DB2 release. Try the new features by downloading DB2 Express-C - it is free to develop, deploy, and distribute (with no user and database size limitations) and features Big Data and Cloud technology. Go to ibm.com/db2/express.
Technical editor: Roman B. Melnyk
Here are a few other blog entries about this impressive release:
Over the years, DB2 has become more compatible to Oracle, thus making it much easier for people skilled on Oracle to move to DB2 jobs as well as much easier for companies to switch their Oracle databases and applications that rely on Oracle databases.
With DB2 10 for Linux, UNIX, and Windows, you’ll find the PL/SQL Compatibility features and other enhancements make it even easier for you to switch.
Learn about why and how to switch by joining this latest DB2 Tech Talk that takes place on May 31:
Date: Thursday, May 31, 2012
Time: 11:30 – 1:00 pm EDT
Speaker: Serge Rielau, SQL Architect for DB2 for LUW
This webcast will discuss:
If you are serious about switching to DB2 from Oracle, here are some other resources for you to consider:
Join host Scott Hayes and special guest Maria Schwenger from IBM for a free 90-minute episode of “The DB2Night Show”. The topic is “Crucial things you want to know as a DBA to manage a pureScale system” and Maria will share her opinions and insights.
Date: Friday, May 25, 2012
Time: 11-12:30 EDT
Do you know Maria yet? Here’s more about her:
In the last 3 years, Maria specialized in architecture and implementation of active-active high availability database solutions utilizing DB2 pureScale feature. Currently, Maria works with customers on adoption of PureApplication System as part of the newest IBM offering of Expert Integrated Systems. Maria has over 15 years experience in performance engineering, database architecture, administration and development on DB2, Oracle and MS SQL server as well as extensive experience in migration from legacy systems to relational databases. She is an author of articles, presentations, tutorials, and IBM Redbook about DB2 9.7 SQL Compatibility feature and DB2 pureScale.
After attending this talk, you’ll be happy that you “met” Maria!
PS… I’m posting this information rather late (ie.. the day before), so if you read this after the webinar date, don’t worry. Scott records all these talks and you can find them on his site.
If pureScale is your thing… check out the Flashbook that you can download for free.
I am looking forward to going to Denver this weekend in preparation of IDUG NA which starts on Monday, May 14. I’m hoping to blog and tweet from there, so regardless if you are at the conference or not, you can follow what’s going on. Here are some key links:
IDUG’s Facebook page will also be pretty busy during the conference too: www.facebook.com/IDUGDB2
More information about this year’s IDUG Conference:
On Tuesday in the Exhibit Hall, we'll be handing out a limited supply of signed copies of the New Flashbook for DB2 10. For those of you not at the conference, follow my blog for information on how you can download a copy for free.
Two other books will be launching at IDUG this year. We don’t have a bookstore, but be sure to speak to the authors for information on ordering a copy for yourself at a discount offered to IDUG attendees:
The winner of this year’s DB2’s Got Talent competition was Kohli (We HAVE a winner! DB2’s Got Talent Competition) and he chose to attend IDUG Denver as his prize. I’m looking forward to meeting Kohli. If you were also a competitor, please find me at the show and introduce yourself.
If you’re interested in writing articles or books, or reviewing any of the upcoming books… also find me and let me know. I may have some interesting opportunities for you!
The web is wonderful, but the web is evil! Wonderful because it contains so much content and evil because it contains so much content! It can be overwhelming to navigate through the content and if you don’t immediately find what you’re looking for, it is very easy to get distracted and forget what you were looking for in the first place.
My intention for this blog entry is to help those who use the DB2 for z/OS products find skills resources that are specific to you. I hope you find this content helpful!
IBM Data Management Magazine
The next generation of IBM Data Management magazine is available for you to read online. It has many great articles, including regular columns by Bonnie Baker and Robert Catterall.
Version 10 books:
So far, two books have published to support DB2 V10… but there are more coming.
Version 9 books:
Version 9 is still being used by many, so you may find this book useful as well:
“Flashbooks” are small-sized books that have fewer than 150 pages, and have easy-to-read messages about products, solutions, or technology. Flashbooks are published to coincide with conferences such as IBM’s Information on Demand Conference or IDUG. The huge quantity of messages and content delivered at such conferences makes it difficult for attendees to retain all the key messages. Flashbooks are designed to contain the key messages IBM experts want you to take away with you.
Flashbooks are handed out in print format at conferences and other events, are available for free in ebook format from this site and can be purchased from amazon.com or other online bookstores.
The ITSO is always busy creating technical publications to help you deepen your knowledge and get hands on skills with IBM’s Information Management products. Here are a few you may wish to look at:
10 for z/OS Technical Overview
10 for z/OS Performance Topics
Find many more on the IBM Redbooks Website.
IDUG NA 2012 – taking place May 14-18 in Denver Colorado:
The IDUG conference taking place in Denver Colorado, May 14 – 18. This is possibly the third time that the conference is in this location. It is an attendee favourite for many reasons, including micro brew pubs, scenery, great city – good vibe, restaurants, and ease for many people to get there.
For details, see this link:
The following topics are Select from these topics:
DB2 10 for z/OS DBA Certification Crammer Course: Susan Lawson,
Recommended Best Practices from Customer DB2 Health Check Studies:
John Campbell, IBM DB2 for z/OS Development
I Didn't Know DB2 did THAT!: Bonnie Baker, Bonnie Baker
Certification for DB2 is the MOST popular certification program in IBM! Not everyone who uses DB2 is IBM Certified yet, but the version 10 exams are available and is a great place for you to jump on board. Here is an offer for getting certified for half price as well as some information on how to started on your path to getting certified:
The DB2 for z/OS community is heavily into blogs. I’ve had the pleasure to work with Willie Favero and Surekha Parekh on presentations about social media. Here are some of the bloggers you may wish to follow:
My apologies if I missed your blog! Drop me a line and I’ll make amends :)
Suggestion… check out who these people are following. That will give you suggestions as to who else you may wish to follow.
Communities are a way for you to participate in conversations with other like minded people. You’ll find lots of resources, news about events, and perhaps access to experts.
Is there More?
Yes, there is more. Much more. I didn’t even begin to cover the courses offered by IBM Education. I hope what I have provided is helpful and I’ll update this page when I have more to add.
I like to believe that we all “have a book in us”. I’ve written two books and found it hard work, but very gratifying to accomplish such a feat. I know many authors and most feel the same way. You can tell by looking at how many people become repeat authors!
Maybe not everyone can write a book, but for those who have an interest, consider writing an article for starters. Many people come to me with ideas for articles and books and I’ve helped people get published in many places. Most recently I’ve worked with Dan Gibson for him to write a series of articles for either IBM DataMagazine or developerWorks. I’ve also worked with a few people from the DB2 Night Show “DB2’s Got Talent” competition to have them mentored by Roger Sanders in the hopes of publishing in these places.
Why write? It’s a lot of work, and not always much money… so why do it? Personal gratification will be the number one success factor in completing a book. Close behind is the recognition you’ll receive as being a leader in the technology you write about. It’s not always easy to build a reputation as a leader when all your peers are equally talented, but if you write, you will be a step ahead and therefore will be seen as a leader. Sharing is another big reason. We hear a lot today about sharing and collaborating and if you think about it… information locked up in your brain alone will not help much with the progression of ideas through collaboration. So, share… you’ll credit the credit you deserve for your expertise and you’ll perhaps inspire someone to make a ground-breaking invention.
Here are some of the recent articles that I’ve been able to help with in a very tiny way. Congratulations to these and all authors for a job well done!
Using row and column security to provide country- and region-specific views of data and correct currency aggregation
by Dan Gibson
by Jeyabarathi (JB) Chakrapani
Concurrent I/O is a feature that was introduced in UNIX® and Linux® platforms mainly for the benefit of relational database systems. This article explains the difference between the I/O mechanisms available with UNIX and Linux file systems, and shows how concurrent I/O technology can be leveraged in an IBM® DB2® environment to improve database performance.
by Sunil Soares
Sunil is also writing a book about this topic.
Are you ready to share your knowledge and experience? I hope so! And here’s an easy way to get started:
I highly recommend the book “From Idea to Print” by Roger Sanders. Roger does a fine job of explaining every aspect of creating and publishing both articles and books. And Roger has the experience to write such a book. At last count, he’s written 23 books and is working on at least one more. I have lost count of the number of articles he’s published, but it must be in the hundreds by now. I liked all the chapters in this book, but most like the chapter about deciphering the author contract. I’ve never seen such a thorough description of each and every one of the clauses that an author sees. And the description is understandable and not in legalese.
Other chapters that make the book worth reading include how to avoid procrastination, how to edit your manuscript, and how to organize your work. If you are even remotely thinking of writing, then you should read this book. You’ll be very happy you read it.
Roger is still looking to mentor a few people, so if you are truly interested in going the next step, let me know and I’ll make the connections.
I hope you’re taking part in some of the learning opportunities available now that DB2 10 & InfoSphere Warehouse 10 have released. Check out my blog from yesterday about all kinds of options: April 30, 2012: GA of Version 10 products: DB2 for LUW and InfoSphere Warehouse.
Today I want to expand on a couple of webinars that I mention in that post. First off, the DB2 Night Show. Last Friday, May 4, host Scott Hayes invited IBMers Danny Arnold and Glen Sheffeld to talk about the latest release: DB2 LUW 10.1! STOGROUPS, WLM, RCAC, and More. If you missed it, be sure to watch the replay. Replays available in WMV and M4V formats.
There is so much to talk about that this was just part 1, and was a deep dive into What's New in DB2 LUW V10. Storage Groups, Workload Manager Enhancements, and Row and Column Access Controls were covered, and many example SQL commands were shared to illustrate the concepts.
According to Scott’s website, 100% of the audience learned something new! “Danny and Glen were terrific guests. I appreciated all of the SQL and command examples that they shared while discussing STOGROUPS, WLM Enhancements, and RCAC. Their presentations offered significant technical depth - this wasn't just a DB2 10 marketing pitch. I am delighted that 100% of our studio audience indicated that they learned something.”
Register now for Part 2: Episode #81 will discuss DB2 10 compression enhancements, HADR, time travel queries, index jump scans, zigzag joins, and more. Special guests from IBM share breaking news about vNext. Part 2 of 2. This will be a 90 minute show. Yes, there is A LOT to talk about.
Secondly, The DB2 Tech Talk Series, hosted by Serge Rielau. The next show, DB2 Tech Talk: Optimizing Storage Utilization for DB2 10 , takes place May 11, 12:30 EST to 2PM EST.
Learn about the new storage optimization features in the newly available DB2 10 product.
We will cover three areas including:
This technical tour is the second DB2 Tech Talk on the DB2
10 and InfoSphere Warehouse 10 product releases.
The first of the series was DB2 Tech Talk: Technical Tour of New DB2 10 and InfoSphere Warehouse 10, which took place April 26. Watch the replay. Serge Rielau, Conor O’Mahony, and Cindy Fung took you on a tour of DB2 10 & InfoSphere Warehouse 10.
Mark your calendar for the 3rd in the series, DB2 Tech Talk: Oracle Database and SQL/PL Compatibility, which takes place on May 31.
See also my other blog entries about DB2 10 and InfoSphere Warehouse 10:
Yesterday was the day that DB2 10 and InfoSphere Warehouse 10 were made available to purchase. The products were announced on April 2, so I’m sure you’ve seen some of the buzz surrounding this outstanding accomplishment.
On a personal side, my desk in the office is in the middle of the Release Team who managed these releases. It has been an exciting and busy time for all those involved and a huge congratulations go their way for all their hard work! We had a brief celebration in the lab as well and I learned many interesting facts:
So the developers are moving on to their next thing, but the Db2 10 work doesn’t end here! Now those who create courses, exams, books, webinars, articles, and events are working towards providing you what you need to move to this product and to use if effectively.
Here’s my blog entry about what’s in the release and what IBM Champions are saying about it:
As for education, if you are attending IDUG later this month, you’ll have plenty of learning opportunities:
PLUS, we're launching DB2 10 Flashbook at IDUG: New Flashbook for DB2 10 – Launching at IDUG Denver
If you aren’t attending IDUG, don’t worry! Here’s what I can suggest for you:
Watch the Replay of these webinars:
Schedule to attend these upcoming webinars:
There are many blog entries already posted and many more coming. I highly suggest you:
Chris Eaton of IBM created a great video about “why you should consider migrating from Oracle to DB2”
and I found this article/slideshow on eweek.com: Database: IBM Databases: Top 10 Innovations of the Past 50 Years by Darryl K. Taft
As usual, developerWorks is publishing new content on a daily basis to support this release. Here are just a few of the items you’ll be able to find:
Bookmark this developerWorks page to see articles as they are published: ibm.com/developerworks/data/
And last but not least, IBM Data Management Magazine has a whole series of articles and columns planned to keep you reading. Make sure you check back frequently for new content.
What do you think? What a great amount of content for you to explore … and DB2 10 was just released YESTERDAY! Keep learning!
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 technical content.
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.