Previously I blogged about the benefits of getting certified . If, after reading that, you decide you want to earn a DB2 certification, what is the process? Choose Job Role First you need to decide what job role you’d like a certification for. For many people this is easy. If you work as a DBA, get the DBA certification… easy. But some people end up performing multiple roles in the course of their job. The primary job roles that affect DB2 users are: Academic Associate, Database Associate, Database Administrator, Advanced Database... [More]
After a long delay, I can finally announce that this long awaited book has published.
DB2 10 for z/OS Database Administration: Certification Study
by IBM Champions Susan Lawson and Daniel Luksetich
I can also tell you that the covers for the certification series of books by
have been redesigned and will be launched on this title. I hope you like the
What’s in the book?
Read this book to prepare to pass Exam 612 – DB2 10 for
z/OS Database Administration .
All test... [More]
Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and
Capabilities of DB2 for z/OS (6th Edition)
by Craig Mullins This book published in May this year, just in time for IDUG Denver , and for the first
time, will publish under the IBM Press imprint: DB2 Developer's Guide is the best source for on-the-job
information on programming and administering DB2 on IBM z/OS mainframes. Now,
three-time (or is it 4 times now?) IBM Champion Craig S.
Mullins has thoroughly updated this classic for DB2 v9 and... [More]
The exam that you need to pass to start your journey on the road to DB2 Certification is the DB2 Family Fundamentals Exam 730. This exam only contains questions for concepts that are common across all platforms that DB2 runs on. There is a heavy SQL component to the exam, and most people who use DB2 daily should find this exam fairly easy. You’ll find it easier as well if you examine the objectives and use one or more of the listed study materials. Database Associate Certification Role Exam 730 – DB2 9 Family Fundamentals Number of... [More]
DB2 11 for z/OS Generally Available on October 25, 2013
Rather than me telling you about it, I’m sharing content from experts:
Say "Hello" to DB2 11 for z/OS from IBM Champion Craig Mullins
DB2 for z/OS: How Big is Big? from Robert Catterall
Are you looking for some excellent DB2 11 reading materials? from Willie Favero
And last, but... [More]
The launch of DB2 on June 7, 1983, marked the birth of relational database as a cornerstone for the enterprise; 30 years later, DB2 for z/OS is still the undisputed leader in the RDBMS market and the envy of its competitors when it comes to total system availability, scalability, security, reliability, and cost effectiveness. A majority of Fortune 500 companies, including the world's top banks, retailers, and insurance providers, store mission-critical operational data in IBM System z and DB2 for z/OS.
Why? It seems... [More]
of the more valuable pieces of content that IBM provides for free is
its best practice information that is produced by experts. The best
practices cover many products and different features of each product.
Many are also available in video format so you can take a break from
all the reading that is required in the job of a DBA! Announcing the latest in a series of webcast videos presented by DB2 Expert John Campbell . Application Best Practices Specific to DB2 for z/OS Data Sharing Running
applications in a data sharing... [More]
had 4 great presentations again this week! I’d really like to thank
all participants... I know it isn’t always easy to present, but it is
very important for us to share our knowledge with others! Mikko - Summary Table Design & Monitoring A little trouble following the story of the problem & solution. Summary tables are a huge topic. Well presented. Umesha - Detailed steps to configure DB2 Distributed Data Facility (DDF) for z/OS Good slides. Not practised? Went over time. Missing the “why”. Only “how” was covered in... [More]
often blogged about the best practice papers that are published in
relation to IBM IM products. There has been such great feedback to
these papers, that there is now a dedicated portal for Best Practices. From this portal, you’ll be able to find best practices concerning these product groups: DB2 for Linux, UNIX, and Windows and InfoSphere Warehouse DB2 for z/OS InfoSphere Information Server InfoSphere Master Data Management IMS InfoSphere Change Data Capture (CDC) Forum Visit the new IM best practices... [More]
Congratulations to author and IBM Champion Tony Andrews on his new book: DB2 SQL Tuning Tips for z/OS Developers This
well-organized, easy-to-understand reference brings together 102
SQL-related skills and techniques that any developer can use to build
DB2 applications that deliver consistently superior performance.
Legendary DB2 tuning expert Tony Andrews ("Tony the Tuner") draws on
more than 23 years of DB2-related experience, empowering developers to
take performance into their own hands - whether they're writing new... [More]
call them IBM’s Best Friends! One of the reasons is that they are so
knowledgeable about our products and another is that they tend to make
excellent authors. Take a look at this list and you’ll see: Craig Mullins Craig has published two books this year! What a great accomplishment. DB2 Developer’s Guide 6th Edition: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS Database Administration: The Complete Guide to Practices and Procedures (2nd Edition) Meet
Craig on Tuesday, October 23 from... [More]
This year at the IBM Information on Demand Conference , we’ll be launching the NEW DB2
for z/OS book in recognition of DB2’s upcoming 30th Anniversary: Flashbook: IBM DB2: The Past, Present and Future: 30 Years of Superior Innovation by Surekha Parekh, Terry Purcell, John Campbell, Ruiping Li and Don Haderle About the book: Top
DB2 experts John Campbell and Terry Purcell have contributed to this
book, but as a special treat, we also managed to have Don Haderle - "The
FATHER of DB2" contribute to the book. This book is not... [More]
Administration: The Complete Guide to Practices and Procedures (2nd
by Craig Mullins
This is Craig’s second book this year! Make sure you congratulate him on
this amazing accomplishment!
The DB2 Developer’s Guide 6th Edition: A
Solutions-Oriented Approach to Learning
the Foundation and Capabilities of DB2 for z/OS came out earlier this year
Administration: The Complete Guide to Practices and Procedures (2nd
Edition) will be launched at the IBM
Information on Demand Conference .
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... [More]
Last week I blogged about social
media sites for DB2 for LUW and all of my recommendations were for IBM
sites. I’m really happy to say that IBM has many friends who are great at
creating content about IBM products and sharing their knowledge with other
users. Today’s entry is my thanks to all of you!
developerWorks ibm.com/developerworks/data/ and
IBM Data Management magazine ibmdatamag.com might be run by IBMers, but a
great deal of the content that lives on these sites was created by IBM friends. ... [More]
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
IBM Data... [More]
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... [More]
Here’s a summary of the books that have published in 2012. I’m quite pleased with the progress
we’ve made so far this year, and have many books left to go. Make sure to follow my blog to stay in the loop as to when new books come out or if there is a sale you should know about.
An Introduction to IMS: Your Complete Guide to IBM Information
Management System, 2nd Edition
by Barbara Klein , Richard Alan Long , Kenneth Ray
Blackman , Diane Lynne Goff , Stephen Paul Nathan , Moira
McFadden Lanyi , Margaret M.... [More]
I had to miss the show on March 30th, but hopefully you were able to attend
the show live. I’m listening to the replay and here’s a summary of what took
The theme for this show was for the contestants to showcase their best
success story with DB2.
Today was the third show of the finals for the DB2’s Got Talent 2012
Competition. I wasn’t able to participate, so IBM Champion, Julian Stuhler
filled in for me. Thanks Jules!
If you didn’t participate live, I strongly encourage you to watch the replay . We had... [More]
Are you an expert who would like to share your knowledge with a world-wide
and large audience? If yes, I would suggest that you submit a proposal to speak
at the IBM Information On Demand 2012 Conference to be held
October 21-25, 2012 in Las Vegas, Nevada.
This conference provides in-depth technical education through an agenda that
includes Information Management, Business Analytics and Enterprise Content
Management. The Business Leadership program also addresses strategy issues and
the industry challenges facing today’s... [More]