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
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
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
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.
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. Wilson, John Butterweck, Sandra
Technical Blogging: Turn Your Expertise into a Remarkable Online
by Antonio Cangiano
IBM DB2 9.7 Advanced Administration Cookbook
by Adrian Neagu and Robert Pelletier
IBM DB2 9.7 Advanced Application Developer Cookbook
by Sanjay Kumar and Mohankumar Saraswatipura
DB2 10 for z/OS Database Administration: Certification Study
by Susan Lawson and Daniel Luksetich
IBM Cognos TM1: The Official Guide
by Karsten Oehler, Jochen Gruenes, and Christopher
DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the
Foundation and Capabilities of DB2 for z/OS (6th Edition)
by Craig Mullins
IBM Cognos Business Intelligence 10: The Official
by Dan Volitich and Gerard Ruppert
My TV is on its last legs, so what did I do? I searched several websites for
possible replacements and only considered those that had customer feedback and
multiple stars. I do this for books, movies, electronics, cars, just about
anything I consider buying. Do you do the same thing?
If the feedback from someone with actual experience is positive, I am more
likely to seriously consider buying the item myself.
If the feedback is
overwhelmingly positive from many people, my buying decision gets easier. If the
feedback is negative, it helps as well... but only if a clear description of the
problem is described and multiple people have experienced the same problem /
So... will you be willing to provide feedback to others regarding the
books that you've read? Let's face it, making a decision to buy a book isn't
only made based on the price of the book, but also on whether it is worth your
valuable time to read the book. We're all short on time, so we want to be sure
that we aren't wasting our time by reading a book that won't help
Where can you post your feedback? For books, amazon.com is likely the
most useful place. I'm in Canada, but still chose to read the feedback that is
posted on amazon.com rather than one of the Canadian sites. Why? Simply because
there tends to be much more feedback on amazon.com than anywhere else. But, you
can still provide feedback on any of the sites that take feedback. Even db2inbooks is a
good site to post feedback.
What should you avoid? It won't help anyone if your feedback is
negative, but you haven't actually read the book. Yes, it does happen. For
instance, my first book had a negative comment made by a reader because of the
title. I don't think the reader read a single word of the book, but decided to
trash it based on the title alone. Is this fair? Absolutely not. I'm sure most
people would disregard this type of feedback, but save yourself some time, if
you didn't actually read the book, don't bother posting comments... positive or
is of more use than just saying that you liked the book. For example, you could
say... "I read the certification guide and was able to learn everything that
I needed in order to pass the exam with an excellent score. I believe that my
success was based on how easy it was to read the information as well as the
sample questions that explained to me why my first answer was incorrect."
This is actual feedback that I've personally received from a reader who read one
of Roger Sander's books.
If you find errors in the book that aren't very serious but that should be
corrected.... I suggest that you contact the author directly if you can. It is
near impossible to produce an error-free book. Most of the authors who I work
with make it easy for you to reach them. Check in the front of the book... you
may find an email address. Also check on ChannelDB2.com as many of our
authors are members and would be happy to hear from you. If you'd rather not
contact the author directly... you can always go directly to the publisher... or
to me. I'll make sure your comments are sent to the author who can then make the
corrections for future iterations of the book.
If you really like reviewing books... and think that you are good at it....
did you know that you may qualify to get free books from the publisher? In some
cases we ask people to review the book before it publishes and ask reviewers to
provide a comment that may be included on the cover of the book. If this
interests you, let me know.
Share your opinion... everyone will appreciate it :)
Beyond books, your opinion about the presentations being
delivered at conferences or webinars is also extremely valuable. Right now on
the DB2Night Show, we are in the Final Rounds of the “DB2’s Got Talent
Competition”. During the finals, the power is in the hands of you the listener
to choose who will win a very lucrative prize as the overall champion. Don’t
miss your opportunity, see DB2’s
Got Talent Finals – Round 1 for further information.
I’d be remiss if I didn’t add that your feedback on blogs is
also important. You can show your “like” of a blog by following it, making
comments on the content, reshare it via twitter or other social media sites, or
add a “like” to the entry.
Times are changing rapidly especially in the book market. I used to love
going to the bookstore to browse and would end up with a large bag full of
beautiful books! I still do that sometimes, but now I’m more likely to order
technical books online, fiction for my kindle, and business books in audio
I’m often recommending books for people to purchase, and today I was asked
where do I recommend that people buy their books. Here’s my
I normally put an amazon.com link for the books that I promote. I do this
mainly because amazon.com is by far the most well known book buying site around
the world. Many countries have their own amazon site, so if you’re like me and
live in one of those countries, I would suspect that you’d see the title and
comments on the amazon.com link but make the purchase on your country site, such
as amazon.ca. I also point to amazon because of their prices. I like that they
often have 37% discounts on books.
I work directly with many publishers and when they have special sales on
their books, I will often write a blog entry about the sale. Here are a few
IBM Press - has offered a discount code – IBMEXPERIENCE –
that will save you 35% at the online checkout.
MC Press – has tabs for their “sale” books: Bargain Books,
Close-Outs and Scratch & Dents
If you prefer digital books, you have quite a bit of choice as well. All of
the publishers offer ebooks for sale on their sites, but also make Kindle
versions available on amazon.com as well. ebooks and Kindle versions can be run on many different
devices through reader applications. I occasionally use a Kindle reader on my
laptop to read technical books. I find the Kindle reader app makes book content
more pleasant to read than simply reading a PDF version of a book.
I should use libraries more often, but I haven’t been able to fit it into my
lifestyle yet. If you are a library user, you have a wide variety of choice and
can even borrow audio and electronic versions of books that exist.
Another library option includes Digital Libraries such as Books 24x7,
Safari, and PacktLib. IBMers have a free
subscription to Books 24x7, so I frequently browse through those books. My
local library membership offers a subscription to Safari Books Online. I
haven’t used this service yet, but I have used Safari before. The three digital
libraries are similar, but they contain a different collection of books. If you
have the full membership of a digital library, you’ll also be able to download
the books to your reading devices as well.
I’d like to hear from you as to where you buy your books. Are you OK that I
normally point to amazon.com? Where do you learn about books? Blogs like mine,
twitter, IBM websites, amazon? Let me know!
PS… If you want to stay on top of the latest books and the sales as they are
announced, be sure to follow my blog.
Yesterday I read this article “How Employers Can Help Solve the Skills Gap” by David Smith
which discusses the skills gaps that are appearing throughout the world. A
big part of the problem is the lack of corporate funding for education. This
leaves employees to take initiative to keep their skills sharp. But how does
one do so?
My suggestion is to get skilled digitally. IBM is good at digital…
have you noticed? And, I hope that I can give you some direction in
how to do this.
IBM Education is known for its high quality content and excellent
instructors. Take this education digitally, with your choice of the amount of
interaction you want.
Instructor-led online (ILO)
ILO courses are taught by a live
instructor with whom you can interact and ask questions using Voice Over IP
(VOIP). Courses are taught on a specific day and time, some of which may even be
scheduled after business hours to minimize time away from work. Most courses are
exactly the same as their classroom equivalent, including the course duration,
content, hands-on labs and student materials. ILO classes can be delivered in
both Public and Private settings.
Self-paced virtual (SPVC)
SPVC are online courses that include the
same quality course content, exercises and hands-on labs as our classroom
courses. These courses can be taken any time of day or night allowing students
to study when and where they want. Start your training by studying the lecture
content of the course. When ready, log into the lab environment to complete your
hands-on lab assignments working with IBM software. Self-paced virtual courses
are the perfect training method for students who can't travel or prefer the
flexibility of self-paced training. Experience this eLearning method with a free
Web Based (WBT)
WBT allows you to learn at your own pace and on
your schedule with training that is completely self-contained from your desktop.
Most courses provide introductory and overview training that serves as the
foundation for more technical and follow-on training. Courses include expert
instruction but do not include hands-on labs.
I hope you like reading as much as I do… because look at all the choice that
These very popular books have been digital for more than 40 years now! Here
are 10 that you may be interested in: http://ibm.co/hZDwXV
We publish books about IBM products and technologies via a bunch of highly
reputable publishers. Every one of these publishers creates their books in
digital format. Thanks to the popularity of iPads and Kindles, these books can
be inexpensive and available as soon as the printed versions are available.
Here are a few books that you may be interested in: Books, books, books
Electronic Book Libraries
There are three big electronic book libraries that I know of: Safari,
Books 24x7 and PacktLib. Sadly this is publisher-driven, so you will not be
able to find all possible books in any of these libraries. For instance IBM
Press books will be in both Safari and Books 24x7; MC Press books will be only
Books 24x7; and Packt books only in PacktLib. Check to see if you have a
corporate license to any of these libraries. If not, check out your university
or public library. You may be surprised at the number of technical books at
Flashbooks are short targeted books that are handed out to conference
attendees at certain conferences. We also produce these books in electronic
format for you to read them digitally. Here are a few you will want to check
out: Free e-book versions of Flashbooks
DB2 on Campus
DB2 on Campus Series of ebooks - Thanks to an amazing
team of authors led by Raul Chong, we have high-quality ebooks available for
university students to learn about DB2 and related products. The authors who
have worked on these books are experts in their area and they have volunteered
to share their expertise with you for no financial gain to themselves. The
authors can be found around the world, so as a result, you’ll see that many of
the titles have already or will one day be translated to another language. We
at IBM want to make sure that everyone in the world is able to benefit from the
knowledge that is being shared.
Take Certification Exams
You could debate that this topic doesn’t belong here, but consider this: the
assessment and certification exams are delivered electronically. You can take
the assessment exams from anywhere, but you must be at a testing location to
take a high stakes certification exam. There are digital ways to learn and
assess your skills and many exams to choose from. Best of all, the
certification roadmaps take the guessing out of what you should study and what
is important. The Certification Roadmaps give you very clear guidance as to how
grow your skills. Here are a few blog entries you may want to read:
I personally enjoy webinars and find that they are an easy and effective way
to learn something new or to get deeper into a topic. There are so many choices
available that you could set aside an hour a week to catch them all.
DB2Night Show – This is a 2 session per week webinar
produced by IBM Champions Scott Hayes and Klaas Brant. Mondays are when the DB2
for z/OS topics take place and Fridays, the LUW topics. Here are replays of
the top rated shows from the past year on the DB2Night Show: http://bit.ly/i8qP49 and information about the
DB2Night Show's DB2's Got Talent Competition: http://ibm.co/hcCH90
DB2 for z/OS Series – You can find these webcasts
promoted by Surekha via her tweets: https://twitter.com/#!/IBMDB2.
TechTalks (Formerly Chat with the Lab) – This free
webinar series was designed to help you discover practical insights on
deeply technical topics, learn about breakthrough technologies, learn best
practices from the pros, chat with subject matter experts during live Q&A,
and access prior sessions in the OnDemand archive. See the replays of the "Chat
with the Lab" webcasts: http://ChannelDB2.com
Interact with a Community
PlanetDB2.com – Allow us to filter through
all the blogs that are on the web to bring you only the bloggers that talk about
our favourite subjects: DB2, InfoSphere, Warehouse, and other Information
ChannelDB2.com – The single largest
community of people working on DB2 and Information Management products,
world-wide. You’ll be able to build your network of professionals who work in
your country or who are interested in the same technology as you. The best
feature is the incredibly large selection of videos of people presenting about
this products. Once in awhile, save your eyes and tune into these
DB2Express-C – Maybe you’ve just heard of
DB2 or maybe you use a competitor’s product. No worries… give DB2 a try for
free. Find out for yourself how easy it is to learn and how much better it is
than the product you may be using.
Information Center – Perhaps I’m biased
since I worked for 6 years on the Information Development team that produces
product documentation, but I really think you’ll find the completeness and the
quality of this information to be outstanding. All of the information is
online, for every release, for free, and is updated regularly. The benefit of
the content being online is that you can search and easily find the information
developerWorks – You’ll find more
articles, blogs, tutorials and other training resources than you could possibly
consume in a lifetime! The link I’ve provided is for the DB2 Professional
Community, but you’ll be able to find technical information about all IBM
software products. Endless :)
DB2University.com – Some of the courses
are free, but not all. The idea behind DB2University is to offer you very low
cost training opportunities.
Facebook – if you participate in Facebook, do a search and
you’ll find IBM well represented.
Twitter – I tweet
and love it. I find that it is a very fast and easy way to stay on top of many
things that are going on.
Blogs – Follow my blog to
get tips like the ones you’re reading now.
So you see, there is much available for you to learn digitally. Try to fit
in a bit a time and you’ll be able to keep your skills strong.
Yesterday I read a blog entry by Sunil Soares called Big Data Governance. This caught my attention as both Big
Data and Governance are huge topics in the industry today. You may recognize
Sunil’s name, and let me remind you where you know his name from. Sunil is an
expert in the Information Governance area and has had two books published on the
This book was published last year and is selling quite well. I wrote a
lengthy blog entry about this book that I encourage you to read: Meet Sunil Soares - Selling
Information Governance to the Business: Best Practices by Industry and Job
Function. In summary this book discusses the best practices to sell the
value of information governance. The objective of the book is to provide a
representative sample, rather than an exhaustive list, of best practices to sell
the value of information governance within an organization. You should use these
best practices as inspiration for what might work within your organization. It
is important that you read chapters from industries and functions outside of
your own because there are a number of case studies that you might find useful
for your specific situation. The book contains more than 50 case studies and 16
This is a Flashbook that was published in 2010. Printed copies of this book
exist, but in small supply. Printed copies are handed at selected events, but
you can get a free e-version of the book: Information Management Bookstore. What’s the book about?
Briefly, according to Arvind Krishna, General Manager at IBM:
IBM has assembled a comprehensive approach to Information Governance
delivers the industry’s strongest portfolio of products, services, and best
practices to address every organization’s needs. This book provides a
set of detailed steps and sub-steps to implement an Information
program, as well as the associated automation provided by IBM
Beyond the blog entry that caught my attention, I found two articles also
written by Sunil:
Information Governance: Big Data and the Road Ahead
Smart meters and Big Data: A clear case for governance best
In Sunil’s words: I am starting to see a convergence of two major trends in
the marketplace: information governance and Big Data. We are coining the term
“Big Data Governance” to reflect this emerging trend. I define Big Data
Governance as the formulation of policy to optimize, secure, and leverage Big
Data as an enterprise asset by aligning the objectives of multiple
I’m looking forward to see how this convergence pans out. If you’re also
interested, I suggest you keep an eye on what Sunil comes up with. I’m sure
he’ll make this emerging trend easy for you to understand and implement.
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
Passing this exam will earn you the following Professional Certification: IBM Certified Database Associate -- DB2 9 Fundamentals and qualifies you to take a number of other exams that will lead to more DB2 Certifications.
Book: DB2 9 Fundamentals (Exam 730) Study Guide by Roger Sanders
This is the one that is known as the “red” book. It covers everything you need to know to pass Exam 730 which is the basic exam that is pre-requisite for all V9 and V10 DB2 Certification exams. The book includes sample questions at the end of each chapter with answers and reasons for the answers provided in an appendix at the end of the book. Roger was a member of the exam development team for Exam 730 and has written many of the questions you’ll need to answer.
Tutorials: DB2 9 Fundamentals certification 730 prep series
These are free and can be found on developerWorks are very popular among the students who I see at the Toronto Lab. They are broken into individual units that match the exam objectives.
Database Administration Certification Roles
You have a choice here. You can take V9 exams or V10 exams. My recommendation is to take the exam that corresponds to the product you are currently working with. If you already have a certification for DB2 V9, then give the V10 exams a try.
Exam 732 - DB2 9 DBA for z/OS
Passing this exam, along with pre-requisite Exam 730, will earn you the following Professional Certification: IBM Certified Database Administrator - DB2 9 DBA for z/OS
Book: DB2 9 for z/OS Database Administration (Exam 732) Study Guide by Susan Lawson and Dan Luksetich
Exam 612 - DB2 10 DBA for z/OS
Passing this exam, along with pre-requisite Exam 730, will earn you the following Professional Certification: IBM Certified Database Administrator - DB2 10 DBA for z/OS
Book: DB2 10 for z/OS Database Administration: Certification Study Guide by Susan Lawson and Dan Luksetich
This book is finished but has not yet been released by the publisher. I’ll update this post when it is released.
System Administration Certification Roles
Again you have a choice here since both the V9 and V10 exams are available for you to take. My recommendation is to take the exam that corresponds to the product you are currently working with. If you already have a certification for DB2 V9, then give the V10 exams a try.
Exam 737 - DB2 9 System Administrator for z/OS Exam
Passing this exam, along with pre-requisite Exam 730, will earn you the following Professional Certification: IBM Certified System Administrator - DB2 9 for z/OS
Book: DB2 9 System Administration for z/OS (Exam 737) Study Guide by Judy Nall
Exam 617 - DB2 10 System Administrator for z/OS
Passing this exam, along with pre-requisite Exam 730, will earn you the following Professional Certification:
IBM Certified System Administrator - DB2 10 for z/OS
Book: Judy Nall is updating her V9 book and it should be published in 2012.
I work in the Toronto Lab where we have at least 2500 employees. We're lucky enough to have a library where local employees may borrow books. This morning I shared the elevator with a couple of people carrying one of the books by Roger Sanders. The book is affectionately known as the "red book" and the one that I saw clearly came from the library and was so well-used it was amazing! It makes me happy to see that there are so many people here at the lab who prepare and take the certification exams.
List of Roger's books:
This is the one that is known as the “red” book. It covers everything you need to know to pass Exam 730 which is the basic exam that is pre-requisite for all V9 and V9.7 DB2 Certification exams. The book includes sample questions at the end of each chapter with answers and reasons for the answers provided in an appendix at the end of the book. Roger was a member of the exam development team for Exam 730 and has written many of the questions you’ll need to answer.
This is the one that is known as the “green” book. It covers everything you need to know to pass Exam 731 which is the DB2 9 for LUW Database Administration exam. The book includes sample questions at the end of each chapter with answers and reasons for the answers provided in an appendix at the end of the book. Roger was a member of the exam development team for Exam 731 and has written many of the questions you’ll need to answer. You may also wish to use this book to pass Exam 541: DB2 9.7 for LUW Database Administration if you also read the following Flashbook: Break free with DB2 9.7: A Tour of Cost-Slashing New Features.
This is the “gold” book. It covers everything you need to know to pass the upgrade Exam 736 which is a short exam for those who are already certified for DBA V8 and don’t want to take the full exam. The book includes sample questions at the end of each chapter with answers and reasons for the answers provided in an appendix at the end of the book. Roger was a member of the exam development team for Exam 736 and has written many of the questions you’ll need to answer.
This is the “purple” book. It covers everything you need to know to pass the advanced DBA Exam 734 which was co-written by IBM expert Dwaine Snow. The book includes a huge amount of reference information plus sample questions at the end of each chapter with answers and reasons for the answers provided in an appendix at the end of the book. Dwaine and Roger were members of the exam development team for Exam 734 and has written many of the questions you’ll need to answer.
This is kind of an update to the book DB2 9 for Linux, UNIX, and Windows Database Administration Certification Study Guide, but not really. It is a collection of slides that Roger has used when teaching crammer courses for Exam 541, DB2 9.7 LUW Database Administration exam. If you’ve been fortunate enough to attend a conference where Roger is teaching the crammer course, and have taken it, you’ll know how valuable the content is.
I’m hoping that Roger will sign up to write the updates for these books when the DB2 product and exams are updated. Thanks Roger for being such a big part of our DB2 certification and book programs. You really are an IBM Champion!
PS. If you like what I tend to share, I encourage you to “follow” my blog. As of writing this entry, I have 199 followers and thank every single one of you. I’m in the midst of reading Antonio Cangiano’s book: Technical Blogging: Turn Your Expertise into a Remarkable Online Presence and am learning tips from his expertise. I would like to put many of his tips into practices in the next few months…. I wonder if you’ll notice? Asking you to follow my blog is just one of his tips!
I noticed that Conor O’Mohony just posted a similar entry so it gave me an idea to do the same. Thanks for the inspiration, Conor!
Last year on Dec 20, my blog had had 994,747 unique views since I started blogging on devworks. Today, I have 1,994,943. The difference is just over a million views! I will definitely reach 2 million views this week! Very exciting.
So, what posts did people like to read on my blog this year? Here are the entries based on number of views:
1. Flashbook: Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data
2. FREE stuff
3. DB2 Best Practices – New or Updated in 2011
4. Book Promotions for the Month of February 2011
5. Where can I get a Flashbook?
I’m happy that these 5 entries were well-read since I think that they contain valuable information and reflect the type of content that I like to post.
To complete the list, here are the all-time most read entries:
1. New White Paper: IBM DB2 and Canonical Ubuntu
2. Making it Big in Software
3. Certification: Getting Started Checklist
4. Certification 101
5. DB2 on Campus Book Series
I like these posts as well, but the certification posts are sadly out of date. I will update them in the next while so you have better content to read.
If you like what I tend to share, I encourage you to “follow” my blog. As of writing this entry, I have 192 followers and thank every single one of you. I’m in the midst of reading Antonio Cangiano’s book: Technical Blogging: Turn Your Expertise into a Remarkable Online Presence and am learning tips from his expertise. I would like to put many of his tips into practices in the next few months…. I wonder if you’ll notice? Asking you to follow my blog is just one of his tips!
These are books that I’ve worked on one way or another in the past year. In most cases the links are to the e-version of the book… usually Kindle. I have a Kindle and really like to read my books using this device. With the prices of Kindles this year, I’m sure there will be many more people with a book reader in the coming year. Also, the popularity of iPads only increases with time.
Note that some of these books haven’t published yet, but will soon. I haven’t noted which to encourage you to click the link to find out.
I know that MC Press is having a big sale on all of their stock until the end of December and it wouldn’t surprise me if the other publishers are also offering special prices. I suggest that you look for the best price before buying!
Agile IT Security Implementation Methodology
by Jeffrey Laskowski
Decision Management Systems: A Practical Guide to Using Business Rules and Predictive Analytics to Build Adaptive, Agile, Intelligent Systems
Get Bold: Using Social Media to Create a New Type of Social Business
IT Virtualization Best Practices: A Lean, Green Virtualized Data Center Approach
by Mickey Iqbal, Dr. Mithkal Smadi, Chris Molloy, Jim Rymarczyk
Making the World Work Better: The Ideas That Shaped a Century and a Company
Kevin Maney, Steve Hamm, Jeffrey O'Brien
IBM Cognos 10 Report Studio: Practical Examples
Roger Johnson and Filip Draskovic
Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture
DB2 10 for z/OS Database Administration: Certification Study Guide
Susan Lawson and Dan Luksetich
Selling Information Governance to the Business: Best Practices by Industry and Job Function
DB2 9.7 for Linux, UNIX, and Windows Database Administration: Certification Study Notes
From Idea to Print - How to Write a Technical Book or Article and Get It Published
MDM for Customer Data - Optimizing Customer Centric Management of Your Business
Kelvin K. A. Looi
DB2 9 System Administration for z/OS (Exam 737)
Netezza Transformation: Taming the dragon without alchemy, sorcery or strange potions
The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights
Database Modeling and Design: Logical Design, Fifth Edition
Sam S. Lightstone, Toby J. Teorey, Tom Nadeau, H.V. Jagadish
Getting Started with IBM FileNet P8 Content Manager
Technical Blogging: Turn Your Expertise into a Remarkable Online Presence
IBM DB2 9.7 Advanced Administration Cookbook: RAW
Adrian Neagu, Robert Pelletier
Unleashing the Power of IBM Cognos Business Intelligence v10
DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS (6th Edition)
IBM DB2 9.7 Advanced Application Developer Cookbook: RAW
An Introduction to IMS: Your Complete Guide to IBM Information Management System, 2nd Edition
Barbara Klein, Diane Goff, John Butterweck, Kenny Blackman, Margaret Wilson, Moira McFadden Lanyi, Rick Long, Sandy Sherrill, Steve Nathan
The New Era of Enterprise Business Intelligence
by Michael Biere
Master Data Management and Date Governance, 2/E
by Larry Dubov & Alex Berson
Making it Big in Software
by Sam Lightstone
Enterprise Master Data Management: An SOA Approach to Managing Core Information
by Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul van Run, and Dan Wolfson.
The Art of Enterprise Information Architecture
by Eberhard Hechler, Martin Oberhofer, Steve Lockwood, Michael Schroek, Mario Godinez, Klaus Koeig
IBM Cognos TM1 The Official Guide
by Karsten Oehler, Jochen Gruenes and Christopher Ilacqua
I know… what happens in Vegas is supposed to STAY in Vegas. But I’m going to break that rule and give you links to a few videos that you’ll want to check out.
First, check out the interviews I did with some of the authors who were doing book signings at IOD11. I interviewed:
Sandy Carter about her latest book Get Bold: Using Social Media
Tony Giordano for his book Data Integration Blueprint and Modeling
James Taylor for his latest book Decision Management Systems: A Practical Guide to Using Business Rules and Predictive Analytics to Build Adaptive, Agile, Intelligent Systems
You can find all three videos on the IBM Press Book’s Channel on YouTube.
To go with the author them, remember to check out the audio interviews I did before the conference for the IM Skills Cast Series. I interviewed Roger Sanders, Roger Johnson, Filip Draskovic, Sunil Soares, and Bob Laberge.
Here are a few interesting clips that I found on YouTube that you may want to take a look at.
I’m already looking forward to IOD12. If you are too… here is the info so you can block your calendar and start building a justification to attend.
I’ve been working on these for the last month and I’m happy to announce that I have the first 7 podcasts finished and ready for you to download and listen to.
At this time I focused on the upcoming book and certification events that are taking place at the IBM Information on Demand Conference later this month. I hope to add many more podcasts to the series and plan to interview experts throughout the IM education area.
As I say in the introduction, this is the series that introduces you to authors, instructions and other subject matter experts in the IBM Information Management area. Here is what I’ve competed so far:
Episode 1: Conversation with Roger Johnson and Filip Draskovic
This is a discussion I had with Roger Johnson and Filip Draskovic about their latest book: “IBM Cognos 10 Report Studio: Practical Examples”.
Episode 2: Conversation with Roger Sanders
This is a discussion I had with Roger Sanders about his latest book “DB2 9.7 for Linux, UNIX, and Windows Database Administration: Certification Study Notes”.
Episode 3: Conversation with Bob Laberge
This is a discussion I had with Bob Laberge about his latest book "The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights".
Episode 4: Conversation with Susan Weaver
This is a discussion I had with Susan Weaver, the program manager for the IBM Information Management Certification Exams and the procedure to take them for free at the IBM Information on Demand Conference.
Episode 5: Conversation with Sunil Soares
This is a discussion I had with Sunil Soares about his latest book: “Selling Information Governance to the Business: Best Practices by Industry and Job Function”.
Episode 6: Conversation with Roger Sanders
This is a discussion I had with Roger Sanders about his latest book "From Idea to Print - How to Write a Technical Book or Article and Get It Published".
Episode 7: Conversation with Martin Keen
This is a discussion I had with Martin Keen from the IBM Redbooks team. We discussed what the IBM Redbooks are and the books that will be handed out at the IBM Information on Demand 2011 Conference.
There are so many people I’d like to interview for this series and now that my editing skills are improving, I’ll be able to do them more often with increasing levels of quality. If you’d like to do a podcast with me, let me know.
I hope you like these. Share your feedback.
And… here’s another Facebook change:
We have a NEW Facebook page!
We have just launched the IBM Information Management Skills Facebook page. This page features news on the latest courses, certification exams, books, consulting offerings and more. Need help finding a course? Maybe you need help deciding between an self paced or a classroom training. Perhaps you are looking for a book to study for latest DB2 Certification exam. Are you are beginning a migration and not sure what to do next, then this is the site for you! Don't miss out on this great forum! Click LIKE to become our fan today.
Enjoy the new page!
I’ve been creating an individual blog post for each of the flashbooks that we have scheduled for a giveaway and author signing at this year’s IBM Information on Demand conference. I now have session numbers assigned to each of the signings which means that you can add this event to your IOD schedule using SmartSite so that you don’t forget about it. You can find links to SmartSite for web or mobile connections, as well as a tutorial of how to use SmartSite on the Conference website: http://www.ibm.com/software/data/2011-conference/. Use the Session numbers listed below with the book information and register.
We have a limited number of the following “Flashbooks” and “IBM Redbooks” that will be given away at the appointed time. The authors of these books will be available to sign your copy. Note that registering for the session via SmartSite does not guarantee a book for you. You must still show up at the designated time before the limited supply of books have been given away.
Monday 9:45 - 10:45 am
Tuesday 9:30 - 10:30 am
Session #4125 Flashbook: Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data by Dirk deRoos, Chris Eaton, George Lapis, Paul Zikopoulos, Tom Deutsch
Monday 10:45 – 12:30 pm
Session #4202 IBM Production Imaging Edition and Datacap Taskmaster
Session #4203 Metadata Management with IBM InfoSphere Information Server
Both by the IBM Redbook Team
Tuesday 3:00 – 4:00 pm
Session #4204 DB2 10 for z/OS Performance Topics by the IBM Redbook Team
Wednesday 11:30 - 1:30 pm
Session #4205 IBM InfoSphere Streams and the Streams Processing Language
Session #4206 IBM solidDB: Delivering Data with Extreme Speed
Both by the IBM Redbook Team
Monday 12:30 - 1:30 pm
Session#4126 Flashbook: DB2 for z/OS Planning Your Upgrade: Reduce Costs. Improve Performance by Cristian Molaro and John Campbell
Monday 5:00 - 6:00 pm
Session #4127 Flashbook: Customer Experience Analytics: Fast, Intelligent and Action-Packed by Arvind Sathi
Also see my entry about the Book Signings that are taking place at IOD.
Note, as of today, October 12, 2011..... I've been informed that this book has been delayed. I am so sorry for the inconvenience and the trouble this delay is causing for the authors, bookstore and especially the test takers! Susan
Susan Lawson and Dan Luksetich have updated their popular certification guide and it is publishing just in time for the IBM Information on Demand 2011 Conference: DB2 10 for z/OS Database Administration: Certification Study Guide. This book will be sold at the Conference Bookstore for a 20% discount. Remember that Certification exams are free for attendees at IOD.
You can meet Susan and Dan at the Conference Bookstore and have them sign a copy of your book:
Once again, Susan is teaching the Pre-Conference Certification Crammer Course:(9Q001) DB2 10 for z/OS Database Administration Certification Crammer for Exam 730 & 612
Dan is speaking at the following session:
Explaining the IBM DB2 for z/OS Dynamic Statement Cache: Tuesday 11:15 – 12:15.
IBM DB2 for z/OS does a good job of caching dynamic SQL statements to avoid recompiling (also known as binding) the statements on the fly. This can save significant system resources. However, users still must determine what dynamic statements are coming in to DB2 and how they are performing. DB2 for z/OS has the ability to capture and report on the statements in the dynamic statement cache. The session will focus on the use and management of this facility, and how to report, understand and act on the available performance information.
What’s in the book?
- Read this book to prepare to pass Exam 612 – DB2 10 for z/OS Database Administration.
- All test objectives for this exam are covered in the same degree as they are covered on the exam.
- Susan and Dan were members of the exam development team, so are fully aware as to what questions are on the exam!
- Susan and Dan use DB2 every day and have 22 years experience.
While the book does cover all topics on the test, it also covers much more than that. It covers the new features of DB2 10 for both database and application development.
What do you need to know to pass the exam?
This is an outline of the Exam Objectives. You can see the details on the website: Exam 612 Objectives
730 Exam Objectives – Family Fundamentals
Section 1 - Planning (14%)
• Knowledge of restricting data access
• Knowledge of the features or functions available in DB2 tools (just tools that come with product - distributed space - i.e., configuration advisor, configuration assistant, command line processor)
• Knowledge database workloads (OLTP vs warehousing)
• Knowledge of non-relational data concepts (extenders)
• Knowledge of XML data implications (non-shreading)
Section 2 - Security (11%)
• Knowledge of DB2 products (client, server, etc.)
• Knowledge of different privileges and authorities
• Knowledge of encryption options (data and network)
• Given a DDL SQL statement, knowledge to identify results (grant/revoke/connect statements)
Section 3 -Databases and Database Objects (17%)
• Ability to identify and connect to DB2 servers and databases
• Ability to identify DB2 objects
• Knowledge of basic characteristics and properties of DB2 objects
• Given a DDL SQL statement, knowledge to identify results (ability to create objects)
Section 4 – Using SQL (23.5%)
• Given a DML SQL statement, knowledge to identify results
• Ability to use SQL to SELECT data from tables
• Ability to use SQL to SORT or GROUP data
• Ability to use SQL to UPDATE, DELETE, or INSERT data
• Knowledge of transactions (i.e., commit/rollback and transaction boundaries)
• Ability to call a procedure or invoke a user defined function
• Given an XQuery statement, knowledge to identify results
Section 5 - Tables, Views and Indexes (23.5%)
• Ability to demonstrate usage of DB2 data types
• Given a situation, ability to create table
• Knowledge to identify when referential integrity should be used
• Knowledge to identify methods of data constraint
• Knowledge to identify characteristics of a table, view or index
• Knowledge to identify when triggers should be used
• Knowledge of schemas
• Knowledge of data type options for storing XML data
Section 6 - Data Concurrency (11%)
• Knowledge to identify factors that influence locking
• Ability to list objects on which locks can be obtained
• Knowledge to identify characteristics of DB2 locks
• Given a situation, knowledge to identify the isolation levels that should be used
612 Exam Objectives
Section 1 - Database Design and Implementation (30.5%)
• Design tables and views
• Explain the different performance implications of
• Design indexes
• Create and alter objects
• Perform table space and index partitioning
• Normalize data and translate data model into physical model
• Implement user-defined integrity rules
• Use the appropriate method to create and alter DB2 objects
• Encoding schemes
Section 2 - Operation and Recovery (29%)
• Issue database-oriented commands for normal operational conditions
• Issue database-oriented commands and utility control statements for use in abnormal conditions
• Identify and perform actions that are needed to protect databases from planned and unplanned outages and ensure that timely image copies are taken periodically
• Load and unload data into and from the created tables
• Reorganize objects when necessary
• Monitor the object by collecting statistics
• Monitor threads
• Identify and respond to advisory/restrictive statuses on objects
• Establish timely checkpoints
• Identify and perform problem determination
• Perform health checks
• Develop backup scenarios
• Describe the special considerations for availability in a data sharing environment
Section 3 - Security and Auditing (7%)
• Protect DB2 objects
• Protect connection to DB2
Section 4 - Performance (29%)
• Plan for performance monitoring by setting up and running monitoring procedures
• Analyze performance
• Analyze and respond to RUNSTATS statistics analysis
• Determine when and how to run the REORG utility
• Understand and implement Real-Time Statistics & DSNACCOR(X)
• Analyze cache
• Evaluate and set appropriately the performance parameters for different utilities
• Describe the performance concerns for the distributed environment
• Describe DB2 interaction with WLM
• Interpret traces (statistics, accounting, performance) and explain the performance impact of different DB2 traces
• Identify and respond to critical performance thresholds
• Excessive I/O wait times
• Identifying lock-latch waits and CPU waits
• Identifying and resolving deadlocks and timeouts
• Review and tune SQL
• Dynamic SQL Performance
• Performance Features
Section 5 - Installation and Migration/Upgrade(4.5%)
• Run catalog health checks using queries and utilities
• Identify the critical DSNZPARMs
• Identify the migration/upgrade modes
• Identify and explain data sharing components and concepts such as:
For other IOD sessions related to DB2 10 for z/OS, see the Information Management Roadmaps.
Other blog entries about IOD Events: