Modified on by svisser1
Congratulations to Jacques Roy for the completion of his latest book:
The Power of Now
Real-Time Analytics and IBM InfoSphere Streams
This book will launch at the IBM Insight conference in Las Vegas. You can get a free book and have it signed by Jacques if you are an attendee of the conference. Jacques will be signing the books at the IBM Insight Conference Bookstore on Tuesday October 28 from 9:30 – 10:30 am. There are only a limited number of copies at the conference, so if this is a book you want, you should make sure you put the day and time in your schedule.
What’s the book about? It is about the really great product from IBM called InfoSphere Streams. I attended a few tweetchats in the past year and was happy to see the number of people who mentioned this product and the value it brings to them as they analyze data-in-motion. InfoSphere Streams is the world’s fastest and most flexible platform for streaming data. Sounds interesting, doesn’t it!
I was asked to help write the content for the covers of this book and read several chapters of the book and I find the topic quite interesting. Here is what we put on the cover of the book:
Read this book to:
Understand how the integration of multiple technologies form a big data architecture that can process data, both at rest and in motion
Learn how real-time distributed analytics can provide insights to create a business advantage and currently unseen opportunities
Discover the ways to implement a data-in-motion solution that works for your environment
Explore the characteristics that make a good real-time distributed analytics platform
Learn understand how to apply InfoSphere Streams technology to your business problems to get solutions faster
IBM InfoSphere Streams provides a new approach to processing information by providing an easy-to-program platform for distributed real-time analytics that can answer the need to generate information from the huge amount of data that comes at businesses rapidly.
In “The Power of Now: Real-Time Analytics and IBM InfoSphere Streams”, discover how distributed real-time analytics can uncover opportunities in your enterprise providing more efficiency and a business advantage. Technology is changing rapidly, and there is so much of it to learn. This book gives you a shortcut to becoming proficient with InfoSphere Streams so that you can dive into implementing a solution for your enterprise.
About the author:
If you’re not going to be at the conference, you’ll still have a chance to get a copy of the book, but in electronic format. I’ll write a new blog entry when the PDF version is available so you can download your free copy.
Flashbooks can be downloaded in PDF format for free. Here are the Flashbooks that were featured at events in 2013:
During this week’s #bigdatamgmt TweetChat that was focused on Getting Control of Data in Big Data Era",
I noticed that many of the experts recommended articles to emphasize
their points. I’ve gathered all of these recommendations to create this
reading list. I hope you find this valuable.
You must increase control of wasteful data even with Big Data
Management, archive/retire & dispose. Big Data doesn’t change
retention. Keep the data you need, get rid of the rest . You can’t
afford to keep it all. Big
Data is not immune to the laws of information economics. You must
increase control of wasteful data even w Big Datamgmt, archive/retire
& dispose. Infosphere Optim helps you get control of structured
data to feed only the good into Big Datamgmt.
PPB13 How do practitioners overcome emerging skepticism in the marketplace?
Without good data stewardship & Big Datamgmt it will difficult to
unlock the value of big data. To deal with Big Data, speed, and volume:
be proactive by starting Big Data Management across the enterprise
now & maintain. Start now on data quality because if you don’t have it in now Big Data only magnifies data issues.
For more Big Datamgmt resources Data Privacy and Security. Exploring
Big Data still requires trusted data so you must secure and govern even
Big Data refers to datasets whose size, type and speed of creation make
it impractical to process and analyze with traditional tools. That Big
Data definition comes from wikibon; see Big Data Vendor Revenue and Market Forecast 2012-2017. So given that, definitionally then, traditional concepts are at the very least “impractical”… no?
BTRG_MikeMartin You can’t make good business decisions on bad data.
Data governance is critical in the Big Data management era as it makes
small problems bigger. You need data quality to enable Biginsights
searchCIO Metadata practices are gaining momentum as companies tackle Big Data.
searchCIO Data Quality is essential to master Big Data Management
dvellante Perspectives from a former CIO on the importance of data quality
furrier Dirty data equals poor user experience. I wrote about it in 2009 re: twitter facebook & social data
craigmullins Consider non-intrusive data governance; see this article by my friend Bob Seiner
great resources! For our next tweetchat, we’d like to build a reading
list that is sent out prior to the chat. Wednesday, March 15: Topic: Mobile Challenges for the Enterprise. Stay tuned for more information about this event.
To find out more about managing big data, join IBM for a free event on April 30: Big Data at the Speed of Business
What are you sacrificing for the promise of big data?
Recap of Tweetchat: "Getting Control of Data in Big Data Era"
Part 2: Recap of Tweetchat: "Getting Control of Data in Big Data Era"
What is a Tweetchat and why should you join us?
Big Data & Database Technology
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.
a treasure chest full of great content from experts. Articles,
tutorials, best practices, downloads, spotlights, podcasts, videos... so
much is available to help you deepen your skills... all for FREE. 2012
was a busy year and I’m pleased to tell you the top 10 articles that
were published. Were you one of the readers who helped make these
articles to the top? Check it out. Read the ones you missed. Share
the ones you liked.
- Comparing the Informix Version 11 Editions by Carlton Doe
about the various editions of IBM® Informix®? In this article, get an
introduction to each edition, then you can compare features, benefits,
and licensing considerations in a side-by-side table. Regardless of
which edition you choose, Informix brings you legendary ease of use,
reliability, stability, and access to extensibility features.
- Run Oracle applications on DB2 10 for Linux, UNIX, and Windows by Serge Rielau
DB2® 10 for Linux®, UNIX®, and Windows® has out-of-the-box support for
Oracle's SQL and PL/SQL dialects. This allows many applications written
against Oracle to execute against DB2 virtually unchanged. In this
article, get a high-level overview of what Oracle compatibility means in
DB2. Whether you want to switch your custom application to DB2 or
extend your DBMS vendor support to DB2, now is your time. [2012 15 May: This article has been updated to include new resources.]
- Hadoop Tutorial: Hello World with Java, Pig, Hive, Flume, Fuse, Oozie, and Sqoop with Informix, DB2, and MySQL by Martin Lurie
article is focused on explaining Big Data and then providing simple
worked examples in Hadoop, the major open-source player in the Big Data
space. You'll be happy to hear that Hadoop is NOT a replacement for
Informix® or DB2®, but in fact plays nicely with the existing
infrastructure. There are multiple components in the Hadoop family and
this article will drill down to specific code samples that show the
capabilities. No Elephants will stampede if you try these examples on
your own PC.
- Migrating from the DB2 Control Center to IBM Data Studio by Antonio Maranhao, Kevin Jiang
the IBM® DB2® Control Center tools have been deprecated in DB2 9.7,
users have been encouraged to adopt IBM Data Studio and IBM InfoSphere®
Optim™ tools for managing DB2 databases. IBM Data Studio 3.1 was
released in October 2011 with several enhancements over previous
versions, making it an excellent replacement for Control Center. This
article aims to help DB2 users who are familiar with Control Center
tools to quickly transition to IBM Data Studio.
- Designing a database for multi-tenancy on the cloud by Raul Chong
some considerations that new software as a service (SaaS) vendors need
to take into account when developing applications or modifying existing
ones to enable them for multi-tenancy on the cloud. The article
discusses the considerations only from a database perspective —
specifically, from an IBM® DB2® perspective. Six cases or methods are
- Physical database design for OLTP environments by Amyris Rada and others
article focuses on physical database attributes that are affected by
the specifics of DB2 database servers in online transaction processing
- IBM federated database technology by Eileen Lin, Laura Haas
a large modern enterprise, information is almost inevitably distributed
among several database management systems. Despite considerable
attention from the research community, relatively few commercial systems
have attempted to address this issue. This article describes the
technology that enables clients of IBM's federated database engine to
access and integrate the data and specialized computational capabilities
of a wide range of relational and nonrelational data sources.
- A flexible data integration architecture using InfoSphere DataStage and InfoSphere Federation Server by Wendy Tam and others
InfoSphere® DataStage® and InfoSphere Federation Server to provide an
efficient and flexible architecture for moving and transforming data.
This article promotes the use of InfoSphere Federation Server as a "data
pre-processor" for InfoSphere DataStage, and demonstrates situations in
which the combination reduces both the elapsed runtime (by as much as
91 percent) and overall resource consumption of the job. The article
does not promote the combination of InfoSphere Federation Server and
InfoSphere DataStage for all data consolidation scenarios, rather it
attempts to characterize the situations in which the combination is most
- Starting your education in big data: free courses with hands-on labs you can run on the cloud by Raul Chong
about current free, online courses that are available at
BigDataUniversity.com. Follow the suggested path to get started and grow
your knowledge on big data, and get ready to implement it to meet your
own business needs.
- Analyzing social media and structured data with InfoSphere BigInsights by Cynthia Saracco, Anshul Dawra
you want to work with "big data" without writing code or scripts,
you'll want to look into BigSheets. BigSheets is a spreadsheet-style
tool for business analysts provided with IBM® InfoSphere® BigInsights, a
platform based on the open source Apache Hadoop project. This article
teaches you the basics of using BigSheets to analyze social media and
structured data collected through sample applications provided with
BigInsights. You'll learn how to model this data in BigSheets,
manipulate this data using built-in macros and functions, create charts
to visualize your work, and export the results of your analysis in one
of several popular output formats.Congratulations
to all these authors for a job very well done! I hope you plan to
write more this year because we’d like more great content from you!Susan
One of the IBM Redbooks that will be featured at the IBM Information on Demand Conference this year is:
Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition, SG24-8031-00
by Jon Lind, Pat Bates, Whei-Jen Chen, Timothy Donovan, Garrett Fitzsimons, Rogerio Silva
you’re attending the conference, you have the chance to pick up a
printed copy of this IBM Redbook and to have it signed by two of the
authors: Jon Lind and Pat Bates. There are only a limited number of
printed copies to hand out, so you must ensure that you are at the IOD
Bookstore at the scheduled time to get your copy.
The date and time scheduled for this book is Tuesday, October 23, 12:00 - 1:00 pm.
If aren’t able to get a printed copy, you can download your free copy in PDF or EPUB versions.
If this is your area of interest, I’d like to recommend a few other books for you to consider as well:
Sessions by Jon and Pat:
2873A Pervasive Business Analytics: Enabling Faster, More Accurate Business Decisions; Wed, Oct 24, 2012; 2:30 PM - 3:30 PM - South Pacific D
3033A End-to-End Data Warehouse Modeling for Performance and Data Governance; Thu, Oct 25, 2012; 10:00 AM - 11:00 AM - South Pacific D
are many sessions being offered in this area, so be sure to check
through SmartSite thoroughly to ensure you don’t miss an important
DB2 10 Redbook, "Unleashing DB2 10 for Linux, UNIX, and Windows”
Free printed IBM Redbooks at IOD
Check out the guest blog entries that are coming fast & furious on the Official IOD Blog:
Stay tuned for more guest blogs from IBM’s Best Friends: IBM Champions. Susan
- Dave Beulke has a trio of great new posts on his blog:
Lots of people love IBM Redbooks. As you know, they are FREE and available
for you to download in PDF or EPUB versions at anytime from the IBM Redbooks website.
One of the most popular giveaways at IBM Information on Demand Conference is
printed IBM Redbooks. This year we have 10 different titles to give away.
Please note that the PRINTED copies are in limited quantity.
Make sure you attend one of the sessions planned at the bookstore to make sure
you get the title that you want. While you're getting your free copy, meet the authors who wrote the book and have them sign it for you!
I included links to the eversion of the book if it already exists. Notice
that some are not yet published? They’ll be launched specifically for IOD:
Tuesday, October 23, 12:00 – 1:00 at the IOD bookstore
Customizing and Extending IBM Content Navigator
Wednesday, October 24, 12:00 – 1:00 at the IOD bookstore
Thursday, October 25, 12:00 – 1:00 at the IOD
As you can see, we’ve made it easy for you. Come by the bookstore Tuesday,
Wednesday and Thursday at lunchtime to get a printed book!
While you’re at the bookstore, check out the technical books that are available for you to purchase at a
20% discount as well as pick up one of the many free Flashbooks that are scheduled to
be handed out at the bookstore on Monday, October 22.
Tech Talk Details:
Best Practices in DB2 for Linux, Unix and Windows Application
Thursday August 30, 12:30 PM ET
Speakers: Holly Hayes and Cliff Leung
Join host Serge Rielau with guests Holly Hayes and Cliff
Leung for a deep dive into IBM InfoSphere Optim
solutions that offer the state of art performance monitoring
and optimization technology for DB2 for LUW.
Rigorous performance monitoring and management are crucial for business
critical applications. Even with premier in-engine query optimization,
application performance for DB2 is dependent on factors like available
resources, good database design and data access best practices.
Using these performance management solutions for DB2, Holly and Cliff will
show you how to:
- identify emergent performance related problems
- diagnose where the problem resides
- resolve issues in the application or database design
- proactively prevent performance problems from re-occurring.
The featured offerings include:
- IBM InfoSphere Optim Performance Manager
- InfoSphere Optim Query Workload Tuner
- InfoSphere Optim Configuration Manager
- InfoSphere Optim pureQuery Runtime
which are also part of DB2 Advanced Enterprise Edition and
InfoSphere Warehouse Advanced Enterprise Edition.
Have you missed any of the previous TechTalks? No worries, they were
recorded and are available whenever you are:
PS: Thanks Serge Rielau and Cindy Russell
for your dedication to this program.
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!
IBM Press Earth Day Sale
Save 50% on eBooks with Coupon EDIBM
You don't necessarily need paper products to learn—step into electronic
learning with digital products from IBMPressbooks.com. From eBooks to
online-only content, we have a wide range of environmentally-friendly options
that provide the answers you are looking for, without the paper. And now you can
save when you stock up—buy any 2 eligible eBooks, and save 50% with coupon
EDIBM. Offer valid through 04/24/2012. Start
Need some suggestions? Here’s what I’d recommend:
There are so many places for you to keep your skills sharp with DB2 and
InfoSphere, that sometimes it gets difficult to “see the trees for the forest”!
I hope that this is a list that you’ll save and go back to often to help you
find your way.
A wide range of IBM experts, programs, and services are available to help you
take your information management skills to the next level. Participate in our
online community though developerWorks. Find whitepapers, videos, demos, DB2
Express downloads, and more. Visit ibm.com/developerworks/data/.
IBM Certification Exams
Find industry-leading professional certification exams, including new
certifications for DB2 10.1:
- DB2 10.1 Fundamentals (Exam 610)
- DB2 10.1 Database Administrator for LUW (Exam 611)
- DB2 10.1 Advanced Database Administrator for LUW (Exam 614)
The first exam is scheduled to be active in time for IDUG. Visit ibm.com/certify for more
information and exam availability.
Find cost-effective and green online learning options, such as private online
training, as well as traditional classroom education, all taught by our
experienced world-class instructors. DB2 10 training includes the following:
- DB2 10.1 for Linux, UNIX, and Windows New Features and Database Migration
- Fast Path to DB2 10.1 for Experienced Relational DBAs
- DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced Relational
Visit ibm.com/software/data/education for details and course
Information Management Bookstore
Find electronic versions of our free flashbooks, links to the most
informative information management books on the market, along with valuable
links and offers to save you money and enhance your skills. Visit ibm.com/software/data/education/bookstore.
IBM Support for DB2 10
Access the award-winning IBM Support Portal to find technical support
information for DB2 10, including downloads, notifications, technical documents,
flashes, alerts, and more. Visit ibm.com/support.
Data Management Magazine
IBM Data Management magazine delivers interactive, highly dynamic
content, including webinars and video about the technical topics of interest to
you. Connect with a community of the world’s top information management
professionals and a broad range of voices from across the industry. Visit ibmdatamag.com.
Big Data University
Learn SQL, DB2, and other hot technologies at your pace and at your place.
Big Data University offers helpful online courses with instructional videos and
exercises to help you master new concepts. Course completion is marked with a
final exam and a certificate. Visit bigdatauniversity.com.
International DB2 User Group (IDUG)
IDUG is all about community. Through education events, technical resources,
unique access to fellow users, product developers, and solution providers, IDUG
offers an expansive, dynamic technical support community. IDUG delivers quality
education, timely information, and peer-driven product training and utilization
that enable DB2 users to achieve organizational business objectives and to drive
personal career advancement. Visit idug-db2.com and idug.org.
Join the Conversation
Stay current as DB2 10 evolves by using social media sites to connect to
experts and to contribute your voice to the conversation. Visit one or more of
- Smarter Questions
- Thoughts from Information Management Support Blog
your Skill on IM products, including DB2: books, certifications, tutorials, and
Tips for DB2 LUW by Serge Rielau
I hope you find something useful in this list, which is by no means
Look at this great webinar that is taking place Monday, April 23 at 1:00
Optimize Your Data Integration Environment with the InfoSphere Information
Server Operations Console
Many users need access to the operational metadata of their data integration
environments. Whether they are confirming that the environment is live,
reviewing job run history, or working to troubleshoot system failures, these
users need direct access to the most relevant information in order to perform
their jobs efficiently. These users may be production operators, development
teams, or other stakeholders, and they can get that access with the new
InfoSphere Information Server 8.7 Operations Console.
Join Gary O’Connell and Arron Harden for this Tech Talk
session as they examine in detail the features of the new Operations Console.
They will demonstrate, through realistic user scenarios, the business value that
is gained by using the console to complement and extend data integration and
Sounds like a great topic! Mark your calendars now. Here are the
Talk: Optimize Your Data Integration Environment with the
InfoSphere Information Server Operations Console
Date: Apr 23, 2012
Time: 1:00 PM - 2:00 PM (Eastern Time)
Hosted by: Gary O'Connell
Presented by: Arron Harden
Register now: https://events.webdialogs.com/register.php?id=4ff82cf5e8&l=en-US
About the speakers: Arron and Gary are both members of the IBM Infosphere
I’ve been reading IBM Data Management magazine
since it was launched 15 years ago. I’m sure you’ve read an issue or two as
well! The next generation is about to launch and it will capitalize on digital
The world looked very different when the IBM Data Management
magazine was first launched. Digital technology allows a whole new world
of opportunities and the new online format gives us more flexibility to cover
the latest information management developments and IBM advances as they happen.
IBM Data Management
magazine will deliver new kinds of interactive, highly dynamic content,
such as webinars and video. And it gives us a platform on which to create a
strong community of the world’s top information management professionals. This
inflection point also represents a unique opportunity for us to feature a
broader range of voices from across the industry. We're always looking for great
stories and now because we can update content almost immediately, it will be
easier for us to highlight important topics that are timed to a specific day and
Another benefit of going digital is it will make it much easier for you to
find previously published content. A little known fact is that we have 4 years
of articles available for you to search & read. I’m sure you’ll find a
treasure in this vast collection.
Bookmark the URL for the magazine and check back often to find out about the
latest hot topics!
PS: If you’d like to contribute to this magazine, reach out to me and I’ll
connect you with the editor. If you need help writing an article, I highly
recommend that you read Roger Sanders’ book: “From Idea to Print: How to Write a Technical Book
or Article and Get It Published”.
The next DB2 TechTalk is scheduled for March 29. The topic is “Data Archiving: best practices to improve database performance and reduce costs” The speaker is Eric Naiburg, Program Director, Information Governance Solutions from IBM and he will present the full technical details on how to leverage the InfoSphere Optim solutions that help you control data growth.
When it comes to data, more isn’t always better. Users demand that applications perform at their best, yet system complexity and data volumes continue to grow. This causes application and database performance to slow.
Even with powerful systems like DB2 on Linux or z/OS platforms, SLA requirements are reaching their upper limits. This means that you must be extra diligent in managing your database operation to remain within SLA limits and that can mean significant time, resources and money—all of which can be better spent on adding new capabilities. That is why organizations around the world rely on the IBM® InfoSphere Optim Data Growth Solution to automatically control data growth, leveraging archiving to improve performance, reduce costs and ensure that data retention, disposition and compliance requirements are satisfied.
In this technical session, we will discuss ways to improve application and database performance and reduce costs by:
- Reducing the volume of data in your production databases
- Controlling data growth in transactional and warehouse systems
- Archiving and storing historical transactions securely and cost-effectively while still maintaining universal access
- Ensuring access to historical data for compliance, queries and reporting
- Ensuring compliance readiness
Date: Mar 29, 2012
Time: 12:30 PM - 2:00 PM (Eastern Time)
Hosted by: Serge Rielau (IBM)
Presented by: Eric Naiburg (IBM)
Register now: Data Archiving Webinar
Join Serge Rielau and Jon Lind for the next DB2 Tech
Talk (formerly known as Chat with the Lab) on Thursday Feb 23 at 12:30
pm ET. The topic: Solving Complex Data Warehousing Problems with Advanced Tooling of
InfoSphere Warehouse Advanced Editions
IBM InfoSphere Warehouse Advanced Enterprise Edition adds leading
architecture, performance, backup, and recovery tools that help increase
efficiency and reduce time to market through increased understanding of current
data assets while simplifying daily operations of managing complex warehouse
deployments. This session will explore in detail the tooling provided as part of
the InfoSphere Warehouse Advanced Enterprise Edition.
Delivered as part of the Advanced Editions, a comprehensive set of
warehouse packs enable you to deploy leading industry models and Cognos reports
to more easily understand and gain insight into your markets and campaigns,
customers, and supply chains. Whether its insight into customers, markets and
campaigns, or your supply chain one of the included Warehouse Packs has a model
ready to deploy and start loading your businesses data. The included Cognos
reports provide a set of sample reports that then can be enhanced and tailored
for your specific business needs. During this session we will examine the
functionality of these packs and show an example deployment.
The availability and integrity of data in operational data warehouses is
becoming more and more critical to the business enterprises requiring increased
SLAs. Solutions comprised of the Recovery Expert, Merge Backup and High
Performance Unload tools provide unique capabilities for changed data analysis,
elimination of physical or logical data errors and maximizing data availability.
We will examine in detail the features these solutions present and demonstrate,
through realistic user scenarios, the business value that can be gained by
complementing and extending your data management and recovery strategies with
DB2 Tech Talk - Solving Complex Data Warehousing Problems with Advanced Tooling of
InfoSphere Warehouse Advanced Editions
Date: Thursday Feb 23, 2012
Time: 12:30 PM - 2:00 PM (Eastern Time)
Hosted By: Serge Rielau (IBM)
Presented By: Jon Lind (IBM)
Interested in Data Warehousing? Here are some of my previous blog entries on
Here are a few tips I’ve gathered over the years that may help you with your quest to get certifed:
- Most of the IM certification exams have a time limit of 90 minutes, except the upgrade exam which has a time limit of 60 minutes. The number of questions and the cutscore for each exam varies. For example, exam 730 has 64 questions and you must score 59 percent or higher to pass it.
- Make sure you check out the exam objectives before you study. Every question on the exam relates directly to one or more of the exam objectives. You can find the exam objectives by going to the specific page for the exam on this site: IBM Professional Certification.
- If you are experienced with DB2 and feel that you are prepared to pass the exam based on what you saw in the exam objectives, take an assessment exam. You'll get a report after taking the assessment exam that can help you pinpoint your weaknesses. Assessment exams cost $10 per take, so if you really think you are ready, come and take the exam to see.
- If you are NOT experienced with DB2, download a free version of DB2 Express-C and give it a try!
- Decide on how you want to increase your skills:
a) Consider buying one of the Certification Study Guides to refresh and deepen your skills: ibm.com/software/data/education/bookstore.
The Certification prep guides were written by members of the exam development team. That is, they created the questions for the certification exam that you are about to take! Also, each chapter of the book corresponds directly to a section on the exam. So, if you take the assessment exam and find out that you are week on a single topic, you simply need to read the chapter that corresponds to the topic where you need improvement. Lastly, the authors created a set of sample questions for the book that provides you with the correct answer to the question as well as an explanation as to why the correct answer is correct and the incorrect ones are not.
b) For self-study, also check out the free tutorials that IBM provides for most of the exams. The tutorials are broken into hour long segments of information based on the exam objectives. If you have a great deal of experience, this may be all you need to prepare for the exam. To see the full set of exam prep tutorials that are available, see ibm.com/software/data/education/selfstudy.html.
c) Take an education class from IBM or one of its partners. These classes typically have a fee, even for employees, so check with management to see if you can take one of these classes. Classroom education is an excellent way to learn, but may be difficult to justify due to costs. Don't forget to look into ILO training as this type of training gives you all the benefits of classroom education, but eliminates the travel costs. The best place to start to determine the classroom education that best fits your needs is with the training roadmaps: ibm.com/software/data/education/roadmaps.html.
- If this is your first time taking a certification exam, review the steps on this site: ibm.com/certify/process/t_proc.shtml
Can I gain experience by reading DB2 Forums and Blogs?
Absolutely! There are several DBAs who firmly believe helping out on the various forums have helped us gain a deeper understanding of subjects that were on the exams. So, contribute to those forums. You're not only helping other people, you're helping yourself as well! Most likely you'll find members of the DB2 development team actively taking part in the forums as well.
Here are the sites that I recommend, at the least:
I hope you find this information useful! Good luck on your journey towards certification!
See other blog entries about this topic:
PS… If you like this content, please follow by blog :) Next week’s theme? Either Best Practices or Books.
I find it easiest to blog about DB2 certifications for a couple of reasons. Mainly because my former job was Certification Program Manager, so I was responsible for all V7 and V8 DB2 exams, including the first DBA exam for DB2 for z/OS. It is hard to get some of these details out of your head, so when I blog, this is easy.
Also, I work in the Toronto lab and am surrounded by DB2 experts in all categories of software development. Again, this puts DB2 on my mind more than any other area of IM. And finally, DB2 is the most popular certification program in IBM’s SWG. I hope that I was part of the reason for the massive popularity for some of the strategies I put in the place way back when, but who knows and who cares. I’m very pleased it is a popular program and as such, this again makes it easy to blog about DB2 rather than other IM programs.
But… certification does exist outside of DB2, and you should know about these as well. Here they are, but product group:
Dynamic Data Warehousing and Business Intelligence
IBM Certified Solution Designer - InfoSphere Warehouse V9.5
Pass Exam 719 to earn this certification. Study resources include IBM classes & Redbooks.
Information Platform Solutions
IBM Certified Solution Developer - InfoSphere DataStage v8.0
Pass Exam 418 to earn this certification. Study resources include IBM classes.
IBM Certified Solution Developer - InfoSphere DataStage v8.5
Pass Exam 421 to earn this certification. Study resources include IBM classes.
IBM Certified Solution Developer - InfoSphere QualityStage v8
Pass Exam 419 to earn this certification. Study resources include IBM classes.
IBM Certified Solution Developer - InfoSphere QualityStage v8.5
Pass Exam 422 to earn this certification. Study resources include IBM classes, Product Documentation, and Redbooks.
IBM Certified Solution Developer - WebSphere IIS QualityStage v7.5
Pass Exam 416 to earn this certification. Study resources include IBM classes.
IBM Certified Solution Developer - WebSphere IIS DataStage Enterprise Edition v7.5
Pass Exam 415 to earn this certification. Study resources include IBM classes.
IBM Certified Solution Developer - WebSphere Information Analyzer v8.0
Pass Exam 417 to earn this certification. Study resources include IBM classes.
IBM Certified Solution Developer - WebSphere Information Analyzer v8.5
Pass Exam 423 to earn this certification. Study resources include IBM classes.
IBM Certified Developer - InfoSphere MDM Server v9.0
Pass Exam 420 to earn this certification. Study resources include IBM classes.
IBM Certified Application Developer
IBM Certified Application Developer - Informix 11.50
Pass Exam 556 to earn this certification. Study resources include IBM classes, Product Documentation, and Redbooks.
IBM Certified Developer - Informix Genero
Pass Exam 559 to earn this certification. Study resources include IBM classes and Product Documentation.
IBM Certified Database Associate
IBM Certified Database Associate - Informix Dynamic Server 11.50 Fundamentals
Pass Exam 555 to earn this certification. Study resources include IBM classes and Free Tutorials.
IBM Certified Database Associate - Informix 11.70 Fundamentals
Pass Exam 558 to earn this certification. Study resources include IBM classes and Product Documentation.
IBM Certified Solutions Expert
IBM Certified Solutions Expert - Red Brick Warehouse V6 System Administrator
Pass Exam 914 to earn this certification. Study resources include IBM classes.
IBM Certified Solutions Expert - Informix 4GL Developer
Pass Exam 913 to earn this certification. Study resources include IBM classes.
IBM Certified System Administrator
IBM Certified System Administrator - Informix Dynamic Server V11
Pass Exam 918 to earn this certification. Study resources include IBM classes and the following book:
Administering Informix Dynamic Server: Building the Foundation by Carlton Doe.
IBM Certified System Administrator - Informix 11.70
Pass Exam 919 to earn this certification. Study resources include IBM classes and Free Tutorials.
IBM Certified Specialist - Netezza Platform Software v6
Pass Exam 553 to earn this certification. Study resources include IBM classes and Product Documentation.
IBM Certified Specialist - IBM Optim Implementation for Distributed Systems (2009)
Pass Exam 551 to earn this certification. Study resources include IBM classes and Product Documentation.
IBM Certified Specialist - InfoSphere Optim for Distributed Systems - V7.3.1
Pass Exam 552 to earn this certification. Study resources include IBM classes.
IBM Certified Specialist - IBM solidDB and IBM solidDB Universal Cache
Pass Exam 550 to earn this certification. Study resources include IBM classes and Product Documentation.
After writing this, I realized another reason why I tend to focus most of my blogs on DB2 Certifications. The only products with published certification guides are DB2 products. I know of some related books that go with many of these products, but I can’t say for sure if they would be helpful in passing the exams. Watch for a future blog entry that lists the books that do exist for these products.
PS… If you like this post, consider following my blog. More like this to come in the future! Thanks!
The Warehouse team has been busy creating yet another best practice paper.
Best practices: Using High Performance Unload (HPU) as part of a Recovery strategy
IBM InfoSphere Optim High Performance Unload (HPU) for DB2 for Linux, UNIX, and Windows V4.2 is a high-speed tool for unloading, extracting, and repartitioning data in DB2 for Linux, UNIX, and Windows databases. HPU unloads large volumes of data quickly by reading directly from full, incremental, and delta backup images or table space containers rather than through the DB2 software layer.
The database is not affected by the HPU process and table spaces do not need to be placed in an offline state. HPU can therefore offer advantages over other recovery methods in data availability and processing speed. Incorporating HPU into your recovery strategy for scenarios involving data loss or corruption can help achieve service level objectives for data availability and data recovery.
Incorporate InfoSphere Optim HPU into your recovery strategy to provide:
- Reduced recovery times through targeted data recovery
Use the WHERE clause when selecting data from backup images to target only the data that was lost, compromised, or corrupted, reducing recovery time.
- Increased data availability and reduced resource usage during recovery scenarios
Unload data from a backup image and optionally process this data on a non-production system, maintaining availability of the query workload and reducing the effect on the production system.
- Integration with DB2® and Tivoli® Storage Manager (TSM) software
Query TSM to unload data from full, incremental, and delta backup images archived to TSM by the DB2 BACKUP command, reducing errors and facilitating outside recovery.
This article discusses how to incorporate HPU into a recovery strategy and when to use HPU to meet your recovery objectives. In addition the authors contrast the use of output files and named pipes, discuss introducing parallelism, review the HPU command and control file, and recommend best practices for creating control files. Finally, the article details how to install and configure HPU in an IBM Smart Analytics System.
This paper will be followed in the new year with a second paper on HPU that deals with data migration.
Thanks to the hard working team that includes: Garrett Fitzsimons, Konrad Emanowicz from the VLDB team who created and tested all the scenarios discussed in the paper and to Richard Lubell from the DB LUW ID team who steered the paper through to publication. Thanks also to Alice Ma, Austin Clifford, Bill Minor, Dale McInnis, Jaime Botella Ordinas, and Vincent Arrat whose contributions, feedback and experience were invaluable.
Thanks to Garrett and Serge for providing me with this information.
See also my previous posts on Best Practices:
More on DB2 for z/OS Best Practices
Best Practices: Active Data Warehouse Topology using InfoSphere Warehouse
New DB2 WLM Best Practice Paper
Best Practices: IBM Smart Analytics Systems
How do I handle multi-temperature data in my warehouse?
Updated Best Practices Paper: Database Storage
Best Practice Resources for DB2 z/OS
DB2 Best Practices – New or Updated in 2011