The initial response to DB2 10 has been extremely positive. An early adopter of DB2 10 said, “We could not have been more thrilled with all the performance improvements! There is definitely gold in this version and you don’t even need to spend time to find it. It’s truly right out of the box.”
Have you moved to 10 yet? Or looking at migrating to DB2 10 this year ? Join John Campbell, IBM Distinguished Engineer for a special 2 hour presentation on February 21st & 22nd: IBM DB2 10 Migration Planning and Very Early Experiences – PART 1 & PART 2. This will be a LIVE webcast with LIVE Q&A.
To help facilitate your migration, John Campbell will provide planning information about migrating to DB2 10 for z/OS from either DB2 9 or DB2 Version 8. This webcast will be a two part series on February 21st and 22nd.
Join us for this webcast series which will
- Share surprises, pitfalls and lessons learned
- Provide hints and tips
- Discuss enabling fast start
- Introduce and discuss some further enhancements
- Share the latest news about migrations
All participants will receive complimentary DB2 10 Migration Planning whitepaper written by John Campbell
IBM DB210 is here and while early adopters have already upgraded to the new version and are reaping the business benefits, others are just beginning to think about upgrading with DB2 Version 8 been withdrawn from marketing on April 30th 2012. Attending this webcast will give you valuable information for your migration. Bring your questions as there will be plenty of opportunity for live Q &A.
Register Now: IBM DB2 10 Migration Planning and Very Early Experiences – PART 1 & PART 2.
Part 1 - February 21, 2012 at 11:00 a.m. Eastern Standard Time, 4:00 p.m. GMT / UTC
Part 2 – February 22, 2012 at 11:00 a.m. Eastern Standard Time, 4:00 p.m. GMT / UTC
Great articles by amazing contributors. Make sure you read every article in the latest edition of the DM Magazine. I’ve read the article about Roger Sander’s contribution to the DB2 Certification Exam Development team and the announcement of his latest certification guide, which is a supplement. I’ve bookmarked many of the other articles so I can read them over the coming week. I hope you find something interesting and useful in this edition!
Taming Big Data - The realm of huge information flows is governed by new rules. What changes in the multi-petabyte, microsecond response, multimedia world? And how will Big Data change your job?
by Lisa Stapleton
It’s not just huge volumes. It’s not just microsecond response times, it’s not just incredible variety. It’s all three. Dealing with “nice” data, stored in well-defined data warehouse structures and handled sometimes months or years after it is first collected, is an increasingly smaller part of the job of data management. Here’s how folks are learning to handle the rest of it—the unstructured data, and the data that constantly changes as customers take actions and applications process input.
Tuning SQL at the Senate: E Pluribus Unum - When the SQL flow in the United States Senate went from static to dynamic, the database team had to see many queries, but tune them as one.
by Ives Brant
“High-performance government” may sound like an oxymoron, but for the teams that monitor and tune databases for the U.S. Senate, high performance is absolutely necessary to handle the huge number of queries that hit the Senate’s financial management system. InfoSphere Optim Query Workload Tuner software running on IBM DB2 z/OS helps the U.S. Senate DBAs and software specialists reduce query response time from 20 to 30 seconds to less than 2 seconds when they generate new statistics for a workload of SQL queries.
The Man to See About Certification - The guru of DB2 certification tests talks about how he puts them together—and how they can help your career
by Howard Baldwin
Q&A with Roger Sanders who has helped IBM develop 17 DB2 certification exams, more than any other individual. Want to know why certification is important? Roger Sanders is the man to ask. We talked to him about how the tests are put together, how they can help a DBA’s career, and—oh yes—about the certification test he failed.
Get Your Head in the Clouds - Data Pros are adopting cloud computing concepts to offer databases as a service - easing management burdens and sending users to cloud nine.
by Jin Zhang
Tactics and strategies for moving away from traditional provisioning models in which DBAs function solely in reactive mode—responding to user requests in nonstop “database, clone, database, clone” activities—towards a database-as-a-service, or DBaaS (pronounced as “D-Baa-S”), model employing cloud computing practices.
To offer DBaaS on the cloud, enterprise IT departments must undergo a process of constructing and managing a private enterprise “data cloud”—a platform consisting of storage hardware, virtual images, database schemas and more—and making that cloud available to users through a services interface.
Smarter is… Making Watson Smarter…Faster
by Howard Baldwin
A deeper look at the Jeopardy-winning system and the technology that enables it to process information in near real-time.
IBM Information Governance Council - Information Governance Community growing worldwide - IGC draws 1500 members, solicits best practices ideas
by the Magazine Team
The wisdom of crowds isn't an oxymoron. Large groups have an uncanny ability to get the right answer - just see James Surowiecki's book on the subject for proof. So it's not unreasonable to say that the Information Governance Council (IGC) is getting smarter with each passing month.
Data Architect - Securing DB2 Data - Grant privileges to a what, not a who
by Robert Catterall
These days executives are more concerned than ever about unauthorized access to data entrusted to their organization. Their fears are justified: a recent study showed that a third of those polled would quit doing business with a company they perceived to be guilty of a data security breach.
Distributed DBA - Using the DB2 Problem Determination Tool
by Roger E. Sanders
Sooner or later, every DBA encounters problems. Consequently, a skill that every DBA must possess is the ability to perform a logical, systematic search of a database system for the source of any problems that might arise. The DB2 Problem Determination Tool can help.
Programmers Only - New Order by Information: Part 2. The Impact of using the RANDOM index option on ORDER BY sort avoidance
by Bonnie Baker
In the last issue, Bonnie Baker began a series of columns concerning new aspects of ORDER BY. This column - Part 2 - covers the impact of using the CREATE / ALTER INDEX RANDOM order option on sort avoidance.
Performance tuning on Informix - Fastest Informix DBA Contest III - Performance tuning an OLTP system
by Lester Knutsen
Performance tuning is a continuous process for every DBA. Advanced DataTools Corporation conducted three fastest Informix DBA contests to highlight and learn what goes on in this process.
Imagine What You Could Do - Free your mind, and your business will follow
by David Buelke
Big Data, Big Time - Series data, warehouse acceleration, and 4GLs
by Stuart Litel
I asked my wonderful friend Rebecca Bond to give me her IDUG Conference
schedule for the Tampa conference during the week of May 10th. I asked Rebecca because she is working as a DBA and has for many years. I figure that her schedule will more closely match the target audience than a schedule I'd put together.
I had to make some REALLY difficult decisions. There are some EXCELLENT speakers and sessions this year.
These are the ones I finally decided to attend. I seriously hope that the ones I am going to miss will be presented at IOD so I can try to attend them then. IDUG has outdone themselves with this line up.
I may look at taking one of the classes on Monday. Just depends on how my writing projects are going and if they have any available spaces left when I make the determination.
I can't decide on which restaurant to sign up for on the Dine Around evening. Several good choices and I want to have dinner with everyone so I think I'll just have to put a blindfold on and throw darts at the sign up board....you might want to warn your readers to steer clear of the sign up board if they see a crazy lady in great shoes start to put on her blindfold.
May 11, 2010
8:00 K01: DB2 INNOVATION: POWERING INFORMATION WORKLOADS FOR SMARTER IT
10:00 S02: DB2 FOR LINUX, UNIX AND WINDOWS - TRENDS AND DIRECTIONS
12:30 D01: CAPITALIZING On DB2 LUW V9.7 Capabilities - A Data Management Feature Presentation
1:45 D02: Varsity SQL for the Busy DBA
3:00 C03: Enabling Oracle Applications on DB2 - an Early User Experience
4:15 D04: A VISUAL TOUR OF DB2 9.7 SQL AND PL SQL ENHANCEMENTS
May 12, 2010
8:30 C05: An Indepth Technical Look at DB2 pureScale
9:45 D06: DB2 SECURITY – AMMO FROM THE TRENCHES -- Presenting
11:00 D07: UPGRADING DB2 9.7 – BEST PRACTICES AND LESSONS LEARNED
1:30 V05: You Killed the ELEPHANTS but MOSQUITOES are Killing YOU!
2:45 D08: STUFFED WITH GREAT ENHANCEMENTS - DB2 9.7 FIX PACK 1 NEW FEATURES
4:00 I01: Data Privacy, Security and Audit Compliance -- Panel Participant
May 13, 2010
8:30 C09: pureScale - Why It's So Much Better than Oracle RAC
9:45 D10: LOCKING - WHAT LOCKING? CURRENTLY COMMITTED AND OTHER LOCK AVOIDANCE ENHANCEMENTS TO INCREASE PERFORMANCE AND THROUGHPUT
11:00 V10: END-TO-END MONITORING & PROBLEM DETERMINATION WITH OPTIM PERFORMANCE SOLUTION
1:30 D11: ENABLING FROM ORACLE TO DB2 COBRA THE EASY WAY.
2:45 F12: DB2 Back and Recovery - What Do I Really Need to Know?
4:00 I05: DB2 FOR LUW - HIGH AVAILABILITY & DISASTER RECOVERY
May 14, 2010
8:30 E13: All the FREE Things you can Do with Data Studio
9:45 E14: Diagnosing & Curing? Lock, Wait and Performance Bottlenecks
11:00 B15: Auditing options on DB2 for z./OS (Moderator)
Thanks Rebecca! I wish I was going so I could attend all these amazing sessions with you!
If you missed my posts in the past week, here's the rest of the IDUG coverage that you can find:
The educational seminars
are taking place that on Monday, May 10. Be sure to check out the offerings.
Check out the bookstore that will be onsite where you can purchase the book that Rebecca wrote:
Today’s show had two very important purposes. 1, to give us valuable
information about the upcoming IDUG
conference and 2, to reveal the winner of this year’s DB2’s Got Talent
competition. If you’ve been following the competition, you’ll know that the
competition was really strong this year. This meant that some amazing talent
did not make it to the top 3, but those who did were consistently good at
entertaining and educating all the listeners.
The prizes for the winners were provided by very generous sponsors. My
sincere thanks to these sponsors for helping to build talented speakers /
educators, and for providing a means to build very valuable skills. Here are
the prizes and sponsors:
- First place winner: free pass to 2012 IDUG conference of
choice, provided by sponsor IDUG and $1500 for travel expenses, provided by DBI.
- Second place winner: free pass to a DB2 Symposium of
choice, provided by KBCE plus $1000 for
travel expenses, provided by sponsor HLS Technologies.
- Third place winner: Apple iPad, provided by sponsor Responsive Systems.
- Top 10 contestants won $50 Amazon gift certificates provided by Triton Consulting.
The contestants worked hard to compete and the prizes are very generous to
thank them for all their hard work.
Host Scott Hayes showed us a relative performance chart that showed
the votes that were received for this final round. The chart showed that first
place was a strong first place. Second place was a strong place. Third and
Fourth were quite close.
And the winners are:
Fourth - Elder
Great job Elder! All of us felt that your technical difficulties at last
week’s show didn’t help you very much. Good for you to use your creativity to
post your presentation to YouTube for people to watch after the show. Keep
Third – Brian
Brian says he got into this competition to brush up on his presentation
skills but ended up learning a lot, having fun, and teaching all listeners. As
a result of this show, Brian is now considering submitting to present at future
IDUG events. Brian lives in Denver area, so he is hoping to attend this year’s
conference for at least one day. Personally, I learned plenty from watching
Brian’s creative and entertaining presentations.
If you took part in last weeks show, you’ll remember that Jean was the
contestant that the judges saved! Jean was very excited about winning and
thanks all her voters. She wasn’t sure which DB2 Symposium she plans to attend,
but Chicago is one of her choices. Jean is a great presenter and we very much
enjoyed her presentations. We all agreed that we need to meet mystery man Chuck
who was Jean’s content collaborator for all her presentations. She took part in
this competition as a lark and appreciated Scott’s encouragement for them to
take part. She would like to present at conferences in the future.
First - Kohli
Kohli was completely speechless to find out he won first prize. He said
there was lots of strong competition and had no hope to win. He’s only been a
DBA for a few years, but he thought he had nothing to lose by taking part. I’m
glad he took part. He gained, but so did we all! lots Kohli has decided that
he’ll attend Denver. I’m looking forward to meeting him.
Rounding out our top 10: Douglas, Ember, Rodolpho,
Kingo, Richard, and Yonghang. Thanks to all of you for
participating. I hope to see all of you in the future as presenters at
conference, or bloggers, or writers. You have much to contribute and we
appreciate what you have given to the community.
Thanks again to host Scott Hayes for pulling all of this together. We all
know that committing to an event of this size and orgazining as well as he did,
takes much dedication and hard work. I’m sure you can see why Scott won a
special award last year for his contributions as an IBM Champion. Keep up the
great work Scott!
To my fellow judges, Martin Hubel and Klaas Brant: always a
pleasure to work with you. I hope to see you in Denver… maybe at Scott’s
The second part of the show was dedicated to IDUG. I’ve decided to post my
thoughts about that part in a separate post.
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
See also: DB2’s Got Talent
Finals – Round 3
Yet another great reason for you to attend IDUG in Denver this May… we are launching the latest
Flashbook. This one coincides with the new DB2 10 product release and has an
awesome group of authors: Paul Zikopoulos, Walid Rjaibi,
George Baklarz, Matt Huras, Matthias Nicola, Dale
McInnis, and Leon Katsnelson. Can you imagine a stronger
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
- 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
Technical editor: Roman B. Melnyk
Only 250 copies are being shipped to IDUG, so make sure you get your printed
copy if you are attending. After the conference, we’ll post a free e-version of
the book on our Bookstore website.
While at IDUG, make sure you attend all the sessions geared towards the new
Want to know what the labs are working
on for the next release? IDUG in collaboration with IBM is featuring DB2
v 10 by offering a dedicated track for DB2 vNext as well as
offering in-depth knowledge on the coming releases. This session and others are
available for registered conference attendees free of charge.
Storage & Multi-Temperature Data Management -- Making DB2 Storage Management
Easier With Each New Release - H05 - Kelly Schlamb
May 16, 2012 (08:30 AM
- 09:30 AM)
Dive into Multi-Temperature Data Management: Best Practices for Implementing
MDTM - H02 - Jim Seeger
May 15, 2012 (02:00 PM - 03:00 PM)
Dive into Query Performance Optimization: Statistical Views - H14 - John
May 18, 2012 (09:15 AM - 10:15 AM)
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 - Walid Rjabi
May 17, 2012 (01:30 PM - 02:30 PM)
Dive into Storage Optimization: When and How to use Adaptive Compression - H06 -
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 - Matthias Nicola
May 17, 2012
(09:45 AM - 10:45 AM)
Dive into Time Travel Query: First Steps using Temporal Tables - H09 - Matthias
May 17, 2012 (08:30 AM - 09:30 AM)
HUMONGOUS improvements in warehouse query performance in DB2 10 for Linux, Unix,
Windows - H12 - Calisto Zuzarte
May 17, 2012 (02:45 PM - 03:45 PM)
Update: Multiple Stand-by (DB2 10 for Linux, Unix, Windows) - H03 - Dale
May 15, 2012 (03:15 PM - 04:15 PM)
Ways to Tame your Database with DB2 Workload Management - H15 - David
May 18, 2012 (10:30 AM - 11:30 AM)
Compatibility Update for DB2 10 for Linux, Unix, Windows - H08 - Sandra
May 16, 2012 (02:45 PM - 03:45 PM)
Best Practices for Performance and Monitoring - H04 - Steve Rees / Matt
May 15, 2012 (04:30 PM - 05:30 PM)
Data Warehousing Best Practices: Using Ingest Utility - H07 - Sandra
May 16, 2012 (11:00 AM - 11:55 AM)
New in DB2 10 for Linux, Unix, Windows – Overview of all New Features and
Functionality - H01 - Les King / Sandra Bialek
May 15, 2012 (12:45 PM -
My favourite quote about the new release comes from IBM Champion Jean-Marc
BLAISE: "This makes DB2 10.1 a very talented release.
For this and more
quotes, see http://ibm.co/HvBrUp
I’ve been seeing many upcoming events for the DB2 for z/OS product and decided to summarize in this post.
IDUG – Anaheim May 2-6. This isn’t an event specifically for DB2 for z/OS, but as usual there are some amazing sessions planned for that platform including:
- DB2 Doctor - Symptoms, Diagnosis and Cures for Poor Performance, Bonnie Baker, Bonnie Baker Corporation
- DB2 10 Application Topics - A Sneak Preview, Suresh Sane, DST Systems Inc.
- Why did the DB2 for z/OS Optimizer choose that Access Path?, Terry Purcell, IBM Corporation
Learn more: IDUG = International DB2 User Group
Upgrading to DB2 9 or DB2 10 for z/OS — How? When? What is the cost versus benefit?
Broadcast Date: February 22, 2010 at 11:00 a.m. Eastern Standard Time, 4:00 p.m. GMT
Developed for: IT directors, managers and project managers; business analysts; enterprise architects; database administrators and managers; and application database administrators
On Oct. 19, 2010, IBM announced DB2® 10. This latest release of DB2 delivers the most aggressive package of CPU savings and performance improvements from IBM in more than 20 years, and for the first time since 2001, IBM has offered skip release. With the increased cost of support software licenses, the launch of DB2 10 and the announcement of DB2 V8 end-of-service, many DB2 users are considering migration and need direction in planning the right migration strategy for their business. But how do you approach a migration strategy? When is the best time to start? Is skipping a release a good strategy? What are the costs versus benefits for any scenario?
Join us for this complimentary webcast as we address the most critical business issues to consider such a migration, so you can develop a strategy and plan for your own migration. We will describe the options available and some of the potential risks versus benefits. Overall, this webcast will help you choose the best path for your situation, and get ready to migrate to the new version. Whether you are ready to migrate now or you are still years away, planning should start now so that you can use your time more effectively and minimize the ultimate cost of upgrading.
All webcast attendees will receive a free copy of “Executive Report of Business Value of DB2 10 - Smarter Database for a Smarter Planet” by Julian Stuhler, an Internationally recognized DB2 consultant and analyst.
In this webcast, we’ll discuss:
- * Defining migration plan details for each component in your environment — servers, clients, applications and routines
- * Incorporating steps from previous migration plans, including internal procedures to request access, software installation or other system services
- * Understanding product restrictions and recommendations in order to plan your migration strategy
Speaker: Roger Miller, DB2 for z/OS® Technical Evangelist, Designer and Architect, IBM Software Group
Why is DB2 for z/OS better than Oracle RAC?
Broadcast Date: January 25, 2011 at 11:00 a.m. Eastern Standard Time, 4:00 p.m. UTC / GMT
Developed for: IT Directors, IT Managers, Enterprise Architects, IT Project Managers, Business Analysts, Database Administrators, Application Database Administrators, Database Managers.
In recent years, IBM DB2 has been under considerable pressure from its competitors, most notably Oracle RAC. These competitors claim to provide the same functionality and quality of service characteristics as DB2. DB2 specialists are often asked by the business decision makers to articulate the technical advantages of DB2 and justify the choice of DB2 as the database server:
- Why is DB2 for z/OS considered the ultimate database server?
- What are the technical differentiators by which it stands out, particularly against Oracle RAC?
- How does Oracle RAC process concurrent transactions as opposed to DB2?
In this webcast, we will offer answers to these questions. In addition, a complimentary whitepaper will be available for download. In the whitepaper IBM will size up the database clustering architecture provided by DB2 for z/OS with the Oracle RAC product. When all is said and done, compared and contrasted, DB2 for z/OS differentiates itself with superior characteristics.
Speaker: Namik Hrle is an IBM Distinguished Engineer and works in the IBM Boeblingen Laboratory. He is a member of the IBM Academy of Technology, Information Management Architecture Board, SWG Architecture Board Steering Committee and many other IBM expert teams. He specializes in information management technology and its usage by the enterprise applications. He works closely with the IBM labs worldwide and helps customers deploy and optimally exploit information management products. He is a regular speaker at conferences across the world.
REGISTER TODAY TO SECURE YOUR SPACE !
DB2 for z/OS Technical Seminars that you can attend in person, for free:
Toronto - Jan 27
Dallas - Feb 8
San Francisco - Feb 10
Washington DC - Feb 15
Atlanta - Feb 17
New York City - March 8
Costa Mesa - March 15
8:40am – Meeting the business analytics and data warehousing needs of your users
9:50am – DB2 for z/OS: Version 10 including migration strategy for DB2 9 or DB2 10
11:00am – Gain insight into DB2 9 and DB2 10 for z/OS performance updates and save costs
1:00pm – What’s new for SQL optimization in DB2 9 and DB2 10 for z/OS
2:10pm – Administering and Optimizing Your DB2 9 & 10 for z/OS Environment
3:20pm – How to streamline your DB2 for z/OS utility processing
Space is limited, so register now.
To stay on top of all the upcoming events, bookmark Surekha’s Blog.
And last but not least…. get your copy of the Flashbook:
DB2 10 for z/OS - Cost Savings ..... Out of the Box
by Roger Miller, David Beulke, Julian Stuhler, Surekha Pureka
Can you tell that I love IDUG yet? OK, one more post and then maybe you’ll be convinced.
Cristian Molaro, an IBM Best Friend from Belgium (my mom’s home country :) sent me a link to a blog that he did similar to the one I posted from Beth yesterday. Like Beth, he’s listing the sessions that he’d like to go to given his affinity to DB2 for z/OS. Cristian’s blog entry: “A Travel Guide to IDUG DB2 Tech Conference – Anaheim 2011”.
Instead of repeating any of his post, or the other posts, let me tell you a few things that I’ve learned about the IDUG conference thanks to my guest bloggers:
A link to the Conference Event Grid.
A link to the Online Conference Schedule.
Budgeting tip: Did you know that if you attended an IDUG Regional Event in 2010, you can use the monies paid as a credit towards the IDUG 2011 NA conference?
Bryan Paulsen and Paul Turpin:
The DineAround event is very popular and spots fill up very fast! See post (All about IDUG DB2 Tech Conference - Anaheim )for a list of restaurants, leaders, and how you can sign up.
The name of the conference has changed to the IDUG DB2 Tech Conference to help people get funding to attend the conference.
There won’t be a bookstore on site at this event. Instead, order the books you need directly from the publisher at a discount. Members of IDUG get 45% off IBM Press books.
She loves IDUG as much as I do and considers it her Geeky Vacation.
The keywords for me for this IDUG are: pureScale, Performance Tuning, XML, Cloud, and, of course, Security.
This time, she’s looking for sessions that will help round out her resume.
When I do the math, the cost of NOT going to IDUG North America is much greater than the conference cost!
I hope you’ve found this set of posts helpful to you. If you are going to IDUG, I hope you have a wonderful and educational week.
Were you able to join today’s DB2 Night Show webinar? Today was the second
show of this year’s very popular competition. If you missed it, I strongly
encourage you to watch the replay. Here’s what you’ll get:
Contestant 1 – Kohli
Kohli’s presentation showed how you can backup your database on one
filesystem and redirect it to another. He very clearly went through a scenario
where he did so and showed the errors that can result and how to solve the
issues. Unfortunately Kohli ran out of time during the critical part of the
presentation where he was explaining how to resolve the issues that resulted
from using the restore redirect command. It was a good presentation, but needed
more pictures and more focus on solving the issues rather than defining the
Contestant 2 – Elder
Yet Another db2imigr Command Alternative
Elder’s topic showed how to version migration when there is no window for an
offline backup and restore. This wasn’t an elegant solution, but is a great
trick to use if that’s the only option. It was a good presentation and very
clearly delivered. Elder came in on time and admitted that he practiced his
timing in order to come in on time.
Contestant 3 – Renu
How to Use Statistical Views to Optimize and Tune SQL
Renu showed us how she tuned a 200 line SQL statement for her client. Her
client wanted her to use MQT, but she chose to use Statistical Views instead.
She defined both MQT and Statistical Views and explained the pros and cons of
using each. As a result of her tuning, she was able to show a 99% improvement
in running time. I thought it was a very easy to follow presentation and was
Contestant 4 – Rajesh
Tip for DB2 Instance Check
This happened once last year as well, Rajesh had a good topic, but decided
not to create slides to present the topic to us. He showed us source code, but
it was hard for me to follow. Rajesh mentioned that he didn’t have PPT
installed, so I want to suggest that Google has a free presentation software
that he should look into. Another alterative is to increase the fonts in a
word document so that it looks like a slide deck. I think it would have been a
great presentation if he had used the slides.
Contestant 5 – Sharad
MQT – Friend or Foe? How to turn Foe into Friend
Sharad defined the terms and showed a case study for overcoming MQTs
limitations of using too much log space. I found it hard to hear Sharad and
therefore found it somewhat hard to follow the presentation. My more technical
co-judges found the topic interesting especially when you have Big Data stored
in your tables.
Contestant 6 – Srini
Move Table Online Using admin_move_table
Srini’s presentation showed how to use a new DB2 9.7 command to move a table
that is growing more than 64 GB. I found it hard to follow the presentation.
Maybe the slides were too busy. Maybe Srini didn’t project when speaking. My
co-judges really liked the topic and found the presentation very valuable and
The judges, Martin Hubel, Klaas Brant, and myself chose
Kohli and Elder to move onto the next round based on the relevance
of their topic and the quality of their presentations. We had much trouble
choosing who should move on since many of the presentations were superb. If
there is still room in the schedule, those who didn’t get chose should see if
you can get another contestant slot. Talk to Scott.
Do you agree with our choices? If you watch the replay, you’ll be able to
fill in a survey to let us know if there is someone else who should also move
on. Listen for the great tips and for your opportunity to advance another
Join us every Friday in February for contestant
presentations. March is reserved for the finals where those who have
moved on will present a second time and the listeners can choose the winner
rather than the judges. The commitment for March has lessened in that there
will only be 3 shows in March rather that the originally planned 5. We still
have openings for a couple of contestants, so if you’re interested, sign up to join!
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 2012 Competition
What’s happening in your DB2 world? I
asked this question to many of the people I’m connected with on twitter
and I got many responses that I’d like to share with you.
Rebecca Bond@DB2locksmith hasn’t had time to update her blog (http://www.securedb2.com)
lately, but is thinking of topics she could write about. Is there
something you want Rebecca’s opinion on? I’m sure she’d love to have
some suggestions to help her write something.
Kohli Kshitij @kohli83 had
a great year! He won the “DB2’s Got Talent Competition” from the
DB2Night Show, he attended IDUG in Denver and IDUG in Berlin, he says
that his favourite sessions were: and... he thinks he’d like to volunteer for IDUG!
Sanjeev Datta @1dsanjeev is very pleased with the publication of his new book: IBM Cognos Insight (http://www.packtpub.com/ibm-cognos-insight/book). He
recommends Chapters 1 for anyone who is new to IBM Cognos and IBM
business vision and strategy. Chapters 4 & 5 will help finance,
sales, & marketing departments in usingCognos Insights to develop their own workspaces. If you find the book sold out on amazon, contact Sanjeev through twitter and ask him for other buying options & discounts.
Michael Schulz @mikeondb2 says DB2
is rockin' and rollin' and PureData for Transactions is taking it to a
new level. Don’t forget to read this article that Mike recently wrote
for IBM Data Management Magazine: "Achieving High Availability and Disaster Recovery with IBM DB2" .
Sunil Soares @SunilSoares1
just finished the Data Governance Winter Conference. He’ll be speaking
at IDMA conference in April 2013 on best practices for insurance data
governance. He’s very happy with the publication of his latest books
and the sales of all three of his books:
- The IBM Data Governance Unified Process
- Selling Information Governance to the Business: Best Practices by Industry and Job Function
- Big Data Governance
Philip Gunning @db2luw
is finishing off his latest book that will publish in 2012 as well as
performed a DB2 upgrade with TSAMP, HADR & wrote an article on
Temporal Tables that will published on
you have an answer to my question “what’s happening in your DB2 world”
and would like to share with me and others, either send me a tweet
@susvis or post on the DB2 Facebook page.
a friend of mine asked for advice on how she can learn more about DB2.
She’s just starting in this area and is wondering how she can spend 40
hours of dedicated learning to increase her competence.
My answer was immediate: You need to attend IDUG at the end of this month! There is still time to create a justification and to get the trip & education approved.
Here are a few blog posts that can help you create your justification:
Ten Reasons to Attend
Technical Conference – It’s a skill builder, not a trip to Vegas.
Here are the sessions I suggest you take if you are learning DB2 LUW for the first time:
Monday: April 29 8:30 am - 5:00 pm
Educational Seminar: DB2 10 LUW DBA Cert Exam 611 Preparation
with IBM Champion Roger Sanders. Note that there is an extra charge
for taking this class, but it is worth the money, especially if you
follow up and take two exams free of charge.
you have time on Monday, take a certification exam or two. If you are
worn out or run out of time, you can take the exams other days during
Free IBM Certification Exams Mon - Fri.
There may be an evening event. Check on the IDUG Facebook page for information.
Tuesday April 30th at 8:30 am
Attend the Keynote to get inspired and to learn about the importance of Big Data.
"DB2: Database Software for the Era of Big Data" with Bob Picciano, Judy Huber, Paul Zikopoulos
Tuesday April 30th 10:15 am - 11:45 am
Spotlight: DB2 for LUW: Recent Enhancements & Trends with Matt Huras.
- take the opportunity to meet people during the lunch breaks. I
typically choose any table and introduce myself to all at the table.
This is a great way to make new friends!
Tuesday April 30th 12:45 pm - 1:45 pm
the next time slot, you have a choice of 4 sessions that I think might
be of benefit. If none of these interest you, it might be a good time
to take a certification exam. Here are your choices:
Optimizer Advancements - Comparing Query plans between V9.7 & V10 (LUW) with Vijay
IBM PureData System for Operational Analytics with Jon Lind
Advanced Query Tuning w IBM Data Studio for Developers with IBM Champion Tony Andrews
Officially Amazing- DB210 powers the world's largest data warehouse with Austin Clifford
Tuesday April 30th 2:00 pm - 3:00 pm
I’d recommend this session by JB who I met on the DB2Night Show’s DB2’s Got Talent Competition:
The evolution of the DB2 High Availability & Disaster Recovery tool w JB Chakrapani
Tuesday April 30th 3:15 pm - 4:15 pm
Either of these sessions:
DB2 Business Continuity Features with Dale McInnis
Prospecting for Gold Nuggets in DB2 10.1 with IBM Champion Paul Turpin
Another tough time slot: Tuesday April 30th 4:30 pm - 5:30 pm
Bonnie’s talk will be about DB2 for z/OS, but she’s an awesome speaker and you’ll learn a lot.
DB2 Does What? with IBM Champion Bonnie Baker
These are a bit advanced:
Best Practices & Lessons Learned: DB2 pureScale in high demand with Satsumi Takeo
Strengthen Business Continuity Strategy with DB2 Advanced Recovery Tooling w Bill Minor
One of these may be your best bet:
DB2 9.7.1 to DB2 10: An overview of SQL enhancements with Eric Alton
Big Data & Reinventing Cust Engagement: Key Use Cases with Tom Deutsch
DB2 to the Cloud: A Case Study with IBM Champion Philip Nelson
Best Practices: Upgrade to DB2 LUW 10 with Melanie Stopfer
That’s one busy day! There may be an evening event. Check on the IDUG Facebook page for information.
Wednesday May 1st at 8:00 AM
Another Keynote: Curt is a joy to listen to... and I can guarantee you’ll be inspired.
"The Latest News on DB2 Application Development Technology" with Curt Cotner & Bill Bireley
Wednesday May 1st 9:15 am - 10:15 am
My suggestion for this time frame is to listen to one of the customers who will tell us how they use DB2 in their company:
Highlight Zone-MetLife: DB2 LUW-Tooling Time with Susan Sterling
BNSF Railway: Details & BP - DB2 pureScale Implementation with Robert Collins Jr
Wednesday May 1st 10:30 am - 11:30 am
You can’t miss Leon’s talk:
DB2 on the Cloud: Experiences from the Trenches with Leon Katsnelson
Wednesday May 1st 2:15 pm - 03:15 pm
this time slot there are two sessions that are related to competition.
If that isn’t of interest, the sessions from our IBM Champions Phil
Gunning or Dave Beulke would be good choices.
IBM PureData Systems vs. Oracle Exadata - Technical Facts with Chris Eaton
DB2-z vs Oracle-Showdown at the Warehouse Corral with Robert Goodman
Battle-Proven SQL Tuning Techniques with IBM Champion Phil Gunning
Data Warehouse Designs for Big Data Performance with IBM Champion Dave Beulke
Wednesday May 1st 3:30 pm - 04:30 pm
I would suggest this session since security is an important part of the database.
DB2 Security Challenges with IBM Champions Rebecca Bond & Roger Sanders and Walid Rjaibi
There may be an evening event. Check on the IDUG Facebook page for information.
Thursday May 2nd 8:00 am - 9:00 am
Ember or Craig... both good choices for this time slot.
The 10 Commandments of Supporting E-Commerce Databases with Ember Crooks
Top Ten Things You Need to Know: For DBAs, Developers, & Managers with Craig Mullins
Thursday May 2nd 9:15 am - 10:15 am
From my perspective, three great choices. Choose based on your interest: indexing, SQL or availability.
Index Jump Scans & Updated Rules for Optimal Index Design with IBM Champion Scott Hayes
Practical options & trade-offs for database availability with Dale McInnis
Interesting SQL Solutions to Real Life Problems with Anthony Tichonoff
Thursday May 2nd 1:00 pm - 2:00 pm
have to go with Melanie for this time slot. She’s a professional
instructor and beloved by everyone who knows her or has heard her
Wowza! Great Tips I’ve Learned about DB2 LUW 10 with Melanie Stopfer
Thursday May 2nd 2:15 pm - 3:15 pm
You’’ll enjoy this talk from former DB2Night Show contestant Brian:
A DB2 LUW Fitness Plan by Brian Fairchild
Thursday May 2nd 3:30 pm - 04:30 pm
Migrating existing Temporal Applications to DB2 Time Travel with Matthias Nicola
Thursday May 2nd 4:45 pm - 6:00 pm
Mini Panel: DB2 LUW with Matt Huras, Paul Zikopoulos, Melanie Stopfer, Calisto Zuzarte, and Chris Eaton
Thursday May 2nd 7:30 pm - 9:30 pm
is an awesome event that you should take part in. Choose the technical
leader who you wish to get to know better and meet at a restaurant with
others who have similar interests. Networking is really important and
much more beneficial than many people realize.
Friday May 3rd 8 am - 2 pm
I highly recommend that you take one of these full day sessions. Both are free of charge.
"DB2 10 for LUW Immersion Workshop"
"Data Warehousing: DB2 Analytics Accelerator Deep Dive Workshop
brain will be completely full after this week of training. And the
funny part is when you get home and tell people you were in Orlando for
the week, you’ll be asked if you enjoyed the sun. You’ll answer will
be... there was sun? You’ll be indoors learning, so this is definitely a
geek vacation rather than a sun vacation!
To all the presenters of the session that I didn’t mention in this
post, I’m very sorry... I tried to filter for a new person. If you
think I’ve overlooked something that is important, let me know. Also, I
plan to do other blog entries that promote other sessions.
If you want to write a blog entry about why people should attend IDUG or what sessions they should take, let me know.
Big Data Sessions at IDUG
Attend IDUG DB2 Tech Conference 2013 - Apr 29 - May 3, 2013 in Orlando, Florida
IDUG 2013: Five Reasons Why IDUG Orlando is going to be great this year!
The IDUG DB2 Tech Conference in Orlando
is a MUST attend event for database experts and those aspiring to be an
expert! And this year is special beyond special! Why? DB2 is 30
years old and IDUG is 25 years old. Come and celebrate these amazing
accomplishments while you’re learning.
There are many things to learn about... here are a few for you to consider:
1. Robust Technical Session Schedule
are designed to fit your needs. You will have no problem filling your
agenda with the right education for your job role and organization's
2. Celebrations for IDUG's 25th Anniversary
mentioned above, IDUG is 25 this year! Join us to look back at where we
have come from and see where IDUG is headed in the future.
3. IBM DB2's 30th Anniversary
DB2 will also celebrate a significant milestone in 2013. Stay tuned for
more information about celebrations for IBM DB2's 30th anniversary.
4. One Day Seminars
The perfect opportunity to learn more about specific aspects of DB2 that you deal with on a day-to-day basis.
5. Certification Exams
advantage of this opportunity to gain IBM professional certifications
at no additional cost. All IDUG DB2 Tech Conference attendees are
eligible to take two complimentary certification exams.
6. Save on Registration, Be an IDUG Mentor
offers an incomparable loyalty reward program for those who have
attended three or more IDUG conferences, are an IBM Champion or are a
member of a Regional User Group.
7. Complimentary Wi-Fi
Throughout the meeting space and in each hotel guest room at the Caribe Royale All-Suite Hotel and Convention Center.
8. Easy-to-Navigate Meeting Space
The Caribe Royale All-Suite Hotel and Convention Center is compact and easy to navigate.
in Orlando, gain access to old and Stay Connected new connections.
Trade business cards with industry leading vendors, your DB2 peers and
speakers at the Exhibit Hall and networking events sponsored by some of
IDUG's top vendors
10. Hot Industry Topics
Hear from experts regarding their opinions on important topics. Key sessions include:
Explaining Tuning Results to the C-level
Thomas Baumann, Swiss Mobiliar:
DB2 10 LUW Securely Hiding Behind the Mask
Rebecca Bond, SAP DBA Contractor
The 10 Commandments of Supporting E-commerce Databases
Ember Crooks, Rosetta
The Top Ten Things You Need to Know: For DBAs, Developers and Managers
Craig Mullins, Mullins Consulting, Inc.
Register before March 22 and save on registration!
I have much more to say on this topic, so be sure to follow my blog to avoid missing any updates.
Last Friday Dan Dubriwny from the Big Data Tiger Team, IBM USA, was the guest speaker on episode 62 of the DB2 Night Show, hosted by Klaas Brant. The topic was BIG DATA Overview - What is it? Who cares? If you missed it, be sure to catch the replay.
According to Klaas:
If you have been to IOD 2011 in Las Vegas then the words Big Data will probably still resonate in your mind. The theme of IOD was "Turn Insight into action" and IBM is the only company that can do this for all sort of big data. Most people think that big data is all about Hadoop. And although Hadoop is one of the components in IBM's solutions it is not what big data is all about. Dan Dubriwny gives in this episode an excellent introduction into big data. It is all about Variety, Velocity and Volume. IBM can handle all of this for both data streams and data at rest. Probably by now you are curious how this all works, so go ahead and enjoy Dan's presentation with numerous examples.
Scott Hayes informs me that there is more… much more! Episode #63 on 18 Nov will be a deep dive into IBM solutions around BIG DATA.
Join special guests Paul Zikopoulos and Robert Thomas, both from IBM, to get a look at why IBM is the right partner for Big Data. You'll find that many vendors offer Big Data products whereas IBM is offering a Big Data PLATFORM. Most of this session will be technical--- show casing, for example, the file system (GPFS SNC) that's used with the IBM Big Data platform as opposed to the open source defacto standard HDFS because it provides better performance, management (it's POSIX compliant), security, and availability; with GPFS SNC, IBM hardens Hadoop for enterprise deployments. Of course, no one quite understands the enterprise like IBM so you can bet we are solving other enterprise challenges such as security, integration, governance, and more.
The DB2Night Show Episode #63: BIG DATA Technologies, Solutions, and Details
Speakers: Paul Zikopoulos and Robert Thomas
Friday, November 18, 2011
11:00 AM - 12:00 PM EST
As Scott always says, join to be educated, informed, and entertained.
Want more on Big Data? Check out this entry: Do you feel the excitement of Big Data?
As you’ve noticed, I’m promoting the upcoming IBM Information on Demand Conference via my blog. Many Europeans are unable to afford the time or money to go all the way to Las Vegas for a conference, so the good news is there is an amazing conference planned for Prague in November. I’m hoping that I can attend in order to set up a bookstore for attendees.
IDUG DB2 Tech Conference in Prague, Czech Republic, 13-18 November 2011, at the Clarion Congress Hotel Prague
- Register on or before 17 October 2011 and receive a discount of EUR 275.
- Multiple Delegate Discount: For every three individuals who register from the same organization, a fourth may attend at the discounted rate of EUR 730.
- Mentor Program: If you have attended three previous IDUG DB2 Conferences, you are eligible to bring a first-time colleague to Prague for an 80% discount off the full registration fee.
How you can hone your expert DB2 skills at IDUG EMEA
- Members of IDUG get 45% off IBM Press books. New books include Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture, The New Era of Enterprise Business Intelligence: Using Analytics to Achieve a Global Competitive Advantage, and The Art of Enterprise Information Architecture: A Systems-Based Approach for Unlocking Business Insight.
- On 13 November, receive FREE IBM certification training, DB2 migration workshops and sessions for CA customers.
- IBM Certified Database Administrator - DB2 10 DBA for z/OS certification Preparation Seminar - Susan Lawson
- DB2 UDB V9.7 for LUW Advanced Database Administration certification Preparation Seminar - Guy Przytula
- One-Day Educational Seminars - Friday, 18 November 2011
Registration for paid full conference delegates is EUR 450; the cost for just the one-day seminar is EUR 495. Select from the following session topics:
- DB2 10 for z/OS - In Depth, Phil Grainger, Cogito
- DB2 Intermediate and Advanced SQL, Daniel Luksetich, Yevich Lawson & Assoc Inc.
- I Didn't Know DB2 did THAT!, Bonnie Baker, Bonnie Baker Corporation
- Optimising DB2 for z/OS System Performance Using DB2 Statistics Trace, John Campbell, IBM Corporation
- Rocket Science: DB2 for LUW Performance Analysis and Tuning Workshop, Scott Hayes, DBI
- Some of the top rated speakers:
For the complete agenda and speaker list, see this site: http://www.idug.org/p/cm/ld/fid=102
Have you been taking advantage of the rich content available from IDUG? IDUG is the Worldwide DB2 User Community and if you don’t yet know about them, but work with DB2, you should take a look at what they offer:
1) A very rich website filled with resources that you can access to deepen your skills. Resources include CDs filled with conference presentations, webcasts, videos, blogs, articles, Solutions Journal e-Magazine and more.
2) Three full conferences each year: one in North American, one in Europe, and one in Asia. In 2011, the conferences will be:
IDUG North America 2011, May 2-6, 2011, Anaheim, California, USA
EMEA - 14-18 November 2011 in Prague, Czech Republic
ASIA – To be announced.
3) Regional symposiums and events throughout the year and the world.
4) If your educational budget is limited, please remember IDUG's Mentor Program where you may qualify for a special low rate if you bring a first time attendee to an IDUG conference.
5) Volunteer opportunities. You can speak, teach, organize, plan, or get into leadership positions. More about this:
IDUG is a volunteer run organization. In order to appropriately recognize excellent work from our many IDUG volunteers, the Volunteer Management Committee of the Board of Directors is now accepting nominations for IDUG Volunteer of the Year. If you have seen exceptional effort, exemplary work, or outstanding performance from an IDUG Volunteer, please send the specifics to firstname.lastname@example.org.
Have you ever thought of serving on the IDUG Board of Directors? Do you know someone who might?
The IDUG Board of Directors is responsible for setting the overall strategy for our organization, and coordinating the activities of our various volunteer teams around the world. We are beginning the process of putting together the 2011/2012 slate, and would like to invite nominations for a role on next year’s Board of Directors. This is a great opportunity to help shape the organization and grow the worldwide DB2 community.
If you have a clear vision for IDUG’s future, can think strategically as well as tactically and are passionate about IDUG’s mission, we want to hear from you! If you know of someone else who fits these criteria and would like to nominate them, that’s fine too!
Please complete the form by clicking here and return it to email@example.com no later than Monday, 27 December 2010.
Join IDUG for free and get connected to a fabulous community of people who will quickly and easily become a second family to you.
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!