Conferences are a great way to learn a great deal in a short period of time
and also a great way to meet people in the industry. Unfortunately, not many
people are able to get budget to travel to the big conferences such as IDUG or IOD. The next best thing is to
attend regional user conferences that bring the best of the best speakers to a
location close to your home or office.
The are many regional user groups that take place regularly across the world,
but the one I’ll tell you about is the one in my local: Toronto / Markham:
Central Canada DB2 Users Group.
This year’s meeting takes place June 11-12, 2012 at the Institute for
What can you expect at this meeting? As usual, great speakers, great topics,
networking opportunities, certification exams, and I may even show up to give
people copies of the latest DB2 Flashbook.
Summary of Sessions and Speakers:
“BIG Data"Paul Zikopoulos, IBM
"Half Day with Bonnie Baker"
Bonnie Baker, IBM Champion
"What Can I Do To Protect DB2 Against Warehousing, WebSphere, and
Adrian Burke, IBM
Adrian Burke, IBM
"Outer Joins – Taking a Closer Look"
"Desperate challenges call for desperate measures"
Joe Burns, Highmark Inc.
"A New Catalog and Directory Structure in DB2 for z/OS"
Jim Dee, BMC Software
"Looking Behind the Curtain of DB2 for z/OS 10 Performance and
Scalability: Storage Monitoring and Control"
John Campbell, IBM UK
"Gain Insight into DB2 for z/OS 10 Performance Updates and SAVE
John Campbell, IBM UK
"The Importance of Being Consistent - DB2 for z/OS and Remote Copy
Services for IBM System z"
Florence Dubois, IBM UK
"The Many Uses of Flash Copy with DB2 for z/OS"
Dubois, IBM UK
"Temporal Data - An Insurance Policies Life"
Grainger, Cogito/Grainger Database Solutions Ltd.
"Application Performance - Tuning, Trending and Testing"
Phil Grainger, Cogito/Grainger Database Solutions Ltd.
"Switching – What IS Access Path Stability?"
Grainger, Cogito/Grainger Database Solutions Ltd.
"It Could Happen To YOU – Scary Disaster Stories, Lessons Learned,
NOTHING is Impossible"
Phil Grainger, Cogito/Grainger Database
"DB2 for z/OS Utilities Update"
Haakon Roberts, IBM USA
“Goin' Mobile [Beep Beep]"
John Mallonee, Highmark Inc.
“Take a REST from Using SOAP"
John Mallonee, Highmark
“All the things Query Tuning : Data Studio & Query Workload
Saghi Amirsoleymani, IBM USA
A unique opportunity of a
full day (Monday) hands-on workshop with IBM’s Data Studio
“Which DB2 High Availability Technology is Right for You?"
Chris Eaton, IBM Toronto
“Does Anybody Really Know What Time It Is?”
Hubel, MHC Inc.
“Deep Dive into DB2 10 Query Performance Optimization: Statistics and
John Hornibrook, IBM Canada
“Storage for DB2 Server"
Thomas Kalb, ITGAIN
“DB2 10 for LUW - Early Experiences with Storage Management and
Vijay Sitaram, McKesson Corp.
Co-presenting with Kelly
Schlamb, IBM Canada
“Upgrade Best Practices to DB2 10 for LUW”
Stopfer, IBM USA
“Stuffed with Great Enhancements DB2 9.7 Fix Pack New Features”
Melanie Stopfer, IBM USA
IDUG EMEA 2011 Best Overall
IBM Certification Exams :Tuesday June 12th
the Technical Conference will be offering the opportunity to take IBM
Certification exams – courtesy of IBM Canada. The first exam will be offered
free. Re-takes or additional exams will be offered at a 50% discount on the
regular fee. There are limited time slots. A signup sheet will be available at
registration on Monday June 11th for attendees to schedule their exam(s).
Click here to see the available exams.
- Registrations must be received by Friday June 1st, 2012. Link to Registration
- Register before May 11th, 2012 to be eligible our Early Bird draw ($200 Gift
- Sorry - NO WALK-INS.
- Email: firstname.lastname@example.org
- Presentations and speakers: Program
(Updated May 28)
- Registration Includes:
Entry to track for EITHER DB2 for z/OS OR DB2 for LUW
Continental breakfast, coffee breaks, and lunch
- Vendor reception
Come for the learning, but have a bit of fun while your at it! Looking
forward to seeing everyone!
You can save up to 35% off the normal prices of IBM Self-paced Training
IBM's self-paced virtual classes (SPVC) are classes that
allow you to set your own schedule yet still deliver the same content,
interactive exercises, and hands on labs as IBM’s classroom training.
It allows you to take control of your learning --when and where you want.
- The typical self-paced virtual class is a 30 to 80 hour, online course that
uses web-based reading assignments
- Multimedia presentations based on the same great content used in our
- Most classes offer content support by instructors and subject matter experts
- Interactive exercises and hands on lab assignments using the actual product
- Flexibility to train at your own pace
- Training from your desktop
- The course and labs for all courses are available 24x7
- High quality content
- No travel costs
- Lower tuition
- Quizzes are incorporated at the end of each module to provide students with
feedback on their comprehension of the material
- Modular and scalable lessons
- Many classes offer interactive and prescriptive training
- Delivers same content, exercises and hands-on labs as classroom courses
- For many classes, instructors are included “virtually” through recorded
lecture and demonstrations
- Conduct hands-on labs using the actual IBM products
- Recorded audio-narrated presentations and demonstrations available for many
- Online versions of student manuals, workbooks, and other class materials
For products in the Information Management area, you can choose courses that
correspond to 17 different tasks, including Administration, Troubleshooting, and
Here are the courses that I found that were listed as New:
interest before June 22 to get the Promo code.
When 365 people register their interest, your savings will increase from 25%
You benefit by sharing this offer with others. Register now!
I just got this note from Dean and thought I’d share it with you. I’m quite
impressed by the content that Dean has created and want to make sure you are
aware that this content exists. Thanks Dean!
New db2Dean.com Article - DB2 10.1 New Features
became available on 30 April 2012 and has TON of new features and improvements,
some of which you can begin taking advantage of without doing anything other
than upgrading your database. As with the past “features” articles, this is a
summary of the new features in v10.1 that I see as the most important. My hope
is to provide a summary that you can browse to quickly find the items that are
the most valuable to you and to provide links you can click to do more in depth
reading on them. A number of features have been discontinued in v10.1, most
notably Control Center and many of the GUI tools that you access from it like
Command Center. I summarize these discontinued and deprecated functions in this
article. See http://www.db2Dean.com for
the rest of the article.
Want some Compression with that database, honey?
wondered what features are included with which edition of DB2 and which need to
be ordered separately? For example, did you know that pureScale is included in
DB2 Workgroup edition, but must be purchased separately with DB2 ESE and
Advanced editions? Well, now there is a page on the web where you can view a
chart showing which features are in which editions. It can be found at: http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.licensing.doc/doc/r0053238.html
DB2 10.1 Favorite Links
I have updated my "Favorite
Links" page with links to the DB2 10.1 manuals, information center and other
good v10.1 stuff. http://www.db2dean.com/Previous/DeanLinks.html
DB2 v9.1 now OUT of SUPPORT
DB2 v9.1 went out of support
on April 30 of this year. If you are still running any DB2 servers or clients
on that version you should upgrade them ASAP. See the Upgrade Portal for logs
of help with this task: http://www.ibm.com/support/docview.wss?rs=71&context=SSEPGG&uid=swg21200005
The Falcons are Back
The Peregrine Falcons are back in
their nest in Salt Lake City this year and the web cam is still on them. See
the parents and chicks live at: http://wildlife.utah.gov/dwr/learn-more/peregrine-cam.html
Generally "Camera 2" has a better angle .
New DB2 Fix Packs Available
- - Fix Pack 6 for DB2 v9.7
was released on May 30 . See entry called "Recommended group:
- Fix Pack download links can be found
- DB2 v10.1 Proof of Technology July 18-19 in Salt
Lake City. Get your hands on the latest features at this great event. For more
information and registration, see https://events.webdialogs.com/portal/wippages/register.php?id=c92b63969e&l=en-US
Keep up with regularly scheduled, technically oriented conference calls by
checking the "Technical Conference Calls" link on my home page under "Online
Events". You can also see my events on Facebook at http://www.facebook.com/db2Dean#!/db2Dean?sk=events
As I get new contacts I add them to my broadcast
list. If you do not wish to receive further SPAM from me, please reply and ask
to be removed from my list. On the other hand if you find this really useful,
please pass it on to your friends and colleagues.
Please note that I keep all previous articles on my website for your
reference. You can find them by going to my home page and clicking "Previous
Articles" or by following this link: http://www.db2dean.com/Previous/Prev.html
Thank your for liking me on Facebook! I now have my own db2Dean page at
Facebook.com/db2Dean! On this page I hope to create a
community where you can add your thoughts to help others and to help me improve
my website. I'll post events that may interest you and abstracts of all new
db2Dean articles. I'll also make frequent posts about what I'm talking to my
customers about and thoughts about why those topics may interest you. Like I so
frequently do, I made an irreversible mistake when I created this page, so
you'll need to like me there again to follow posts.
I've created a developerWorks Group that you can join.
These on line groups are for sharing information, so please join. You can read
additional information and add comments and blog posts that you think will help
other DB2 professionals. You can add script files and other files that you
think might help others. I've added each of my articles as a link in the
"Bookmarks" section of the page. You can click the "view all" link at the
bottom of the section and then it opens up a "details" link for you to see
abstracts. Please note that I call my group "db2Dean and Friends" and just
like Barney and Friends, there should only be family friendly content posted
Can’t get enough of db2Dean? Do you want to get notified
when I add new technical conference calls, Favorite Links, or Googlegangers?
Then follow me, db2Dean on Twitter. When you do you will get
text messages sent to your cell phone when I update any page on this site.
Because of my personal spam reduction efforts, I only send you an email when I
publish my monthly news article. By following me, you will only get at most a
few “tweets” a month. Follow me by clicking this link http://twitter.com/db2Dean
For a little levity (ok VERY little) please watch my DB2
infomercial at http://www.channeldb2.com/video/db2-infomercial
or just click the clip at the top of my home page. It includes a guest
appearance by renowned pitch man, Chris Williams! If you have a moment, please
click on the stars after the word "rating" and rate my video after you watch it.
IBM Press Memorial Day Sale: Save 50% on purchase of 2 books with Coupon MEMDAYIBM
Kick off summer with extreme savings from IBM Press! Save when you stock
up—buy any 2 eligible books or eBooks, and save 50% with coupon MEMDAYIBM. Offer ends May 30, 2012. Start shopping now!.
Need some suggestions? Here’s what I’d recommend:
Warp Speed, Time Travel, Big Data, and more
DB2 10 for Linux, Unix and Window New Features
Now available for FREE as an e-book.
Last week at the IDUG Conference,
we handed out 250 copies of this new Flashbook to attendees. It was fun &
exciting. Here’s a photo:
What an awesome group of authors on this book: Paul Zikopoulos,
Walid Rjaibi, George Baklarz, Matt Huras, Matthias
Nicola, Dale McInnis, and Leon Katsnelson. Can you
imagine a stronger author team!
Here are a couple of details about the book:
Warp Speed, Time Travel, Big Data, and more
DB2 10 for Linux, Unix and Window New Features
- Up to 3x faster performance for complex query workloads
- Breakthrough compression technology that sets us apart from the competition
- New Time Travel Query for easy and fast historical and trend analysis
- New Continuous Ingest for real-time data warehousing
- And even greater compatibility with Oracle PL/SQ
- Enhancements for a Big Data world
Save Time and Money with DB2 10 for LUW
Even travel through time and shrink data
How would you like to compress data, store it in a cloud, and analyze your
data as though you are traveling through time? Do all this, plus experience
lower costs and faster performance. Sound good? Read this book to understand the
power of DB2 10 and get started immediately!
This book provides you with the comprehensive knowledge you need to get
started with the latest DB2 release. Try the new features by downloading DB2
Express-C - it is free to develop, deploy, and distribute (with no user and
database size limitations) and features Big Data and Cloud technology. Go to ibm.com/db2/express.
Technical editor: Roman B. Melnyk
Here are a few other blog entries about this impressive release:
DB2 10 Free Webinars
Summary of Skills
DB2 10 – From IBM Champion’s
DB2’s Next Major Release
Over the years, DB2 has become more compatible to Oracle, thus making it much
easier for people skilled on Oracle to move to DB2 jobs as well as much easier
for companies to switch their Oracle databases and applications that rely on
With DB2 10 for Linux, UNIX, and Windows, you’ll find the
PL/SQL Compatibility features and other enhancements make it even easier for you
Learn about why and how to switch by joining this latest DB2 Tech Talk that
takes place on May 31:
DB2 Tech Talk: Oracle
Database and SQL/PL Compatibility
Date: Thursday, May 31, 2012
Time: 11:30 – 1:00 pm EDT
Speaker: Serge Rielau, SQL Architect for DB2 for LUW
This webcast will discuss:
- Native PL/SQL support, plus other compatibility features including
concurrency control, PL/SQL package support, Oracle SQL dialect support, OCI,
SQL * Plus Scripts, and Oracle Forms.
- Enhanced support for triggers, new scalar functions, declared types and
procedures within local scope.
- Tooling that IBM has made available to streamline this move process.
- Case studies drawn from elements of the process with actual customers and
shown at the code level.
If you are serious about switching to DB2 from Oracle, here are some other
resources for you to consider:
Join host Scott Hayes and special guest Maria Schwenger from
IBM for a free 90-minute episode of “The DB2Night Show”. The
topic is “Crucial things you want to know as a DBA to manage a pureScale
system” and Maria will share her opinions and insights.
Date: Friday, May 25, 2012
Time: 11-12:30 EDT
Do you know Maria yet? Here’s more about her:
Maria Schwenger is a member of the Competitive Software &
Power Systems team at IBM, North America, where she works in a “high
touch” model with early release participants to promote the newest IBM
and DB2 Technologies, their early adoption, feedback and references on
pre-released products, and enablement of applications written for competitive
databases on to DB2.
In the last 3 years, Maria specialized in architecture and implementation of
active-active high availability database solutions utilizing DB2 pureScale
feature. Currently, Maria works with customers on adoption of PureApplication
System as part of the newest IBM offering of Expert Integrated Systems. Maria
has over 15 years experience in performance engineering, database architecture,
administration and development on DB2, Oracle and MS SQL server as well as
extensive experience in migration from legacy systems to relational databases.
She is an author of articles, presentations, tutorials, and IBM Redbook about
DB2 9.7 SQL Compatibility feature and DB2 pureScale.
After attending this talk, you’ll be happy that you “met” Maria!
PS… I’m posting this information rather late (ie.. the day before), so if you
read this after the webinar date, don’t worry. Scott records all these talks
and you can find them on his site.
If pureScale is your thing… check out the Flashbook that you can download for free.
I am looking forward to going to Denver this weekend in preparation of IDUG NA which starts on Monday, May
14. I’m hoping to blog and tweet from there, so regardless if you are at the
conference or not, you can follow what’s going on. Here are some key links:
- #idugna for conference level tweets
- #idug for IDUG in general
- @IDUGConference will be used for announcing room changes and formal
IDUG’s Facebook page will also be pretty busy during the conference too: www.facebook.com/IDUGDB2
Scott Hayes has set up an aggregator site
that includes all of the tweet related to IDUG: http://bit.ly/idugna12
Mike Krafick is the social media guru for IDUG. He tweets from IDUGDB2 and is looking
for more followers. He’s trying to get more followers than my twitter account
susvis. Let the
More information about this year’s IDUG Conference:
On Tuesday in the Exhibit Hall, we'll be handing out a limited supply of
signed copies of the New Flashbook
for DB2 10. For those of you not at the conference, follow my blog for
information on how you can download a copy for free.
Two other books will be launching at IDUG this year. We don’t have a
bookstore, but be sure to speak to the authors for information on ordering a
copy for yourself at a discount offered to IDUG attendees:
The winner of this year’s DB2’s Got Talent competition was Kohli (We HAVE a winner! DB2’s Got Talent
Competition) and he chose to attend IDUG Denver as his prize. I’m looking
forward to meeting Kohli. If you were also a competitor, please find me at the
show and introduce yourself.
If you’re interested in writing articles or books, or reviewing any of the
upcoming books… also find me and let me know. I may have some interesting
opportunities for you!
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.
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.
I hope you’re taking part in some of the learning opportunities available now
that DB2 10 & InfoSphere Warehouse 10 have released. Check out my blog from
yesterday about all kinds of options: April 30, 2012: GA of Version 10 products: DB2 for LUW and
Today I want to expand on a couple of webinars that I mention in that post.
First off, the DB2 Night Show. Last Friday, May 4, host
Scott Hayes invited IBMers Danny Arnold and Glen Sheffeld
to talk about the latest release: DB2 LUW
10.1! STOGROUPS, WLM, RCAC, and More. If you missed it, be sure to watch
the replay. Replays available in WMV and M4V formats.
There is so much to talk about that this was just part 1, and was a deep dive
into What's New in DB2 LUW V10. Storage Groups, Workload Manager
Enhancements, and Row and Column Access Controls were covered, and many example
SQL commands were shared to illustrate the concepts.
According to Scott’s website, 100% of the audience learned something
new! “Danny and Glen were terrific guests. I appreciated all of the SQL and
command examples that they shared while discussing STOGROUPS, WLM Enhancements,
and RCAC. Their presentations offered significant technical depth - this wasn't
just a DB2 10 marketing pitch. I am delighted that 100% of our studio audience
indicated that they learned something.”
Register now for Part 2: Episode #81 will discuss DB2 10 compression
enhancements, HADR, time travel queries, index jump scans, zigzag joins, and
more. Special guests from IBM share breaking news about vNext. Part 2 of 2.
This will be a 90 minute show. Yes, there is A LOT to talk about.
Secondly, The DB2 Tech Talk Series, hosted by Serge
Rielau. The next show, DB2
Tech Talk: Optimizing Storage Utilization for DB2 10 , takes place May 11, 12:30 EST to 2PM
Learn about the new storage optimization features in the newly available DB2
We will cover three areas including:
- Adaptive Compression which allows you to reach higher compression
ratios with DB2 10 than ever before.
- Multi-Temperature Data Management which configures your database so
that your most frequently accessed data resides on fastest storage
- Workload Management, which provides the ability to treat work
differently based on the data touched.
This technical tour is the second DB2 Tech Talk on the DB2
10 and InfoSphere Warehouse 10 product releases.
Additional webcasts will be
offered throughout 2012 to provide an in-depth discussion on the features in
The first of the series was DB2 Tech Talk: Technical Tour of New DB2 10 and InfoSphere Warehouse 10,
which took place April 26. Watch the replay. Serge Rielau, Conor O’Mahony, and
Cindy Fung took you on a tour of DB2 10 & InfoSphere Warehouse 10.
Mark your calendar for the 3rd in the series, DB2 Tech Talk: Oracle Database and
SQL/PL Compatibility, which takes place on May 31.
See also my other blog entries about DB2 10 and InfoSphere Warehouse 10:
New Flashbook for DB2 10 – Launching at IDUG
DB2 10 – From IBM Champion’s Perspective
DB2’s Next Major Release
Yesterday was the day that DB2 10 and InfoSphere Warehouse 10 were
made available to purchase. The products were announced on April 2, so I’m sure
you’ve seen some of the buzz surrounding this outstanding accomplishment.
On a personal side, my desk in the office is in the middle of the Release
Team who managed these releases. It has been an exciting and busy time for all
those involved and a huge congratulations go their way for all their hard work!
We had a brief celebration in the lab as well and I learned many interesting
- The development team spanned 8 lab sites.
- There are many lines of code! I’m not sure if I can say how many, but lots!
- There were 4 betas with lots of customers and resulting feedback.
- Many solutions were built into DB2 10.
So the developers are moving on to their next thing, but the Db2 10 work
doesn’t end here! Now those who create courses, exams, books, webinars,
articles, and events are working towards providing you what you need to move to
this product and to use if effectively.
Here’s my blog entry about what’s in the release and what IBM Champions are
saying about it:
As for education, if you are attending IDUG later this month, you’ll have plenty of learning
- DB2 10
for Linux, Unix, Windows - 6 in 60 minutes (SIGs)
Storage & Multi-Temperature Data Management -- Making DB2 Storage Management
Easier With Each New Release - H05
May 16, 2012 (08:30 AM - 09:30
- DB2 10
for LUW: Time Travel and Compression - H01
May 15, 2012 (12:45 PM -
Dive into DB2 10 Query Performance Optimization: Statistics and Optimization
Profiles - H14
May 18, 2012 (09:15 AM - 10:15 AM)
Dive into Multi-Temperature Data Management: Best Practices for Implementing
MDTM - H02
May 15, 2012 (02:00 PM - 03:00 PM)
Dive into Query Performance Optimization: Complex query optimization +
multi-core parallelism - H12
May 17, 2012 (02:45 PM - 03:45 PM)
Dive into Query Performance Optimization: Zigzag Join , Jump Scan - H13
May 18, 2012 (08:00 AM - 09:00 AM)
Dive into Row and Column Access Control: How to Define and Implement Security
Policies - H11
May 17, 2012 (01:30 PM - 02:30 PM)
Dive into Storage Optimization: When and How to use Adaptive Compression -
May 16, 2012 (09:45 AM - 10:45 AM)
Dive into Time Travel Query: Best Practices for Implementing Temporal Tables
while reusing existing applications - H10
May 17, 2012 (09:45 AM - 10:45
Dive into Time Travel Query: First Steps using Temporal Tables - H09
17, 2012 (08:30 AM - 09:30 AM)
Update: Multiple Stand-by (DB2 10 for Linux, Unix, Windows) - H03
15, 2012 (03:15 PM - 04:15 PM)
Ways to Tame your Database with DB2 Workload Management - H15
2012 (10:30 AM - 11:30 AM)
Compatibility Update for DB2 10 for Linux, Unix, Windows - H08
2012 (02:45 PM - 03:45 PM)
Best Practices for Performance and Monitoring - H04
May 15, 2012 (04:30
PM - 05:30 PM)
Data Warehousing Best Practices: Using Ingest Utility - H07
May 16, 2012
(11:00 AM - 11:55 AM)
PLUS, we're launching DB2 10 Flashbook at IDUG: New Flashbook for DB2 10 – Launching
at IDUG Denver
If you aren’t attending IDUG, don’t worry! Here’s what I can suggest for
- After the conference, I’ll have the PDF version of the Flashbook and will
post it on a website for you to download for free. Follow my blog so you won’t
miss the news.
- Webinars. Some have taken place, but there are many more planned. Again,
follow my blog or twitter and I’ll alert you to the events.
- Articles, blogs, best practices, and more books.
Watch the Replay of these webinars:
Schedule to attend these upcoming webinars:
There are many blog entries already posted and many more coming. I highly
- Follow planetdb2.com which
is a blog aggregator for DB2 bloggers. If you have a blog but are not included,
send a request to have your blog added.
- Find twitter mentions by searching on twitter tag #db2ten. Even if
you don’t have a twitter account, you can enter this tag in google and see what
has been posted.
Chris Eaton of IBM created a great video about “why you should consider migrating from
Oracle to DB2”
and I found this article/slideshow on eweek.com: Database: IBM Databases: Top 10
Innovations of the Past 50 Years by Darryl K. Taft
As usual, developerWorks is publishing new content on a daily basis to
support this release. Here are just a few of the items you’ll be able to find:
Bookmark this developerWorks page to see articles as they are published: ibm.com/developerworks/data/
And last but not least, IBM
Data Management Magazine has a whole series of articles and columns planned
to keep you reading. Make sure you check back frequently for new content.
What do you think? What a great amount of content for you to explore … and
DB2 10 was just released YESTERDAY! Keep learning!
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.
Join Serge Rielau, Conor O’Mahony, and Cindy Fung as
they take you on a tour of DB2 10 & InfoSphere Warehouse 10.
Details: DB2 Tech Talk: Technical Tour of New DB2 10 and
InfoSphere Warehouse 10
Date: Thursday April 26
Time: 11:30am – 1:00 pm EDT
Get the details behind these new product releases as announced on April 3.
Learn about powerful new features such as:
- Storage Optimization Advances, including Adaptive Compression and
Multi-Temperature Data Storage, which are designed to optimize your storage
environment and system performance.
- SQL Compatibility enhancements that make it even faster and easier to
migrate from Oracle Database to DB2.
- Time Travel Query, which provides native temporal support, enabling you to
better support your business and more easily meet compliance and data retention
- Real-time operational data warehousing, with features such as data ingest
and query performance enhancements, designed to enable better and faster
- NoSQL capabilities that help you implement models beyond relational, such as
unstructured XML data and RDF graph triple data. Handling these new types of
data along with your relational data is becoming a requirement in
Watch for additional webcasts that will be offered throughout 2012 to provide
in-depth discussion on the features in these releases.
This is the kick-off Tech Talk and you are strongly encouraged to attend.
Register now: http://bit.ly/IT7IGg
See also my other blog entries about DB2 10 and InfoSphere Warehouse 10:
New Flashbook for DB2 10 –
Launching at IDUG Denver
DB2 10 – From IBM Champion’s
DB2’s Next Major Release