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
Thanks to Data Warehouse experts Aruna De Silva and Enzo Cialini for putting together this latest Best Practice article. This paper is called "Active-Active Data Warehouse Topology using InfoSphere Warehouse" and explains how you can create an active-active environment for IBM InfoSphere Warehouse to meet the highest availability requirements using DB2 for Linux, UNIX, and Windows, WebSphere Edge Components, and Q Replication.
As data warehouses are now continually growing in supporting Tier 1 applications, you need fully integrated disaster recovery architecture. Traditional disaster recovery (DR) strategies involve a passive DR site that is not accessible for processing. However, companies are looking to leverage the additional hardware and software investments made in creating this DR site.
The purpose of this paper is to provide an active-active environment for IBM InfoSphere Warehouse by using IBM DB2 Version 9.7 for Linux, UNIX, and Windows database servers to meet the increasing availability and performance requirements demanded in today's business environment. An active-active warehouse architecture addresses two distinct problem domains: continuous availability and disaster recovery.
WebSphere Edge Components, part of IBM WebSphere Application Server Network Deployment (ND) offering, are typically used to control client access to Web servers. In this paper, we demonstrate how Edge Components can be used to load balance DB2 clients among multiple DB2 coordinators based on performance metrics or access control rules.
In addition, we describe how Q-replication is used to maintain two identical copies of DB2 V9.7 data servers in an active-active DB2 data warehouse topology. Finally, we examine some of the challenges associated with operating an active-active DB2 data warehouse and strategies to mitigate those issues.
About the Authors:
Aruna De Silva is on the QA-DB2 Data Warehouse and IM Solutions team with IBM
Enzo Cialini is Senior Technical Staff Member, IBM
If this is your area of concern or expertise, read the full Best Practice Paper: Active-Active Data Warehouse Topology using InfoSphere Warehouse.
See also my previous posts on Best Practices:
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
Congratulations to the Best Practices team for putting out another excellent paper. This one is for Workload Manager: DB2 best practices: Implementing DB2 workload management in a data warehouse
What You’ll Learn:
- The best ways to implement a successful workload management solution using DB2 for Linux, UNIX, and Windows, Version 9.7.4 or higher.
- The information in the article reflects the latest experiences of IBM field personnel and customers within the data warehouse arena.
Using a staged approach, this article guides you through the steps needed to implement the best practices workload management configuration on IBM DB2 for Linux, UNIX, and Windows with sufficient controls to help ensure a stable, predictable system for most data warehouse environments. This initial configuration is intended to be a good base for implementing additional tuning and configuration changes as needed, in order for you to achieve your specific workload management objectives.
You’ll be presented with a set of definitions representing the different stages of maturity for a workload management configuration in a DB2 for Linux, UNIX, and Windows database. These stages range from stage 0 through to the advanced stage 3 configuration. A specific configuration template and process is provided as part of these best practices to enable customers to progress from a stage 0 configuration to a stage 2 configuration. General descriptions and advice are also given about common stage 3 scenarios.
The article assumes a novice beginner and describes the individual steps and mechanisms at each point. A more experienced user can condense many of the listed steps to move from stage 1 to stage 2, making the transition in days of elapsed time rather than weeks as the suggested timeline indicates in a later section.
The steps outlined are focused on the efficiency of the system as a whole, regardless of where the work itself comes from. It is important to note that achieving the goal of a stable system might not necessarily also result in the achievement of any individual application service-level agreement (SLA) or specific performance objectives for queries. These more granular objectives might require subsequent changes to the workload management configuration, such as outlined in the section on stage 3 scenarios, which is outside the main scope of this document.
This is not a tutorial on DB2 workload management capabilities and does not attempt to provide comprehensive guidance in addressing all possible scenarios where DB2 workload management might be employed. It also does not cover all features within the DB2 product that might be of use in controlling resource consumption. The scope of this article is focused on describing the system stabilization approach in some detail and provides some general guidance for common advanced scenarios.
Get the article now.
Paul Bird is a senior technical staff member (STSM) within the IBM Software Group development organization, sharing his time between the Optim and DB2 development organizations. Since 1991, he has worked on the inside of the DB2 for Linux, UNIX, and Windows product as a lead developer and architect with a focus on diverse areas such as workload management, monitoring, security, and general SQL processing. He recently became a member of the Optim development organization to expand his experiences. You can reach him at email@example.com.
Rimas Kalesnykas is a technical writer for DB2 for Linux, UNIX, and Windows. In the last 5 years, he was the documentation owner for a variety of DB2 subject areas, including the Command and API references, the Partitioning and Clustering Guide, Troubleshooting, and Workload Management. In 2008, he was a co-author of a best practices paper that describes how to improve data server utilization and management through virtualization. You can reach him at firstname.lastname@example.org.
Did you know?
- Best practices papers complement product documentation. and provide practical recommendations to help you implement IBM Information Management solutions
- Best practices are developed and tested by a wide ranging group of experts, including product architects, software developers and testers, information developers, field practitioners, and most importantly, real users.
- Best Practices webcasts allow users to watch presentations from technical experts without having to attend a live conference presentation.
- As new products and features are introduced, new best practices are published
- As more practical knowledge is gathered from real world environments, best practices are updated to reflect up-to-date information
See also my previous posts on Best Practices:
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
Next Thursday (November 10th, 12:30 PM - 2:00 PM Eastern), you can attend a free webinar that will teach you about the performance management and optimization solutions that are available from IBM. You’ll learn about:
- InfoSphere Optim Query Workload Tuner which helps DBAs tune poorly performing query workloads.
- InfoSphere Optim Performance Manager which helps manage application performance by identifying problems across multiple applications, DB2 instances, and the network in between.
Better yet, you’ll be learning from the experts!
- Holly Hayes, Product Manager – InfoSphere Optim Solutions
- Bob Harbus, DB2 Technical Specialist
- Danny Zilio, Software Analyst – Optim Query Tuner group
Don’t miss these experts as they discuss how the performance management solutions delivered by IBM helps you implement a best-practice methodology to identify, diagnose, solve and prevent performance related bottlenecks before they affect your production environment.
Register Now for this webinar on November 10th, 12:30 PM - 2:00 PM Eastern to take charge and manage performance of your data environment before it impacts your business.
This year at the IBM Information on Demand Conference (#IOD11), there is a crammer course for InfoSphere QualityStage 8.5 (Exam 422). If you use this product, you may want to earn an industry-recognized IBM Information Management certification by passing Exam 422. Passing this exam is a great way to validate your skills on the InfoSphere QualityStage 8.5 product. Remember, if you are a registered Information On Demand conference attendee, taking the exam is free. Normally it is $200 per take, so you are saving significantly.
To help you pass this exam, consider taking the Crammer course that is being offered for the first time at this event: (9Q061) InfoSphere QualityStage 8.5 Certification Crammer for Exam 422. This course is being offered the day BEFORE IOD begins: Sunday, October 23. You can register in advance or show up early morning to register at the event.
The instructor for this course is Dale Buckingham. Dale is a learning consultant and technical architect for InfoSphere.
This one day crammer course is designed to introduce you to the concepts a test candidate must know in order to take and pass the InfoSphere QualityStage 8.5 Certification exam 422. The material for this course is aligned with the 422 exam objectives.
To gauge whether you need to take this course or not, consider taking the assessment exam. Normally these exams cost $10, but for conference attendees they are free and will show you how much more you need to know to pass the exam. Beyond this crammer courses, check out the other types of education that are available to learn the material to pass this exam. Of course, you may not have time to take any of this education before going to IOD, so the crammer course may be the best timing and value.
The test contains six sections totaling approximately 62 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.
Section 1 - Methodology (5%)
- Describe the steps in data quality methodology.
- Understand the impact of data integration preparing.
Section 2 - Design Considerations (18%)
- Identify the steps for standardization.
- Given a scenario, demonstrate knowledge how to optimize QualityStage jobs using parallel concepts.
- Given a scenario, describe how to handle data from multiple countries.
- Describe initial vs. delta vs. real-time design considerations. (may use scenarios)
Section 3 - Investigation (10%)
- Given a scenario, demonstrate knowledge of investigation types.
- Given a scenario, describe how word investigation results can be used.
Section 4 - Standardization/Addresses/Postal (11%)
- Describe the differences between address certification, verification, and standardization. (may use scenarios)
- Define what the standardization stage is and how to use it. (may use scenarios)
- Given a scenario, describe the purpose of standardization and what results are produced by the process.
Section 5 - Rule Sets (16%)
- Demonstrate knowledge of how to customize standardization rules. (may use scenarios)
- Demonstrate knowledge of the components of a rule and their functions.
- Demonstrate knowledge of managing standardization rules.
- Demonstrate knowledge of user defined standardization rules.
Section 6 - Matching (21%)
- Given a scenario, demonstrate knowledge of match concepts.
- Describe the match job components. (may use scenarios)
- Given a scenario, describe how to review and tune a match.
- Demonstrate knowledge of managing match specification (re-usability). (may use scenarios)
- Given a scenario, demonstrate knowledge of match job design to achieve optimal performance.
Section 7 - Survive (10%)
- Describe the purpose of survive.
- Demonstrate knowledge of the different rule types for surviving data and when to use them. (may use scenarios)
- Describe how to implement a survive stage.
Section 8 - Setup and Troubleshooting (10%)
- Identify how to troubleshoot a QualityStage job. (may use scenarios)
- Describe how to configure data quality environment functionality.
- Describe QualityStage deployment considerations. (may use scenarios)
- Demonstrate knowledge of NLS/non-NLS install and its impact on QualityStage stages. (may use scenarios)
Good luck on this an any other exam you may choose to take at the IOD conference this year.
I bet you know an IBM Champion or two! I know I do. I’ve blogged about this wonderful group in the past and lovingly call them “IBM’s BEST Friends”. In IBM’s definition, IBM Champions are thought leaders and advocates who share their opinions and years of experience with people like you.
These people are recognized by IBM for their extensive contributions to the community and IBM Champions help make IBM communities a vibrant, meaningful and useful resource. IBM Champions are sought after experts in their field, and as such, have become renowned speakers at IBM and user group events worldwide.
At this year’s Information on Demand Conference (iod11), we will have 59 IBM Champions in attendance & speaking. An impressive 80 of the planned sessions across all the Forums and a variety of tracks is being led by one or more of our IBM Champions. The full list of 80 sessions can be found in this IBM Champions for Business Analytics, Enterprise Content Management and Information Management PDF document.
I’ve been attending conferences for many years now and I’ve become friends with many of these IBM Champions. Take a look at some of the events where a friend of mine is involved:
Roger Sanders: Pre-Conference Certification Class on Sunday Oct 23, 2 book signings: Idea to Print & DB2 9.7 for Linux, UNIX, and Windows Database Administration: Certification Study Notes.
Susan Lawson: Pre-Conference Certification Class on Sunday Oct 23, Up-coming book: DB2 10 for z/OS Database Administration: Certification Study Guide.
Judy Nall: Pre-Conference Certification Class on Sunday Oct 23, Book: DB2 9 System Administration for z/OS: Certification Study Guide: Exam 737.
Panel Discussion Speakers: Brian Green, Blue Cross Blue Shield of Tennessee, Manager, BI and Performance Management; John Boyer, The Nielsen Company, Enablement Team Lead; Kay Van De Vanter, The Boeing: co-authors of the book, "Business Intelligence Strategy", session BDS-1670B: How to Deliver BI Program Excellence, Tuesday, Oct 25, 3-4 pm.
Bernie O'Connor: IDUG Friend; Session IDB-3162A Anixter Uses IBM DB2 pureScale and Optim for Mission Critical Applications; 03:00 PM - 04:00 PM
Klaas Brant; Fellow judge on DB2’s Got Talent Competition & Host for DB2Night Show for DB2 for z/OS: Session IDB-2878A DB2 9.7: How to Create, Maintain and Monitor Huge Tables, Tuesday, Oct 25 04:30 PM - 05:45 PM
Cristian Molaro: Friend from DB2Night Show; Several sessions!
Cuneyt Goksu; Future Author; Session IDZ-1012A Practical Recipes for Daily Database Administration Activities Using IBM DB2 9 and 10 for IBM z/OS Monday, Oct 24 02:15 PM - 03:15 PM
Suresh Sane; IDUG Friend; Session IDZ-1179B DB2 10 Customer Experiences Part 1 What's New for the Developer? Monday, Oct 24 02:15 PM - 03:15 PM
Isaac Yassin; IDUG Friend; Session IDZ-1100A A Closer Look at IBM DB2 (z/OS) Member Cluster Tuesday, Oct 25 08:15 AM - 09:30 AM
Dave Beulke; Co-author of book: DB2 10 for z/OS - Cost Savings ..... Out of the Box; Session IDZ-1731A IBM DB2 Temporal Database Performance Designs Tuesday, Oct 25 10:00 AM - 11:00 AM
Sheryl M. Larsen; Session IDZ-3504A More Lessons Learned from SQL Performance Review Tuesday, Oct 25 10:00 AM - 11:00 AM
Bryan Paulsen; Session IDZ-3138A IBM DB2 10 for z/OS: John Deere's Beta Experience Tuesday, Oct 25 10:00 AM - 11:00 AM
Julian Stuhler; Co-author of book DB2 10 for z/OS - Cost Savings ..... Out of the Box; Session IDZ-1425A The Business Value of IBM DB2 10 Top Features - Real Customer Experiences Tuesday, Oct 25 11:15 AM - 12:15 PM
Daniel L Luksetich; Author of up-coming book: DB2 10 for z/OS Database Administration: Certification Study Guide; Session IDZ-1561A Explaining the IBM DB2 for z/OS Dynamic Statement Cache Tuesday, Oct 25 11:15 AM - 12:15 PM
Craig S Mullins; Author of many books including an up-coming book; Session IDZ-1380A IBM DB2 for z/OS Performance Tuning Roadmap, Tuesday, Oct 25 03:00 PM - 04:00 PM
Phil Grainger; IDUG Friend; Session IDZ-1011A Hash Access: The Hierarchical Direct Access Method (HDAM) IBM DB2 Table? Wednesday, Oct 26 02:00 PM - 03:00 PM
Bonnie Baker; IDUG Friend; Session IDZ-3510A DB2 Doctor: Symptoms, Diagnoses, and Cures for Poor Performance Wednesday, Oct 26 04:30 PM - 05:45 PM
David Birmingham; Author of book: Netezza Transformation: Taming the dragon without alchemy, sorcery or strange potions ; Blogger: “Netezza Underground” ; Several sessions, including Unleashing Netezza - Netezza Solution Best Practices Wednesday, Oct 26 08:15 AM - 09:30 AM.
For complete details of the sessions that all the IBM Champions are involved with, see this IBM Champions for Business Analytics, Enterprise Content Management and Information Management PDF document.
Looking forward to going to the conference to see my friends… and to make more friends.
PS… If you follow my blog, you’ll notice that two of my friends are missing from this list: Rebecca Bond and Scott Hayes. Rebecca won’t be attending for personal reasons and Scott doesn’t have any sessions that he’s running, but I hope he’ll be at the conference. If not, I’ll see him in Prague for IDUG.
A new exam was recently added to the large collection of Information Management Certification Exams. This one leads you to become an IBM Certified Specialist - IBM InfoSphere Optim for Distributed Systems - V7.3.1.
This intermediate level certification is intended for application developers, database administrators, and technical personnel who perform the installation, configuration and day-to-day tasks associated with ensuring the smooth and efficient operation of InfoSphere Optim environment.
- product installation and configuration
- configuration of security
- archive and extract maintenance
- archiving and Optim Connect
- creation and maintenance of test data
- privatizing data
- accessing extended data sources using Optim Connect and InfoSphere Federation Server
- implementing a test data management environment
- performance and tuning
The person performing these functions is generally self-sufficient and is able to perform most of the tasks involved in the role with limited assistance from peers, product documentation and vendor support services.
To earn this certification, you need to take one exam: Test 000-552 - IBM InfoSphere Optim for Distributed Systems - V7.3.1
There are four sections on the exam. See the full set of exam objectives.
Section 1 - Installation and Configuration (25%)
Section 2 - Optim Core Functionality (35%)
Section 3 - Advanced Topics (34%)
Section 4 - Performance and Troubleshooting (6%)
To prepare to pass, here are the recommended courses that you could take:
As always, you can keep up to date with the latest exams and education offering updates from this site: ibm.com/software/data/education/
Another book that is launching at the IBM Information on Demand Conference this year is by Sunil Soares, “Selling Information Governance to the Business: Best Practices by Industry and Job Function”. You may remember Sunil from last year when we launched his very popular Flashbook, “The IBM Data Governance Unified Process: Driving Business Value with IBM Software”. Based on the feedback and enormous success of last year’s book, Sunil was offered a book contract with MC Press for a new book.
The new book, Selling Information Governance to the Business: Best Practices by Industry and Job Function” is so amazing, I’m not sure where to start. First of all, the publisher and the copy editor were completely wowed with both Sunil and the content he created for the book. I haven’t read the book yet, but Sunil has just sent me a draft and from a simple browse I can completely understand why they are so excited.About the book:
One of the major challenges with any information governance program is explaining the value to the business. Most information governance programs deal with certain themes that are common across every enterprise including poor data quality, inconsistent business terms, fragmented data, high storage costs, regulatory compliance, and security and privacy issues. However, these themes present themselves differently across different industries and job functions. For example, poor data quality manifests itself in the form of duplicate customer records in a bank, which affects the ability of the credit risk group to establish the overall exposure to an individual customer across product lines. In retail, poor data quality results in duplicate mailings of multiple catalogs by the marketing department to the same household. I have spoken to hundreds of organizations across multiple industries and geographies about their information governance programs. The conversation quickly proceeds along the following lines: “I get the value of information governance. However, it is very hard for me to convince the business about the value of an information governance program. What best practices do you have to help me do this?” That is why I am writing this book; to help you apply best practices in your organization based on what I have learned, heard, and observed through my industry experience.
This book discusses the best practices to sell the value of information governance, and is divided into four parts:
- Best practices by industry that deal with the application of information governance principles within banking and financial markets, insurance, healthcare, manufacturing, retail, travel and transportation, government, oil and gas, telecommunications, and utilities.
- Best practices by job function that deal with the application of information governance principles within critical job functions such as sales and marketing, finance, information technology operations, information security and privacy, human resources, legal and compliance, operations, supply chain, and product management.
- Cross-industry best practices that deal with horizontal topics such as roles and responsibilities, metrics, metadata, maturity assessments, and business cases. These themes appear consistently within information governance programs across job functions, industries, and geographies.
- Information-centric applications and information governance software tools that cover the applications that benefit from information governance and the actual software tools that facilitate information governance.
The objective of the book is to provide a representative sample, rather than an exhaustive list, of best practices to sell the value of information governance within an organization. You should use these best practices as inspiration for what might work within your organization. It is important that you read chapters from industries and functions outside of your own because there are a number of case studies that you might find useful for your specific situation.
Another unique thing about this book is the number of case studies and forewords. There are more than 50 case studies and 16 forewords. I think what I’ll do is list the names of the people writing the forewords for the book. This might give you an idea of how well connected Sunil is and the depths that are covered in this book:
Partner and Global Leader
Business Analytics and Optimization – Information Management Foundation
IBM Global Business Services
Global Vice President
IBM Software Group
Business Analytics and Optimization
IBM North America
From a banking perspective: David W. Bailey
Director of Enterprise Product Management
From a telecommunications perspective: Komalin Chetty
Head – Data Governance Office
Telkom South Africa
From a financial markets perspective: Paul Ranaldo
Senior Vice President
Master Data Management/Data Governance
Brown Brothers Harriman
From an analyst perspective: Aaron Zornes
Chief Research Officer, The MDM Institute
& Conference Chairman, The “MDM & Data Governance Summit” Global Conferences Series
(London, Mumbai, NYC, San Francisco, Shanghai, Singapore, Sydney, Tokyo, & Toronto)
From a consumer packaged goods perspective: Jay Yusko, Ph.D.
VP Technology Research
From a European banking perspective: Banu Ekiz
Vice President – Business Intelligence
IBM Information Champion
Akbank Information Technologies
From a retail perspective: Michel Boudrias
Director of Enterprise Architecture
SAQ – Société des alcools du Québec
From a manufacturing perspective: Anthony Harris
Enterprise Information Architect
Air Products Gases and Chemicals Inc.
From a distribution perspective: Cengiz Barlas
Vice President & Global Head of Data Management
From an information services perspective: Gustavo Tadao Okida
Chief Enterprise Architect - LATAM
From an analyst perspective: Claudia Imhoff
President of Intelligent Solutions, Inc.
Founder of the Boulder BI Brain Trust
From an analyst perspective: Andy Hayler
The Information Difference
From a retail perspective: Charles Hunsinger
Chief Information Officer
Harry & David
About the Author:
Sunil Soares is the director of information governance within IBM Software Group. Sunil has worked with hundred of clients across multiple industries including banking, insurance, life sciences, retail, telecommunications, media and entertainment, energy and utilities, manufacturing, healthcare, and government. Sunil helps clients establish information governance programs that align IT and the business around common business objectives. Sunil’s first book The IBM Data Governance Unified Process detailed the 14 steps and almost 100 sub-steps to implement an information governance program. The book is already in its second print, and has been translated into Chinese.
I’ve just learned that Sunil is also blogging now! You can find his entries in the Mastering Data Management website. Some of his entries:
Congratulations Sunil for finishing your second book!
At this time there are 82 Web-Based Training (WBT) Courses available for you to take to sharpen your skills on IBM Information Management (IM) products and technologies. Eighty-two is a LOT of courses! More are being created and being updated, so if this is the way you like to learn, make sure you stay in touch with all the latest as they are released.
IBM’s Education is known for its high quality content and excellent instructors. Although with WBT courses you won’t be in a classroom environment, you’ll get the same quality of content that you expect. WBT courses allow you to learn at your own pace and on your schedule with training that is completely self-contained from your desktop. Most courses provide introductory and overview training that serves as the foundation for more technical and follow-on training. Courses include expert instruction but do not include hands-on labs.
How do you get there?
Access this site to see all course offering types: http://www.ibm.com/software/data/education/elearning.html. Under the Web Based section, click on "Browse the complete Information Management WBT portfolio". I’ve included the 82 courses that I know of right now and have put the newest ones at the top of the list. If you’re an IBM employee, contact me offline as there is a different procedure that must be used to take these classes.
Using IBM Optim Designer and Optim Manager - Web Based – New
Connect Information Server to SAP R/3 ECC (DataStage Pack for SAP) – New
DataStage Essentials - Web Based – Updated
IBM InfoSphere Information Server Metadata in Practice – New
InfoSphere BigInsights Essentials (Web) – New
InfoSphere MDM Server Workbench for MDM Server 9 - Web Based – Updated Programming for InfoSphere Streams V2 - Web Based - New
5 Ways to Apply Data Quality with Information Analyzer WBT
A Blueprint for Implementing MDM Server Using V8.5 - Web Based Training
Advanced DataStage - Web-Based
Advanced DB2 SAP for Administrators - Web-Based
Advanced Programming InfoSphere Streams - Web Based
Basic Programming for InfoSphere Streams - Web Based
Business Glossary Essentials - Web Based
Changing Business with Data Insight (Web Based)
Configure ODBC for IBM DataStage on UNIX - Web Based Training
DB2 9 for z/OS Database Administration Workshop Part 1 (Web Based)
DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 9.1 (Web-Based)
DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 V8.2 (Web-Based)
DB2 9.7 for Linux, UNIX, and Windows New Features (Web-Based)
DB2 Everyplace V9 Tutorial – Online
DB2 Express V9 - Developer in a Day Workshop – Online
DB2 Family Fundamentals - Web-Based
DB2 for LUW 9.5 Fundamentals – Online
DB2 for LUW pureXML
DB2 LUW Advanced Topics – Online
Exploring IBM solidDB Universal Cache - Web-Based
Exploring Initiate Workbench V8.x - Web Based
Exploring Initiate Workbench V9.x - Web Based
FastTrack Essentials - Web Based
Federation Server Essentials - Web Based
How to Analyze Data (Using InfoSphere Information Analyzer) - Web Based Training
How to Install IBM DataStage on UNIX - Web Based Training
How to Install IBM QualityStage on UNIX - Web Based Training
How to Install Information Server 8.5 - Basic and Advanced Option
IBM Data Studio Basics - Web Based
IBM InfoSphere Change Data Capture Essentials V6.3 - Web Based
Implementing IBM InfoSphere MDM Server for PIM V9 (Web Based)
Information Analysis - Web Based
Informix 11 New Features (Web Based Training)
Informix Version 10 – Online
InfoSphere Information Server Administration - Web Based
InfoSphere Master Data Management Server Overview (MDM Server) - Web Based Training
InfoSphere MDM Server Architecture – WBT
InfoSphere MDM Server Domains for MDM Server 9 - Web Based
InfoSphere MDM Server User Interface Generator - Web Based
InfoSphere Warehouse 9 - Cubing Services - Web Based Training
InfoSphere Warehouse 9 - Data Mining and Unstructured Text Analysis – WBT
InfoSphere Warehouse 9 - SQL Warehousing Tool and Admin Console – WBT
InfoSphere Warehouse 9 Components - Web Based
Initiate Self-Paced Bundle V8.x - Web Based
Initiate Self-Paced Bundle V9.x - Web Based
Install, Configure, and Use DataStage SOA Edition (RTI) - Web Based Training
Installing and Configuring IBM Optim Data Privacy Solution - Web-Based
Introduction to IBM InfoSphere Information Analyzer - Web Based Training
Introduction to IBM Optim Data Privacy Solution - Web-Based
Introduction to IBM QualityStage - Web Based Training
Introduction to InfoSphere Change Data Capture How to Use CDC WBT
Introduction to InfoSphere DataStage Using Version 8 - Web Based Training
Introduction to InfoSphere QualityStage Using Version 8 - Web Based Training
Introduction to Initiate Master Data Service - Web Based
Introduction to New Features in Informix Version 11 – Online
Introduction to TSA in IBM Smart Analytics Systems - Web Based
Managing Workloads for DB2 LUW and InfoSphere Warehouse - Web Based
Metadata Workbench Essentials - Web Based
Overview of (IISD) InfoSphere Information Services Director - Web Based Training
Overview of IBM DataStage Enterprise Edition for ETL Developers - Web Based Training
Overview of IBM Information Server and DataStage QualityStage Version 8.0 - Web Based Training
Production Automation of IBM DataStage- Web Based Training
Programming for InfoSphere Streams - Web Based
Programming with IBM InfoSphere MDM Server for PIM V9 (Web Based)
QualityStage Advanced Concepts - Web Based
QualityStage V8 Essentials - Web Based
SQL Replication: Advanced Topics (Web Based)
Troubleshooting IBM InfoSphere Information Analyzer - Web Based Training
Using InfoSphere MDM Server for PIM V9 (Web Based)
Using Initiate Inspector V8.x - Web Based
Using Initiate Inspector V9.x - Web Based
Using Queue Replication - Web Based
Using SQL Replication (Web Based)
Validating Data with Rules in Information Analyzer 8.1.1 - Web Based Training
XML and DataStage: Convert Relational and XML Data - Web Based Training
I hope you’ve found one or two in this massive list that interest you! Take the course and let me know what you thought of it.
I got this information from a newsletter that I subscribe to and thought that you may be interested. IBM continues to invest in creating education that is timely, well-designed, and highly-rated, therefore you can continue to expand your skills so that you can perform at your optimal level.
Here are the IBM Information Management courses have recently been updated:
You can view all IM training classes from this link: View all Information Management training
The newsletter I subscribe to is: IBM Training News.
To subscribe to this newsletter and many others, click here: Subscribe. Once on this site, you can choose the product and technology areas that you are interested in seeing in your newsletter and the newsletter is custom-built to your requirements.
Keep your skills as sharp as they can be!
Last year at the IOD Conference, one of the more popular events was handing out printed copies of the IBM Redbooks for Cognos 10. There were a limited number of copies that we had to hand out, and we went through them very quickly. Many other people came and left empty-handed, unfortunately. I pointed out that the book was available for free online at the ibm.com/redbooks site. Clearly there are many people who still prefer to have printed copies!
This year at the IBM Information on Demand 2011 Conference, we’re announcing up front which IBM Redbooks we’ll be handing out, and when. Make sure that if you want one of these books that you come to the Conference Bookstore at the planned times to get your copy. If you miss it, you miss it… but can get the content online!
Get one of the limited copies… and meet the author team behind the book. Maybe you can even find out how you can become an author of an IBM Redbooks.
Monday October 24 from 10:45 – 12:30 p
IBM Production Imaging Edition and Datacap Taskmaster
Metadata Management with IBM InfoSphere Information Server
Tuesday October 25 from 3:00 – 4:00 p
IBM Redbooks DB2 10 for z/OS Performance Topics
Wednesday October 26 from 11:30 – 1:30 p
IBM InfoSphere Streams and the Streams Processing Language
IBM solidDB: Delivering Data with Extreme Speed
The Conference bookstore will be a busy place this year. Here are the other signings and giveaways that are taking place at the event:
Meet Author Sandy Carter at IOD2011 - Get Bold: Using Social Media Meet Netezza Expert & Author David Birmingham at IOD11 Meet Data Warehouse expert & author: Bob Laberge Meet author Tony Giordano, “Data Integration Blueprint and Modeling” Meet FileNet expert and author Bill Carpenter at IOD11 Meet author & decision management expert James Taylor at IBM’s Information on Demand Conference From Idea to Print by Roger Sanders Flashbook: Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data Meet author and DB2 expert Roger Sanders at IOD11 Meet Flashbook author Arvind Sathi - Customer Experience AnalyticsMeet DB2 authors and experts Lawson & Luksetich at IOD: DB2 10 for z/OS DBA Cert Guide
Keep this in mind as you build your schedule for the conference. Note, soon I’ll have session numbers for all of these events where you can add them to your SmartSite schedule.