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 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
Version 9 books:
Version 9 is still being used by many, so you may find this book useful as
“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:
9 for z/OS: Packages Revisited
Redbooks, published 2 Mar 2009,
last updated 3 Feb 2012, Rating:
(based on 7 reviews)
10 for z/OS Technical Overview
Redbooks, published 30 Dec
2010, last updated 6 Dec 2011, Rating:
(based on 3 reviews)
10 for z/OS Performance Topics
Redbooks, published 21 Jun
2011, last updated 6 Dec 2011, Rating:
(based on 3 reviews)
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:
Full-Day Educational Seminars at
the IDUG DB2 Tech Conference
The following topics are Select from these topics:
DB2 10 for z/OS DBA Certification Crammer Course: Susan Lawson,
This course is a certification preparation course intended to
help you take DB2 9 Family Fundamentals exam (730) and DB2 10 for z/OS Database
Administration exam (612). Passing of these exams will result in certification
as an IBM Certified Solutions Expert - DB2 10 z/OS Database Administration.
Participants are expected to have fundamental knowledge of relational principles
in addition to applied working knowledge of DB2 9 for z/OS and basic knowledge
of DB2 10 features. Susan’s latest book will also be available, for sure before
the conference and hopefully at the conference.
Recommended Best Practices from Customer DB2 Health Check Studies:
John Campbell, IBM DB2 for z/OS Development
This one day
seminar will introduce and discuss the major lessons to be learned from customer
DB2 Health Check Studies carried out by DB2 for z/OS Development and provide
recommended best practices in each area. The objectives are to: introduce and
discuss the most common issues, share the experience gained from customer health
check studies, share the experience from live customer production incidents,
provide proven recommended best practice, and to encourage proactive behavior.
The following topics will be covered: WLM Policy Setup, Balanced Design across
CICS and DB2 Disaster Recovery, use of Flashcopy, Continuous Availability vs.
Fast Failover, Preventative Software Maintenance, Multiple Data Sharing Groups.,
Running Multiple DB2 Subsystems on same LPAR, Normal DB2 Warm Restart vs.
Restart Light, Storage Tuning. Download John’s Flashbook for free: DB2
for z/OS Planning Your Upgrade: Reduce Costs. Improve Performance (3.36MB)
I Didn't Know DB2 did THAT!: Bonnie Baker, Bonnie Baker
Have you ever wondered what goes on inside DB2 when your SQL is
being executed? This seminar is designed to answer exactly that question and
more by taking a look at DB2 Components and the Optimizer's instructions for
various SQL access paths. While simple paths will be reviewed, this class will
also focus on those difficult to understand access paths. Topics include RIDPOOL
failures, Hybrid Joins and a "Type C" Hybrid Join, coding both a GROUP BY and an
ORDER BY on the same columns to insure that my GROUPs are returned in ORDER,
using a 64-partition DPSI for SORT Avoidance, how does DB2 know if Index-Only
data is "clean" or "dirty", result sets built at OPEN CURSOR, DSNZPARMs affects
on access path selection and operation and much, much more!
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
More and more people are getting on twitter. If you’re not yet…
the one thing you should know about twitter is it is great resource for up to
the minute information. You don’t need to tweet anything yourself… you can
simply follow others to hear what they’re saying. In a single location you can
get news about your favourite products, rock stars, world events, and more.
Here are a few twitter handles you may wish to follow.
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.