Schiefer is the guest on this week’s DB2Night Show. Berni is a DB2
performance legend and you’ll greatly benefit from hearing his talk.
Berni will share the latest news, tips and advice about DB2 LUW 10.Thanks to IBM Champions and hosts of this fabulous show: Scott Hayes and Martin Hubel
Remember, all shows are recorded, so if you miss it, you can still catch up at a later time.
Also remember that Feb 1 begins the 3rd "DB2's Got Talent Competition. For information, see my blog entry: Become a DB2 evangelist by being speaker!
you attend The DB2Night Show on Friday? We had the second show in this
year’s DB2’s Got Talent Competition. I was on vacation during the
first show, so IBM Champion Cristian Molaro was kind enough to fill in
as a judge for me. I’ve listened to the replay, so here is my summary
of both the first and second shows in this series.
Feb 1 - Show 1 of the DB2’s Got Talent Competition - watch the replay.
were supposed to be a few other contestants on this show, but they were
no-shows. We were still able to hear from Ember Mohankumar and Eric.
All three gave great presentations.
Ember - tips for running db2haicu. Ember is moving on to the finals.
Mohankumar - DB2 LUW data movement utilities. Mohankumar is moving on to the finals.
Eric - the best ways to build an audit table using the partitioning feature of DB2 LUW. Eric was chosen as an alternate.
Feb 8 - Show 2 of the DB2’s Got Talent Competition - watch the replay.
We had 5 contestants on this show: Adam, Chris, Renu, Juliano and Sanjay.
Adam - The Real Benefit of Solid State Disks (SSD) Hardware Upgrade.
story was about doing a hardware upgrade that greatly benefited a DB2
9, SAP, and WebSphere Commerce system. Adam’s presentation provided the
basics, but didn’t give enough information to see why an upgrade of
this kind was necessary. Adam was chosen as an alternate.
Chris - Making Life Easier - Letting DB2 Manage your Backup and Archived Transaction Logs.
provided great times that are very easy to follow. They have 2 DBAs in
their office and many databases, tables, and data to manage. Great
story about how they were able to handle such a workload. Chris has
been chosen as a finalist.
Renu - Small Changes, Big Results - Load Performance
Another presentation with great tips. Renu is moving on as a finalist.
Juliano - Efficient Aspects of Deleting Data in DB2 LUW
So many ways to delete data! Juliano will be a finalist.
Sanjay - Plan Management
This was a DB2 for z/OS topic... and a huge topic it is. Sanjay was chosen as an alternate.
Coming up on the show:
Feb 15 - Episode 3 of the DB2’s Got Talent Competition. There may still be room for one additional contestant.
22 - OK... now the judges are being put to work on this show. Martin
Hubel, Klaas Brant and myself have been asked to put together
presentations to share with you!
Thanks again to our amazing host for putting this show together: IBM Champion Scott Hayes!
does “big data” mean to you? It is a term that is widely used and can
convey all sorts of concepts, including: huge quantities of data, social
media analytics, next generation data management capabilities,
real-time data, and much more. Once you’ve figured out what “big data”
actually means to you, you must then figure out how to manage and store
it. Are your current systems able to handle this type of data? How
can you be sure?
Several recent articles and blog entries discuss this theme.
The Commoditization of Commercial Database Management Systems?
by Craig Mullins
are so popular these days that they are being taken for granted. This
article argues that databases are intricate, multi-faceted and useful
tools that are necessary to get the most out of the data that is being
collected and should not be considered a commodity as no two offerings
The Continuing Role of the Database in the New Era of Big Data
by Bernie Spang
amounts of complex big data must be stored in databases in order for it
to be analyzed and made of use to businesses. What features in a
database are necessary to take on this challenge?
Big Data: IBM’s Mainframe Customers Base Grows
by Dave Beulke
Big Data solutions are being embraced by companies worldwide. This
discussion shows that IBM Information Management solutions are well
positioned to fill the needs to handle all your big data.
The Maturing of Big Data: From Herding Cats to Taming Tigers
by James Kobielus
all the recent innovation in the big data market, has big data matured?
Have we figured out how to make big data tigers jump through hoops, or
are we still just herding cats?
Infographic: Taming Big Data
Lots of detail here. Take a look, share the graphic and tell us what you think of it.
Taming Big Data: 12 Best Practices for Analysts - Maria Deutscher Are
you ready to “sink your teeth” into Big Data Technology? Learn how to
start using IBM’s technology correctly in order to get the most out of
your efforts by learning these 12 best practices.
In addition to these articles, I highly suggest that you read the report Analytics: The Real-World Use of Big Data.
It is based on the Big Data @ Work Survey conducted by IBM in mid-2012
with 1144 professionals from 95 countries across 26 industries.
“Across industries and geographies, our study found that
organizations are taking a pragmatic approach to big data.
The most effective big data solutions identify business
requirements first, and then tailor the infrastructure, data
sources and analytics to support the business opportunity.
These organizations extract new insights from existing and
newly available internal sources of information, define a big
data technology strategy and then incrementally upgrade their
infrastructures accordingly over time.”
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.
just got easier with an exciting new initiative for mobile learning.
Be one of the first to participate and provide your feedback!
To learn more about the devices that are supported and how to start, see the Mobile Learning Pilot.
There are two new courses designed to be served up on your mobile device. The total end to end running of each course is a few hours but since they are modular in nature, you can run them in sections to better fit into your busy schedule.
The courses that are available for this pilot are FREE and include:
Easy Steps to Developing BigSheets Function Plugins:
uses the familiar spreadsheet interface to do text analytics of
unstructured and semi-structured data. Coupled with this are a large
number of supplied functions to simplify the analytics process. However,
you may find the need to extend BigSheets and add your own functions.
This tutorial walks you through the development and installation process
required to add a new function to BigSheets.
Configuring an InfoSphere CDC to InfoSphere DataStage Subscription:
Change Data Capture is a tool that captures changes from source
databases and replicates those changes in real-time to target systems.
This tutorial walks you through how to use Change Data Capture to setup
replication from a source DB2 database to a DataStage job.
the end of each course, you will be asked to complete a confidential,
brief survey. Your feedback is a critical step helping us understand
how to provide the best learning experiences for you. Please provide
your feedback by March 31, 2013.
To take part in the pilot, go to The IBM Learning Portal.
Note: the date when we need feedback has changed to March 31, 2013.
There are two DB2 Symposiums coming up in March. Book before Feb 17 to qualify for a 10% Early Bird discount.
DB2 Symposium is a three day training event with one day seminars
presented by IBM Champions & industry leading consultants like
Bonnie Baker, Susan Lawson, Craig Mullins, Dan Luksetich, Cristian
Molaro and Klaas Brant.
DB2 Symposium fills the gap between a conference and a multi-day
training. The DB2 Symposium is unique because you can join us for 1, 2
or 3 days, depending on your needs and budget.
The two locations in March 2013 are:
- March 13-15 - Dallas / Arlington, TX
- March 18-20 - Boston / Marlborough, MA
More about the world-class speakers:
Thousands of programmers and DBAs have enjoyed Bonnie's clear and entertaining style of teaching. This year Bonnie talks about:
- Things I Wish I'd Never Told You
- Matching Indexes to SQL
Susan is well known for her DB2 books and comprehensive certification sessions. Her seminars always receive excellent ratings! Susan's topics are:
- DB2 10 for z/OS Transition: Performance, Usage and Availability
- DB2 z/OS High Performance Design and Tuning: Classic Techniques and DB2 10 Considerations
Craig is the author of the DB2 Developer's Guide.
His latest edition contains more than 1500 pages of in-depth technical
information on DB2 for z/OS updated through DB2 Version 10 in 2012 (6th
edition). He presents:
- DB2 Developer's Guide Comes Alive! (only in Boston)
Dan is the co-author of many DB2 books
and hosts a podcast called the “The DB2 Cocktail Hour”. His new
advanced SQL class has the latest DB2 10 enhancements and focusses on
- DB2 Advanced SQL and Performance
a co-author of more than five redbooks Cristian can be called an
authority on DB2 for z/OS, always praised for his in-depth knowledge. He
- Understanding and fixing common DB2 for z/OS performance problems
- Distributed access to DB2 for z/OS in 2012
has been organizing the DB2 Symposium since 1999. Klaas is known for
his practical approach and useful tips. This time his sessions are all
- DB2 for z/OS XML In-depth (only in Dallas)
- DBA Update
Location for Dallas DB2 Symposium March 13-15, 2013
2401 East Lamar Boulevard, Arlington, TX 76006-7503
hotel is located between Dallas and Fort Worth. The hotel offers free
parking, a free shuttle to DFW Airport and is conveniently accessible
for all companies in the greater Dallas area.
Location for Boston DB2 Symposium March 18-20, 2013
123 Boston Post Road West, Marlborough, MA 01752
hotel is located in Marlborough, just outside Boston. The hotel offers
free parking and is conveniently accessible via highway 90 and 495.
I hope you can attend one or more of these very valuable learning events.
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?
Join this free SSWUG Webcast: The Big Deal about Big Data,
staring expert Paul Zikpoulos. The webinar is free only during the
live broadcast that takes place Wednesday, February 20, 2013, 1:00 PM
Eastern. What you’ll learn: Big
Data can mean a lot of things to a lot of people; but one thing we're
sure of, it's the hottest thing to hit the IT landscape. In this chat
you'll get a comprehensive introduction to Big Data. You'll learn how to
spot Big Data, it's characteristics, and what the opportunities are.
(Hint, be prepared to get shocked on Volume and more). You'll get a
taste of Hadoop, but realize Big Data is so much more. Paul
will also share top things to consider in the Big Data world that's
often overlooked (governance, integration, search, and more). Consider
this: if you Google search 'What is Big Data', you will get almost 1
billion hits!!! If you attend this session, you'll never have to Google
search this phrase again.To register and for additional information see: Webcast Structure and Cost
Note that listening to the live broadcast is free, but ordering the replay has a charge.
The Value of Real-Time Decision Making with PureData Systems for Operational Analytics
host Serge Rielau and guest James Cho (PureData Systems architect) for
an in-depth discussion about how the PureData System supports real-time
decision making. Real time operational warehousing can help your
organization by providing immediate analytics to speed decision making,
for example, fraud detection.
will also explain the features and advantages of this expert integrated
system that provides simplified deployment, maintenance, and more.
world of data management and analytics is changing very rapidly. This
talk is a great way to expand your knowledge to include some of the
emerging techniques and technologies.
Click to register.
Date: Thursday February 28, 2103
Time: 12:30-2:00 PM Eastern / 11:30 AM Central / 9:30 AM Pacific / 17:30hrs London/ 18:30hrs Frankfurt, Paris / India 11 PM
DB2 Tech Talk series is a free set of monthly in-depth technical
webinars from IBM technical professionals. Join the experts to learn
about DB2-related breakthrough technology, best practices, and get your
questions answered during live Q & A sessions at the end of each
Replays of many of the newer webcasts are available on the DB2 Tech Talks page.
Here are some replays you may wish to check out:
tweetchat happens when a group of people all tweet about the same topic
using a specific hashtag that allows it to be followed on Twitter.
We have one planned on Wednesday, February 27 at noon ET, so you can give it a try! Follow #bigdatamgmt to
follow a discussion with panel of experts discussing how data
governance can handle big data. Our panel includes experts from across
the spectrum, including:
and perhaps a few other people as well!
Follow along with the #bigdatamgmt to see the conversation and share your thoughts.
If you’re not yet on twitter, you can still listen to the conversation. Simply use Google Search on the term #bigdatamgmt and you’ll see what has been posted using this term.