Keep on Learning
svisser1 2700018UK9 Tags:  books games webinars courses career expert certification 8,614 Views
On Monday and Tuesday this week, the CCDB2UG conference was held in Markham, ON. I was very happy to be invited to take part in a very small way to speak to attendees during the reception and to network with people following the reception.
I handed out my business card to everyone who I met in the hopes that they will become readers of my blog. I hope one or two of you are people I met in person on Monday!
The message that I delivered to the attendees was that our Education and Skills team are dedicated to provide resources to people who want to gain skills on DB2 and other IM products. We have self study courses, books, ebooks, redbooks, conferences, webinars, traditional courses, ILO courses, certification programs, games, and more! I have blogged about these resources in the past and will continue to do so in the future, so keep coming back!
During the event I spoke to many of the excecutives of this user group: Yvonne, Joe, Tim, Dawn, Murray... and others! While talking to them I realized that each and every one of them are using a piece of advice that is prominent in Sam Lightstone's book: Making it Big in Software. That advice is to become a domain expert which will allow you to build your own skills but to help others build their skills and to build your network of like minded people. Can you imagine the benefits of knowing people throughout the industry who have the same passion and skills as you have?
Tim told me that he has attended just about every user group meeting for the past 25 years! I think the dedication that he and others put into user groups is amazing and hope that there are people early in their career who are willing to contribute to keep such an amazing community viable well into the future.
I hope you enjoy my blog entries!
svisser1 2700018UK9 Tags:  certification learning books blogs hands-on db2 training ibmblu webinars 19,163 Views
A few weeks ago, I started a discussion in the DB2 Professional LinkedIn group that turned out to be quite popular. Request to join the group so you can take part in this and other discussions.
My question: When you were using DB2 for the first time, how did you go about learning how to use it? If you are already an expert, what learning path do you recommend to any newbies who you may meet?
This blog entry summarizes the responses. The text in italics is a response from a group member to my question. The normal text is from me to give additional information, including links, about the response.
Essentially by installing it, supporting it and using it with the help of some very knowledgeable colleagues. Only once I'd been using it for some time did I go on a couple of courses to fill in some advanced gaps.
Here is the link to DB2 Express C which is free and allows developers to create database apps....http://www-01.ibm.com/software/data/db2/express-c/download.html
I'm glad you mentioned certification. I helped many people earn a certification over my career at IBM and continue to encourage the students who work at IBM to pursue this path. Roger Sanders has made it easy for people to prepare for the exam with his study guides: http://www.amazon.ca/DB2-10-1-Fundamentals-Certification-Study/dp/1583473491 Although they are not free books, they are very valuable since they include sample questions along with answers. Read also Ember Crooks' blog about how to get certified: http://db2commerce.com/2013/11/26/ibm-db2-certification-why-it-is-worth-it/
I'm glad you mentioned webinars. I'm not sure if there is a product with more free education than DB2! IBM runs a regular Tech Talk series with very educational webinars, delivered by IBM experts: https://www.brighttalk.com/channel/7637 These webinars are recorded and can be watch anywhere, anytime. These are hosted on BrightTalk where IDUG also hosts presentations and recordings. And then there is our IBM Champion Scott Hayes who runs the very successful DB2Night Show Webinar. These are also free and recorded and include speakers from IBM, IDUG, and users of DB2: http://www.dbisoftware.com/db2nightshow/
I had forgotten about the DB2 Demo programs! Thanks for the reminder! Do others use these demos to help them learn how to do something on DB2?
Thanks to George Baklarz for the blog about these demos: http://ibmdatamanagement.co/2013/10/16/db2demo-updated-fordb2-10-5/
I'm surprised that books weren't mentioned earlier! Craig Mullins has done a fabulous job at creating books that have and will teach thousands! Craig's latest books were published via IBM Press where you can often get good discounts: http://www.ibmpressbooks.com/authors/bio/88e03c0d-e88a-49a8-b121-50484f7b670b If you are a member of IDUG, you can get a 45% discount on all IBM Press books.
Hands on training seems to be the most common answer! There are many courses on the bigdatauniversity.com site. I think more people should learn about the availability of these courses. They are free, but some are out of date. We're looking for people to update them... so if you're interested.... let me know. I use these courses to teach the students who join the DB2 team in the lab. There are exercises and tests to go along with the courses which help solidify the knowledge. There is also a series of free books that you can download and read: https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Big%20Data%20University/page/FREE%20eBooks
IBM Redbooks! What a great resource. You can download them anytime you like as many times as you like and can read them on your reading devices... or computers. One of the best options is that you can search the entire book. This will help you get to the right content as fast as you can. Here's where you can find the full set of data related IBM Redbooks: http://www.redbooks.ibm.com/portals/data
Thanks for the links for some of the great content to be found on developerworks. Too bad the name is misleading, but I'm glad you found it and recommend it. About 70 new articles are published every year on devworks in a "how to" format. If you go the technical library link, you can search on any term / product name and find a related article: http://www.ibm.com/developerworks/library/
The certification tutorial series that was published on this site is also very popular: http://www.ibm.com/developerworks/offers/lp/db2cert/db2-cert610.html
I haven't personally attended one of Klaas' events, but would like to go to lovely Holland in the spring to attend: http://www.kbce.com/news/db2-symposium-2015-netherlands/
Several people mentioned conferences. The best choices seem to be IDUG, IBM Insight, and DB2 Symposium. There is a different approach to each, but the common thing is you'll find many experts and learners at the conferences. From a DB2 perspective, we encourage our experts in the lab and our experts who are partners to create presentations to help attendees learn. A special mention needs to go out to IDUG. I think for anyone who has ever attended has noticed what a friendly family-like community they have going. This year there is one in Philadelphia and another in Dublin. There are smaller versions of these conferences call RUGs or Regional User Groups.... check out idug.org for information. Remember, if you attend an IDUG conference, then you're automatically a member. There are benefits to being a member, so click the link, sign in, and explore.
Jamie and Ember... teaching is one of the best ways to learn. Writing a book, blog entry, or a presentation will help you uncover a lot that you don't know. Researching to fill these gaps will strengthen your skills and help you become an expert. I'm sure Scott has many testimonials from the people who have taken part in the DB2's Got Talent Competition similar to this. Ember has certainly taken her own advice. Her blog series is one of the best available... and she helps others build their skills by allowing guest bloggers. Check it out: http://db2commerce.com/
Chris, your comment brought back fond memories. I was one of the people in the Toronto lab when the product moved from Austin to become DB2. A good portion of the development team is still the same as it was in 1991. You made me laugh the way you mentioned google! Did you know that searching on google will bring you directly to the product documentation, now know as the Knowledge Center? http://www-01.ibm.com/support/knowledgecenter/SSEPGG/welcome
Glenn, you're right.. IBM offers great formal training. You can get a live instructor or take part in a class virtually. Explore the in-person and virtual courses IBM has available here: http://www-01.ibm.com/software/data/education/ For the latest in certification exams, including samples tests, see ibm.com/certify.
Agreed! With all the products and trial technologies on BlueMix, you have a personal sandbox to play in to explore. I don't think there has ever been a better time for hands-on learning.. for free: http://www-01.ibm.com/software/bluemix/
I joined the DBA ranks from the application ranks and got thrown into the fire right away. I had a little training from the other developers who had started the DBA team. Otherwise, I have been almost 100% self-taught. I learned a lot from reading "Understanding DB2: Learning Visually with Examples". I also googled a lot. Read blogs like db2commerce.com (a staple for me everday). Reading the Knowledge Center documentation. And joining dba.stackexchange.com. Being one of the earliest DB2 DBAs on the site forced me to learn a lot about the product in order to help others with answering questions. Participating in DB2's Got Talent and networking with other great DB2 DBAs.
It sounds like many people learned DB2 the way you did! The book you mention was updated and is often available at a discount: http://www.ibmpressbooks.com/store/db2-essentials-understanding-db2-in-a-big-data-world-9780133461909
Hint: if you're a member of IDUG... log into idug.org and you'll find a coupon for all all IBM Press books... for 45% off.
Roger Sanders is definitely a star of the community. Unfortunately he's not currently planning to write any more books, so he's working with other authors to continue what he started.
All really great advice!
Social media has turned a lot of the chatting with experts to an online format. This was true for the old style forums, but today your best places are in LinkedIN... there are many data specific groups for you to join and participate in. The great thing about the groups on LinkedIN.... is that nearly everyone is using that platform. Maybe not to the extent that they should, but they are using it. So, you'll see a Database Expert Group (https://www.linkedin.com/groups?home=&gid=45183&trk=anet_ug_hm) that has nearly 20,000 members. For me, that's a way that I can reach people who are not yet fans of DB2... but who should be!
We also have our twitter ID where we give information, have discussions, and formalized chats. I try to live tweet the webinars related to DB2, so you get see the top points discussed in the webinar. Come and follow us on twitter and linkedIN, and join the conversation: https://twitter.com/IBM_DB2
This turned out to be a long post. I hope you find it valuable.
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.
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!
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:
Friday January 21, 2011, 11:00 - 12:00 EST
In this Episode, Scott Hayes is joined by two very special guests from the UK, both IBM DB2 GOLD Consultants, who will share with us their field (real world) experiences for using MDC successfully to achieve outstanding performance results. We are pleased and honored to have Susan Gausden and Terry Mason from Brooklands Technology Limited join us. In addition to sharing MDC tips and best practices, they have a few horror stories to share as well - this is a great opportunity to learn from the mistakes of others!
Susan Gausden is a certified database consultant experienced in data warehousing, database performance and multi-platform architectures. Susan is English and French bilingual and previously worked for major software and hardware vendors in North America.
Terry Mason is a certified database consultant, experienced in data warehousing, performance assurance, and database migrations. He was a founding director of the International DB2 Users Group (IDUG) and has worked extensively in the UK and North America.
In this episode, special guest Julian Stuhler, Director Triton Consulting and IBM DB2 GOLD Consultant, shares with us his views and experiences on the top DB2 support issues and recommended solutions.
While most of us eventually become adept at handling challenges in our own organizations, you can get a head start and be more proactive by joining us for this unique show. As Julian checks off the most common problems he and his teams run into, you may likely learn how to avoid a problem. Or, you might learn a clever or efficient solution to a common challenge.
They say the difference between stupidity and ignorance is how many times you make the same mistake. Well, here is another great opportunity to benefit from the mistakes and ensuing wisdom of others.
DB2 Night Show in February & March: DB2'S GOT TALENT CONTEST.
Join us on the following dates:
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!
I’m looking forward to a fun & rewarding new year and wish all the best for you and your families as well!
Have you missed a show? Don’t worry, they’re recorded, so you can catch up on all your favourite topics. See my blog entry The Top 10 Most Highly Attended Shows for details.
I’ve been seeing many upcoming events for the DB2 for z/OS product and decided to summarize in this post.
IDUG – Anaheim May 2-6. This isn’t an event specifically for DB2 for z/OS, but as usual there are some amazing sessions planned for that platform including:
Learn more: IDUG = International DB2 User Group
Upgrading to DB2 9 or DB2 10 for z/OS — How? When? What is the cost versus benefit?
Broadcast Date: February 22, 2010 at 11:00 a.m. Eastern Standard Time, 4:00 p.m. GMT
Developed for: IT directors, managers and project managers; business analysts; enterprise architects; database administrators and managers; and application database administrators
On Oct. 19, 2010, IBM announced DB2® 10. This latest release of DB2 delivers the most aggressive package of CPU savings and performance improvements from IBM in more than 20 years, and for the first time since 2001, IBM has offered skip release. With the increased cost of support software licenses, the launch of DB2 10 and the announcement of DB2 V8 end-of-service, many DB2 users are considering migration and need direction in planning the right migration strategy for their business. But how do you approach a migration strategy? When is the best time to start? Is skipping a release a good strategy? What are the costs versus benefits for any scenario?
Join us for this complimentary webcast as we address the most critical business issues to consider such a migration, so you can develop a strategy and plan for your own migration. We will describe the options available and some of the potential risks versus benefits. Overall, this webcast will help you choose the best path for your situation, and get ready to migrate to the new version. Whether you are ready to migrate now or you are still years away, planning should start now so that you can use your time more effectively and minimize the ultimate cost of upgrading.
All webcast attendees will receive a free copy of “Executive Report of Business Value of DB2 10 - Smarter Database for a Smarter Planet” by Julian Stuhler, an Internationally recognized DB2 consultant and analyst.
In this webcast, we’ll discuss:
Speaker: Roger Miller, DB2 for z/OS® Technical Evangelist, Designer and Architect, IBM Software Group
Why is DB2 for z/OS better than Oracle RAC?
In recent years, IBM DB2 has been under considerable pressure from its competitors, most notably Oracle RAC. These competitors claim to provide the same functionality and quality of service characteristics as DB2. DB2 specialists are often asked by the business decision makers to articulate the technical advantages of DB2 and justify the choice of DB2 as the database server:
Speaker: Namik Hrle is an IBM Distinguished Engineer and works in the IBM Boeblingen Laboratory. He is a member of the IBM Academy of Technology, Information Management Architecture Board, SWG Architecture Board Steering Committee and many other IBM expert teams. He specializes in information management technology and its usage by the enterprise applications. He works closely with the IBM labs worldwide and helps customers deploy and optimally exploit information management products. He is a regular speaker at conferences across the world.
DB2 for z/OS Technical Seminars that you can attend in person, for free:
To stay on top of all the upcoming events, bookmark Surekha’s Blog.
And last but not least…. get your copy of the Flashbook:
by Roger Miller, David Beulke, Julian Stuhler, Surekha Pureka
I’m aware of three important webinars that are planned for the next few weeks that you should consider attending:
First– DB2Night Show – Friday Sept 24
As usual, join Scott Hayes the host of the DB2Night Show for some very entertaining learning… for free! Next week on the DB2Night Show: DB2 LUW Recovery Planning & Best Practices.
Failing to Plan is Planning to Fail. Watch the DB2Night Show Friday 9/24 to learn about DB2 LUW Recovery Planning & Best Practices. Experts Dale McInnis and Kate Kurtz from IBM Toronto have much information to share that this topic.
Last week’s show with Mike Winer had record attendance. Did you miss it? No worries! Scott keeps recordings of all the shows, so go through and watch all the ones you’ve missed. If you’re new to this series, you might be surprised at the variety of guest speakers that Scott has worked with! Visit http://www.DB2NightShow.com for details and FREE registration links.
Second – Tuesdays with Craig – begins Tuesday Sept 28
SoftwareOnZ is sponsoring a series of DB2 webinars presented by Craig S. Mullins (author of DB2 Developer’s Guide and regular columnist for zJournal Magazine). Each webinar will be focused on a specific DB2 topic so you can pick and choose the ones that are most interesting to you – or attend them all and receive a certificate signed by Craig indicating that you have completed the DB2 Education Webinar Series. The first one is:
Third– Chat with the Lab – Wednesday Sept 29
This webcast provides and in-depth overview of High Availability (HA) options for DB2 on Linux, UNIX and Windows.
- High Availability and Disaster Recovery (HA)
The Chat will also touch on future directions.
To learn more and get your questions answered, join experts from IBM labs - Sal Vella, (VP) and Dale McInnis (HA Architect).
Presentation charts for this Chat will be available for download from ibm.com/db2/labchats 1-2 days prior to the event.Date: Wednesday, September 29, 2010
Time: 11:30 AM - 1:00 PM Eastern (GMT-04:00)
10:30 AM Central / 8:30 AM Pacific / 16:30hrs London / 17:30hrs Frankfurt, Paris / India 9 PM
Speakers: Sal Vella (IBM), Dale McInnis (IBM)
Host: Rav Ahuja (IBM)
To register and receive instructions for attending this webinar, point your browser to:
For questions/comments/suggestions: http://www.channeldb2.com/group/db2chatwiththelab
Thanks to all the great people who put together this important education!
I have two upcoming webinars to tell you about today and hope that you can make one or both of them!
First, the second season of the DB2Night Show starts this Friday, August 6, 2010. This kickoff episode is special in that it is 90 minutes in length and Scott will be joined by my two good friends Serge Rielau and Dwaine Snow.
Together they will give us updates on all the ways that IBM is making it easy to choose DB2 LUW. If you are a current user of Oracle or Sybase, you really don’t want to miss this show.
Season 1 ended up with 23 shows and if you missed them, come and listen to the replays. I was a guest on one of the shows and had much fun with Scott!
View the upcoming shows and register here: DB2Night Show Website.
Second, the DB2 Database professional bloggers are hosting a free 60-minute virtual session for our the community. The best part is ... YOU GET TO CHOOSE THE TOPIC! Yes, that's right. This virtual session will be on a topic of your choice. Are you interested in an overview of the technical advantages of DB2 over Oracle? Want to know more about DB2 pureScale? Maybe you'd like tips on how to migrate an existing Oracle application to a DB2 application? Whatever your topic(s) of interest, post a comment and let me know. If you're new to DB2, this is a great opportunity for you to become familiar with DB2.
Nominate a topic here: DB2 Database Professional Blog
By the way, this is a good blog to “follow”.
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.