Modified on by svisser1
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 not least, the latest Flashbook: DB2 11 for z/OS - The Database for Big Data and Analytics
By Cristian Molaro, Surekha Parekh, Terry Purcell & Julian Stuhler
This book is filled with
Business Value of DB2 11 in the new era of Computing;
Deeper insight into new functions and features of DB2 11;
Executive Summary of DB2 Tools & Utilities;
The objective of this book is to give our customers insight into DB2 11, which was announced on October 1, 2013. Everyone is talking about DB2 11. Many of our Early Support Program customers have been testing this product and are seeing some incredible results! Our customers and business partners around the world are very enthusiastic.
So what’s new in DB2 11 that is causing so much excitement? Here is a quick summary of some of the exciting new features and business benefits of DB2 11, about which this book will give you deeper insight:
• Even more out-of-the-box CPU savings
• Enhanced resiliency
Fewer planned outages, fewer REORGs, faster recovery
Cost-effective archiving, access warm/cold data in single query
DB2 Analytics Accelerator performance enhancements
Big data integration
In-transaction real-time scoring
Advanced QMF analytic capabilities with mobile support
• Simpler, faster upgrades for faster ROI
6x faster catalog migration
Protection from incompatible changes
Repeatable testing with real workloads and integrated cloning
The book is segmented into two parts. The first part is all about the business value of DB2 11 for z/OS and explains the unmatched efficiency for big data and analytics. This section also includes short papers on the DB2 11 Optimizer and the business value of IBM tools and utilities. The second section focuses more on DB2 and System z and how DB2 for z/OS can reduce the total cost of ownership for organizations. With the enormous explosion of data, this is more critical now than ever before. We hope you find this book as valuable as our previous versions.
Download your free copy today. Flashbook: DB2 11 for z/OS - The Database for Big Data and Analytics
For those attending IOD this year, stop by the IOD bookstore on Monday, Nov 4 to get your free printed copy!
Modified on by svisser1
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 everyone offers a marketing bundle just like the mainframe, and while some of these solutions have some basic capabilities, DB2 for z/OS and System z continue to lead the way with fresh capabilities to handle rapidly changing, diverse, and unpredictable workloads while maximizing resource utilization and investment.
During 2013, IBM will celebrate the 30th anniversary of DB2 with customers, business partners, users, employees, and DB2 fans all around the world. DB2 11 Early Support Program was announced in October 2012, with General Availability expected to follow shortly.
This book, The Business Value of DB2 for z/OS: IBM DB2 Analytics Accelerator and Optimizer, is packed with rich information to help you manage your IT business systems. Namik Hrle, Ruiping Li, and Wolfgang Hengstler cover the key design and operational aspects of IBM DB2 Analytics Accelerator that enable DB2 for z/OS clients to benefit from faster performance, reduced CPU usage, and lower costs. Terry Purcell gives a technical overview of how IBM DB2 for z/OS Optimizer addresses key customer pains such as reducing total cost of ownership while maintaining stability and reliability. John Campbell discusses the planning stage of migrating to IBM DB2 10 and reveals secrets to ensure a successful upgrade.
Find out why DB2 is still growing after 30 years and how it is helping our customers to reduce costs and grow.
John Campbell is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab. He has extensive DB2 experience in terms of systems, database, and applications design and specializes in design for high performance and data sharing. John is one of IBMs foremost authorities for implementing high-end database/transaction processing applications.
Namik Hrle works in the IBM Boeblingen Development Laboratory and is the labs chief Information Management technologist, responsible for strategy and technology directions. As an IBM Distinguished Engineer and a member of the IBM Academy of Technology, he belongs to a small circle of the top technical leaders whose work and expertise affect the direction of IBM.
Ruiping Li is a Senior Engineer in DB2 for z/OS development at IBM Silicon Valley Lab. She is the technical lead responsible for the DB2 query acceleration support for the IBM DB2 Analytics Accelerator.
Surekha Parekh is IBM’s World- Wide Marketing Program Director for DB2 for z/OS and leads the Social Media Strategy for Information Management on System z. She is responsible for market strategy and planning of DB2 on System z and building social media communities for Information Management System z.
Terry Purcell is a Senior Technical Staff Member with the IBM Silicon Valley Lab, where he is lead designer for the DB2 for z/OS Optimizer. Terry has two decades of experience with DB2 in database administration and application development as a customer, consultant, and DB2 developer.
You can buy a copy of this book from amazon in printed or kindle format. A limited number of printed copies will also be handed out at select conferences.
Download a free copy: Flashbook Download
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
applications in a data sharing environment generally follows the same
best practices as running any DB2 for z/OS application. Applications
have a role to play in continuous availability. Only relatively minor
changes are required to avoid locking hot spots. This presentation
explores specific best practices of application design and database
design in a data sharing environment. It drills into the topics of
locking considerations, high-volume inserts, sequential keys, bind
options, and batch processing. It also describes how to deploy
applications in a data sharing environment with minimal down time.
This webcast is now available via the DB2 for z/OS Best Practice community.
It includes the video (either download or stream from YouTube),
transcript, and slides. If you stream from YouTube, you can view in HD
with Closed Captions either on or off.
Keep the DB2 for z/OS Best Practice community website as a bookmark and visit often as there are many gems waiting for you to discover!
PS... Thanks to Serge Boivin and David Salinas for sharing this information with me.
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 presentation.
Sreeharsha - High Data Availability: solutions and techniques
clearly defined. Problem clearly defined. Presentation was well put
togetehr and rehearsed. This is the way it’s done!
Armando - Dare to be Different (Against all Dogmas) SQL Performance Tuning
Be open minded on how to solve problems. You may find a creative solution that wasn't’ expected
Entertaining and engaging presentation with a great amount of style.
Congratulations to Sreeharsha, Armando, and Mikko for moving to the next level.
sure to join us next week to hear presentations from me, Martin, Klaas,
and Martin. Your turn to evaluate us! Just for fun, of course. Come
and have some fun!
Over 219,000 downloads of past DB2Night Show episodes! Congratulations Scott!!
If you missed the show, see the replay!
sure to fill out the survey when you do... you may be the lucky winner
of a $25 certificate to use at Amazon.com. Perhaps there is a DB2 book
you’d like to purchase?
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: Visit the new IM best practices community portal often to
find a wealth of practical expert advice for your business success.
More papers are being added regularly, so become a member of the
community to ensure that you won't’ miss a single paper.The
portal connects you to best practice communities for a variety of IBM
Information Management products.The best practice papers, technical
presentations, and videos published in each community cover a wide range
of topics to help you plan, design, implement, tune, and monitor your
solutions so they perform at their best in your environments,
potentially saving you time and resources. The best practices are
written and tested by IBM technical experts who work in the development
and quality assurance teams that created the product features, and who
work with customers like you to determine the best ways to efficiently
use Information Management products in real world environments.Some of the topic areas you’ll find:Thanks to Serge Boivin for providing me with this information. Susan
Congratulations to author and IBM Champion Tony Andrews
on his new book:
DB2 SQL Tuning Tips for z/OS DevelopersThis
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
software or tuning existing systems. He fully reflects the latest DB2
SQL programming best practices up to and including DB2 V9 and DB2 V10 on
Buy directly from the publisher to save 35%, using discount code IBM8460 plus free ground shipping within the U.S.
If you're in Europe, you can purchase this book
and many others in the IBM Press series at 35% off the retail price, plus free shipping in the UK and discounted in other countries.
More about the book:
largest database tuning performance gains can often be obtained from
tuning application code, and applications that use SQL to retrieve data
are the best candidates for tuning. This well-organized,
easy-to-understand reference brings together more than 100 SQL-related
skills and techniques that any developer can use to build and optimize
DB2 applications for consistently superior performance.
tuning expert Tony Andrews (“Tony the Tuner”) draws on more than 20
years of DB2-related experience, empowering you to take performance into
your own hands, whether you’re writing new software or tuning existing
systems. Tony shows you exactly how to clear bottlenecks, resolve
problems, and improve both speed and reliability.
This book fully
reflects the latest SQL programming best practices for DB2 V9 and DB2
V10 on z/OS: techniques that are taught in no other book and are rarely
covered in general DB2 SQL courses. Drawing on his extensive consulting
experience and highly praised training with Themis Inc., Tony also
presents practical checklists and an invaluable 15-step methodology for
optimizing virtually any DB2 application.
- Empowering developers on knowing what to do and where to look in resolving performance problems in queries or programs
- Providing many programming and SQL coding examples
- Establishing standards and guidelines that lead to high-performance SQL
- Implementing time-efficient code walkthroughs to ensure that your standards are followed
- Focusing on the small number of SQL statements that consume the most resources
- Identifying simple solutions that deliver the most sizable benefits
- Optimizing performance by rewriting query predicates more efficiently
- Providing a better understanding of SQL optimization and Runstat statistics
- Recognizing opportunities to tweak your code more effectively than the Optimizer
- Optimizing SQL code with COBOL applications
- Efficiently checking for the existence of data, rows, or tables
- Using Runstats’ newest capabilities to consistently optimize paths to data
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 has published two books this year! What a great accomplishment.
Craig on Tuesday, October 23 from 12:00 – 1:00 pm at the IOD
bookstore. These books can be purchased at the IOD bookstore for a 20%
Brian Green, John Boyer, Kay Van De Vanter
Roger is a prolific author with more books to come:
books should be available at the IOD Bookstore at a 20% discount. If
you are a champion and have a book idea, drop me a line!
Flashbook: IBM DB2: The Past, Present and Future: 30 Years of Superior Innovationby Surekha Parekh, Terry Purcell, John Campbell, Ruiping Li and Don Haderle
About the book:
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 only full of
RICH, TECHNICAL content but is will also be a "keepsake" for DB2 fans
For further information on the 30th Anniversary details, see Surekha’s blog: New Book To be Launched at IBM Information On Demand: IBM DB2: The Past, Present and Future
If you are attending the IBM Information on Demand Conference, get a free printed copy of this book at the Author Signing and Giveaway that is scheduled:
This is a limited edition book and limited copies will be printed so don't miss the book signing.
- Monday October 22, 12:30 – 1:30 at bookstore
the conference is over, a free e-version of the book will be available
for you to download. Follow my blog to ensure that you are one of the
first to know where you can download the book.
Other sessions by these authors:
# 2032A - IBM DB2 for z/OS Migration: Query Performance Considerations
- Islander A; Tue, Oct 23, 2012; 8:15 AM - 9:30 AM
# 1723A - Application Best Practices and Recommendations Specific to
IBM DB2 for z/OS Data Sharing - Islander A; Tue, Oct 23, 2012; 11:15 AM -
# 4012A - IBM DB2 10 for z/OS Migration Planning and Experiences -
Part 1 - Islander A; Wed, Oct 24, 2012; 10:45 AM - 11:45 AM
# 4013A - IBM DB2 10 for z/OS Migration Planning and Experiences -
Part 2 - Islander A; Wed, Oct 24, 2012; 12:00 PM - 1:00 PM
- Session # 3942B BOF: IBM DB2 for z/OS and Tools: Ask the Experts Panel - South Pacific F; Wed, Oct 24, 2012; 6:15 PM - 7:15 PM
# 1840A - Protecting Your IBM DB2 for z/OS Assets With Effective
Backup and Recovery Strategies - Islander A; Thu, Oct 25, 2012; 8:15 AM -
- Session # 1845A - Runstats Challenges for Optimal Query Performance - Islander B; Mon, Oct 22, 2012; 11:30 AM - 12:30 PM
# 3922B BOF - New SQL Function and Performance in DB2 10 for z/OS -
Bayside Dining IM BoF Tables 5&6; Tue, Oct 23, 2012; 12:45 PM - 1:45
- Session # 2049A - Do These IBM DB2 10 Optimizer Enhancements Apply to Me? - Islander B; Wed, Oct 24, 2012; 12:00 PM - 1:00 PM
# 3923B BOF - Query Performance Challenges with DB2 10 for z/OS -
Bayside Dining IM BoF Tables 3&4; Wed, Oct 24, 2012; 1:15 PM - 2:15
# 2054A - The IBM DB2 Analytics Accelerator Hands-On Learning Lab -
Shorelines B Lab Room 1; Thu, Oct 25, 2012; 9:30 AM - 12:30 PM
- Session # 2991A - Social Business for IT Professionals: Career Enhancements - Islander B; Mon, Oct 22, 2012; 3:45 PM - 5:00 PM
# 3921B BOF - IBM DB2 for z/OS e-Communities, Collaboration Groups
-Social Networking World - Bayside Dining IM BoF Tables 3&4; Tue,
Oct 23, 2012; 12:45 PM - 1:45 PM
Free printed IBM Redbooks at IOD
Look at all these great FLASHBOOKS that will be at IOD this year!
Look at all these great books that will be at IOD this year!
Get Certified at the IBM Information on Demand Conference
Bare Naked Ladies – at IOD
Nate Silver – book signing & speaker at IOD
Books published in 2012 – Featured Titles
Top 25 Books Sold at IOD2011
hope you enjoy this new book. Find out why DB2 is still growing after
30 year and how it is helping our customers to reduce costs and grow.
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.
If you're in Europe, you can purchase this book
and many others in the IBM Press series at 35% off the retail price,
plus free shipping in the UK and discounted in other countries.
About the book:
Database Administration, Second Edition is the definitive,
technology-independent guide to the modern discipline of database
administration. Packed with best practices and proven solutions for any database
environment, this book fully reflects the field's latest realities and
challenges. Drawing on his unsurpassed database experience, Craig focuses on the
problems today's DBAs actually face, and the skills and knowledge they simply
must have. Craig covers every aspect of the DBA role, including creating
database environments; data modeling and normalization; design; performance;
data integrity; compliance and governance; security; backup/recovery; disaster
planning; data and storage management; data movement/distribution; data
warehousing; database connectivity; metadata; tools, and more.
This edition's updates and improvements include:
- New coverage of "Big Data," database appliances, cloud computing, NoSQL, and
other crucial trends
- An all-new chapter on regulatory compliance and the DBA
- New material on data breaches, auditing, data encryption, data retention,
database archiving, data masking and sound metadata management policies
- Coverage of important new features in leading databases (e.g. temporal data,
- End of chapter questions that reinforce readers' understanding and can serve
as project-oriented classroom assignments
- New glossary and updated DBA "rules of thumb"
Meet Craig on Tuesday, October 23 from 12:00 – 1:00 pm at the IOD
bookstore. These books can be purchased at the IOD bookstore for a 20%
discount. Meet Craig and find out how he managed to publish two books in a
Also attend Craig’s IOD session: 1066A Ten Breakthroughs That Changed IBM
DB2 Forever; Thu, Oct 25, 2012; 10:00 AM - 11:00 AM - Islander B
Follow Craig’s Blogs & Twitter account as well:
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
- Cristian Molaro
- Klaas Brant
Tuesday 16 October
Wednesday 17 October
Thursday 18 October
October 16-18, 2012 – Chicago DB2 Symposium
- Location: Downers Grove – Chicago, IL
For further information, use the menu on the left hand side of the DB2 Symposium webpage where you
can navigate to the sessions, pricing, location and more.
Thanks to Klaas Brant, KBCE – DB2 Symposium Organizer, for
providing me with this information.
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.
Specifically: Columnist Roger Sanders:
Database Journal http://www.databasejournal.com/features/db2/
is not an IBM controlled asset, but has both IBM and non-IBM contributors. I’d
like to specifically mention:
Here is a collection of the blogs that I recommend for the DB2 for
Linux, UNIX and Windows products:
Management– by Crysta Anderson is an amazing blog. Crysta has been
very busy interviewing our IBM Champions and thus far has 27 interviews! Each
one is worth a read to find out who these friends of IBM are and what their
passions are: Sheryl Larsen, Scott Hayes, Ole Holmskov, Fred Sobotka, Kim May, Marc Herbert, David Birmingham, Cristian Molaro, Lester Knutsen, Stuart Litel, Isaac Yassin, Dave Beulke, Dan Luksetich, Alex Philp, Iqbal Goralwalla, Bonnie Baker, Cecilia Rodriguez Babino, Miguel Carbone, Martin Hubel, Ced Bufton, Julian Stuhler, Michelle Christensen, Jim Harris, Frank Brooks, Rick Biederstadt, Cuneyt Goksu, and RogerSanders.
Computing Blog by David Pittman and others is a blog worth
bookmarking. There is a regular feature called Top Reads for the Week where
excerpts and links are provided for recent blog entries, articles, videos, or
podcasts about IBM Information Management Technology.
Ember Crooks’ blog: DB2 for WebSphere
Commerce, LinkedIn Profile, and Twitter ID.
Mike Krafick is just starting his writing career as a guest blogger for
Scott Hayes’ DB2Night Show Blog
Rebecca Bond’s Blog SecureDB2
Brian Fairchild’s Blog Xtivia
Sameer Kumar’s Blog DB2 Performance
Troy Coleman’s Blog DB2Tutor
Robert Caterall’s Blog DB2
Daniel Krook’s Blog Krook
Triton’s Blog Thoughts on DB2 with Julian Stuhler and others. See also, Confessions of a DB2 Geek.
Craig Mullin’s Blog DB2 Portal
Dave Beulke’s Blog DB2
It looks like we have a very active community! I’m glad we do and appreciate
all the work that these and others put into sharing their knowledge about IBM
products. I know I didn’t point out everyone… and for that I’m very sorry. To
make sure you find all the great blogs about DB2 and related products, check out
PlanetDB2.com… every day! This is a
Blog Aggregator of all DB2 related blogs. If you blog about DB2 and want to be
included, follow the instructions found on the page and we’ll be happy to read
what you write!
Show – Klaas Brant and Scott Hayes are my heroes for the
amount of work they have put into this awesome weekly webinar. They manage to
attract so many guests that they now have two tracks: one for LUW and one for
z/OS. The invite both IBMers and non IBMers to share tips and information about
DB2 with their listeners. If you miss a show, don’t worry. Scott and Klaas
record them all and now have a massive library for you to choose great content
from. I’ve been a guest on the show as well as a judge for the “DB2’s Got
Talent” Competition. If you have an idea for future shows, let Scott or Klaas
know. If you want to improve your presentation skills, especially related to
DB2, consider becoming a contestant in the next round of DB2’s Got Talent
An InformationWeek Live WebCast: High performance. Low cost. No longer an either/or decision for
your database with Fred Sobotka and Lynn Jonas. This is a
recorded webcast, so fill in the information to immediately download the
I’m friends with many DB2 Talents, so I see updates on what people are doing
as they post it. There are IBM Facebook sites where you could and should use to
promote your blog or an event you are involved with…. of course, only if it is
related to IBM Information Management technology :)
I’d suggest these pages:
One event I want to make you aware of will come up soon on the Information Management Skills Facebook page. We’ll have live
chats with authors Dan Luksetich and Craig Mullins to discuss
their books. This is our first time doing this, so become a fan of the page
and watch for news as to when this event is taking place and how you can
I was going through the list of the books that are being published this year
and was happy to notice that the majority of the authors who I work with these
days are IBM Champions. Some of the authors I work with: Craig Mullins, Roger
Sanders, Dan Luksetich, Susan Lawson, Cristian Molaro, David Beulke, and Julian
Share your opinion, on these and all sites that you check out... everyone
will appreciate it :)
PS: This list is NOT exhaustive. If you think I’ve missed something of
interest, let me know. Thanks!
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.
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 them, notifications of undocumented
incompatible changes, highlighting critical HIPERs, sample code and more. We
will use the Exchange as a mechanism to share high value/high importance
Sounds like a very helpful place to visit for important information. Get the
RSS feed or add a bookmark to the Exchange so you can visit often.
Thanks to Lisa Johnson for this information.
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
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
the 7 remaining contestants from Round 2 present 6-minute technical
presentations to us. Once again, we ended up with very high quality
presentations from very experienced users of DB2 products.
Here’s a summary of what happened:
Contestant 1 – Kohli
App Design Change Results in Significant Performance Gain
Kohli was in the top 3 of the votes from Round 2. Kohli showed how he used
Explains to analyze the performance his company was experiencing with their
queries. They looked at the design of the app to understand why the query was
so costly. They made the appropriate changes and re-ran explain to find that
the performance was significantly improved. Conclusion: It is very important to
work with application developers to ensure that performance is the best it can
be. This is a classic example with figures to back up the conclusion. Very
Contestant 2 – Brian
Jack Bauer – DB2 DBA
Brian was also in the top 3 of the votes from Round 2. Brain did a parody of
Jack Bauer from TV show “24”. (An Aside.. Did you know that Keifer Sutherland
who played Jack Bauer in the series is Canadian?) Very creative with lots of
suspense. Brian made the job of a DBA look sexy and heroic. Brian tweets at https://twitter.com/#!/fairchild_db2
and blogs at http://bit.ly/yGpae2 .
Contestant 3 – Douglas
DB2 LUW & DB2 z/OS – Problems with Timestamps
Douglas was in the bottom 4 of the votes from Round 2. His presentation was
about issues he’s experienced with timestamps: can’t use mass inserts or updates
and nested triggers won’t work. Douglas clearly stated the problem and showed a
solution that works for for both LUW and z/OS. Conclusion: They ended up
saving 36 hours of processing time for a warehouse application. Very well
Contestant 4 – Jean
How the Sysplex Distributor got our Web Apps out of a Pickle
Jean was in the bottom 4 of the votes from Round 2. Jean did a fabulous job
of explaining the problem and her trial and error approach to finding an
appropriate solution. Great call out to IBMer & Redbook author Jim
Pickel. Excellent presentation with material that will be very helpful for
Contestant 5 – Ember
Four Missing Indexes That Almost Ate The Year’s Revenue
Ember was in the bottom 4 after votes from Round 2. Quite a surprise to me!
This presentation centered around problems that can occur during Black Friday
and Cyber Monday for e-commerce sites. Real life and critical to solve. Index
read efficiency was over 10,000… why? Ember found problems in the top two
queries. She gives a detailed description to her analysis of the queries. New
indexes were implemented and huge improvements were seen and the client was able
to see an increase in 637% in revenue!! Way to go! Very well presented with
huge impacts to business objectives. Ember tweets ember_crooks & blogs http://db2commerce.com/.
Contestant 6 – Rodolpho
Migration of DB2 for z/OS running SAP from Version 8 to 9. How I succeed
Rodolpho was in the bottom 4. Rodolpho’s presentation took us through the
considerations of migrating a database that is running SAP. They had to consider
whether to migrate to DB2 9 or 10 and chose 9. Very good descriptions of what
to do with SAP. Lesson learned: plan, plan, plan. Great to see a presentation
on this topic. You can follow Rodolfo on twitter: https://twitter.com/#!/_rodc
Contestant 7 – Elder
Reclaim Space – Easy in Db2 v9.7 and Show Off!
Elder was in the top 3, but there were major technical problems that required
Scott to make emergency contingency plans. Elder recorded his presentation and
posted it on Youtube. You can find the link on the DBI's website: Episode #75: DB2's GOT TALENT Finals Round #3
The judges, Martin Hubel, Klaas Brant, and Julian were
asked to save one of the bottom 4 presenters based on the voting from the past
two weeks. It was a tough decision, but the judges decided to save
Jean! Congratulations Jean! I’m sure the decision was difficult to make
as all the contestants are truly talented presenters and have much success ahead
100% of the listening audience said they learned something new today. How
about you, listening to the replay? Did you learn something new?
Now the control is with you the listeners. After you watch the replay,
VOTE! I’m glad I don’t get to choose… there is such great talent appearing
on this show that it will be very difficult to choose.
The control is now in the hands of you, the audience. You must vote
for Our Top 4 Finalists to determine who wins the Grand Prize! Here’s what you
need to do. If you were in the audience, vote in the survey provided for who
you thought was the best. If you weren’t able to make it to the show, watch the
replay, and then VOTE. Don’t watch just to vote, watch to learn great DB2 tips
as well as examples of excellent presentation skills.
Thanks to host Scott Hayes for this opportunity for me as a judge and
for the contestants for helping them build technical presentation skills that
are so valuable.
For details on the prizes for this competition… and a summary of last year’s
event… see my blog entry: http://ibm.co/AnZxb4
See also: Session 1 of the DB2’s Got Talent
See also: Session 2 of the DB2’s Got Talent
See also: Session 3 of the DB2’s Got Talent
See also: Session 4 of the DB2’s Got Talent
See also: DB2’s Got Talent Finals – Round
See also: DB2’s Got Talent
Finals – Round 2