The web is wonderful, but the web is evil! Wonderful because it contains so much content and evil because it contains so much content! It can be overwhelming to navigate through the content and if you don’t immediately find what you’re looking for, it is very easy to get distracted and forget what you were looking for in the first place.
My intention for this blog entry is to help those who use the DB2 for z/OS products find skills resources that are specific to you. I hope you find this content helpful!
IBM Data Management Magazine
The next generation of IBM Data Management magazine is available for you to read online. It has many great articles, including regular columns by Bonnie Baker and Robert Catterall.
Version 10 books:
So far, two books have published to support DB2 V10… but there are more coming.
DB2 10 for z/OS Database Administration: Certification Study Guide
by Susan Lawson and Daniel Luksetich
DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS (6th Edition)
by Craig Mullins
Version 9 books:
Version 9 is still being used by many, so you may find this book useful as well:
DB2 9 System Administration for z/OS (Exam 737) Study Certification Guide
by Judy Nall
“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.
DB2 for z/OS Planning Your Upgrade: Reduce Costs. Improve Performance
by Cristian Molaro and John Campbell and Sureka Parekh
DB2 10 for z/OS - Cost Savings ..... Out of the Box
by Roger Miller, David Beulke, Julian Stuhler, Surekha Parekh
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:
DB2 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:
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:
- Certification Assess & Save: March till May
- DB2 10 for z/OS Certification Roles, Exams and Study Materials
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:
- Surekha Parekh's Blog
- Wille Favero’s Blog
- Craig Mullin’s Blog
- Robert Catterall’s Blog
- Troy Coleman’s Blog
- Dave Beulke’s Blog
- Cristian Molaro’s Blog
- Triton Consulting’s Blog
- Martin Packer’s Blog
- The DB2 Exchange Forum
- The DB2 Night Show
My apologies if I missed your blog! Drop me a line and I’ll make amends :)
Suggestion… check out who these people are following. That will give you suggestions as to who else you may wish to follow.
Communities are a way for you to participate in conversations with other like minded people. You’ll find lots of resources, news about events, and perhaps access to experts.
- World of DB2 for z/OS
- DB2 10 LinkedIn
- DB2 for z/OS What’s On LinkedIn
- DB2 for z/OS YouTube
- WW IDUG LinkedIn Group
- IBM developerWorks
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.