planetDB2 logo

Planet DB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.


October 21, 2014

DB2 Guys

Roger Sanders: Previewing the DB2 Sessions at IBM Insight 2014

By Roger E. Sanders Senior Consultant, Software Engineer As a DB2 professional, there are two major events I look forward to each year – the International DB2 User’s Group North America conference and the IBM Insight (formerly Information On Demand) conference. And this year, I’m really excited about the IBM Insight 2014 conference. Why? Well, […]

Susan Visser

Certification Exams at IBM Insight

All registered customers and IBM Business Partners are eligible to take IBM Professional Certification tests at a substantially discounted rate of $30.  You can choose from the Business Analytics, Enterprise Content Management and Information Management portfolios. All other IBM Software Certification tests will be available at a rate of $100 per test.

Don't miss this great opportunity to save while validating your skills and demonstrating your proficiency with IBM Software!

For more information on the exams that are available, see Take exams at a reduced price while at IBM Insights.

What exams are new this year?

Why get certified?

I encourage you to read the following for expert opinions on the value of certification:

Study Materials:


New this year is the DB2 10.1 Fundamentals Certification Study Guide by Roger Sanders.  Roger was one of the developers who created the exam questions for Exam 610.  He provides information that makes it very easy for you to learn the content that you need to pass the exam, including a sample test that provides answers with explanations as to why the answer is correct.  Roger’s book will be available for sale at the IBM Insight Conference bookstore.  You can meet Roger in person and ask for study tips.  For more information, see: DB2 10.1 Fundamentals: Certification Study Guide.

A new book for the DBA 10.5 exam is about to publish, but unfortunately, it will not be ready in time for the conference.  You can pre-order the book here:  DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration: Certification Study Guide.  Authors Mohankumar Saraswatipura and Robert Collins have taken up where Roger Sanders left off and have updated this book with Roger’s excellent style and methods. 

Although not specifically a study guide, you’ll do well by learning the content in this book: DB2 Essentials: Understanding DB2 in a Big Data World (3rd Edition) by Raul F. Chong and Clara Liu.


There are free resources that you can use as well.  There is a series of developerWorks tutorials that have already helped many people pass these exams.  Here is a blog post from Norberto who created the first tutorial in the series: DB2 10.1 Certification Exam tutorial - Part 1: Planning

New guide for DB2 certification exam 311

If you are seeking the IBM Certified Database Administrator - DB2 10.5 DBA for LUW Upgrade from DB2 10.1, the new Preparation Guide for DB2 10.5 DBA for Linux, UNIX, and Windows Exam 311 can help you study for the IBM® DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Exam. This guide provides information from the DB2 for Linux, UNIX, and Windows documentation to cover all the exam objectives. This guide is for database administrators and other DB2 database users with intermediate to advanced administration skills who want to prepare for the exam.

New guide for DB2 certification exam 614

If you are seeking the IBM Certified Advanced Database Administrator - DB2 10.1 for Linux UNIX and Windows, the new Preparation Guide for DB2 10.1 DBA for Linux, UNIX, and Windows Exam 614 can help you study for the DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam. This guide provides information from the DB2 for Linux, UNIX, and Windows documentation to cover all the exam objectives. This guide is for database administrators and other DB2 database users with intermediate to advanced administration skills who want to prepare for the exam.


The exam room is located in Surf F, MBCC South, Level 2.  Testing hours can be found at this website: Hours of Certification Testing.


Good luck on your exam!


DB2 Guys

DB2Night Show Recap – An In-Depth Look at DB2 10.5 “Cancun Release”

Fans of the DB2Night show were treated to a great program on Friday as IBM Champions Scott Hayes and Iqbal Goralwalla talked in-depth about DB2 10.5 “Cancun Release”. Iqbal has been testing the release since it was available and shared a wealth of knowledge with the audience, including topics on combining transactional workloads with analytics, […]

DB2 Guys

Must See at IBM Insight 2014 – DB2 HADR with pureScale in SAP Systems

By Ali Mehedi SAP DB2 Integration and Support We’re less than a week away from IBM Insight 2014, and although I’m not going to Vegas, I’m still very excited about some of the session offerings being taught by a few of my colleagues from the IBM and SAP worldwide joint development team. As you probably […]

Ember Crooks

Looking Forward to IBM Insight

IBM’s Insight conference (the conference formerly known as IOD or Information On Demand) is next week in Las Vegas. It’s a large conference that covers more than just DB2, but it is still...


Robert Catterall

DB2 for z/OS Stored Procedures: Native SQL, or Java?

Recently, a mainframe DB2 DBA put a question to me: when should DB2 for z/OS native SQL procedures be used versus Java stored procedures, and vice versa? Why he asked: the DBA worked with a group of developers who, collectively, could code both of these DB2 stored procedure types. Within this group, individuals tended to go with what they were used to. In other words, the decision to code a native SQL or a Java stored procedure tended to be based more on momentum (e.g., "I used a Java stored...

(Read more)

October 20, 2014

Susan Visser

Book Signings and Giveaways at IBM Insights 2014

Here's a handy guide to the book signings and giveways that are planned for the IBM Insights Conference this year:





DB2 10.1 Fundamentals: Certification Study Guide


Meet author Roger Sanders at the bookstore


Monday, October 27 from 9:45 – 10:45 am.


DB2 11: Ultimate Database for Cloud, Analytics & Mobile!


Limited number of free copies available!


Meet authors John Campbell, Gareth Jones, Surekha Parekh, Chris Crone, and Jay Yothers at the bookstore


Monday, October 27 from 1:00 – 2:00 pm.


Hadoop for Dummies


Meet authors Paul Zikopoulos and Dirk deRoos at the bookstore


Monday, October 27 from 4:30 -5:00 pm.





“Big Data Beyond the Hype” A Guide to Conversations for Today’s Data Center




Limited number of free copies available!

Meet authors Paul Zikopouls, Dirk deRoos, Chris Bienko, Rick Buglio, and Marc Andrews at the bookstore


Tuesday, October 28 from 9:30 – 10:30 am.


The Power of Now 

Real-Time Analytics and IBM InfoSphere Streams



Limited number of free copies available!

Meet author Jacques Roy at the bookstore


Tuesday, October 28 from 9:30 – 10:30 am.


Reliability and Performance with IBM DB2 Analytics Accelerator V4.1


Limited number of free copies available!

Meet authors at the bookstore



Tuesday, October 28 from  10:30-11:30 am.


Building IBM Enterprise Content Management Solutions From End to End


Limited number of free copies available!

Meet authors at the bookstore



Tuesday, October 28 from 11:-30 am -12:30 pm.



Analytics Across the Enterprise: How IBM Realizes Business Value from Big Data and Analytics


Meet authors Brenda Dietrich, Emily Plachy, and Maureen Norton at the bookstore


Tuesday, October 27 from 12:30 -1:30 pm.




Wednesday, October 28 from 12:30 – 1:30 pm.


The Visual Organization: Data Visualization, Big Data, and the Quest for Better Decisions


Meet author / thought leader Phil Simon at the bookstore


Tuesday, October 27 from 12:30 -1:30 pm.



Too Big to Ignore: The Business Case for Big Data


Meet author / thought leader Phil Simon at the bookstore


Tuesday, October 27 from 12:30 -1:30 pm.



IBM Cognos Insight


Meet author Sanjeev Datta at the Solutions EXPO Booth 802


Tuesday, October 27

from 12:30 – 3:30pm.


Beyond Big Data: Using Social MDM to Drive Deep Customer Insight



Limited number of free copies available!


Meet authors Martin Oberhofer, Eberhard Hechler, Ivan Milman, Scott Schumacher, and Dan Wolfson at the bookstore


Tuesday, October 28 from 2:45 – 3:45 pm.


Patterns of Information Management


Meet authors Mandy Chessell and Harald Smith at the bookstore


Tuesday, October 28 from 2:45 – 3:45 pm.


Engaging Customers Using Big Data: How Marketing Analytics is Transforming Business



Limited number of free copies available!


Meet author Arvind Sathi in the Solution EXPO in Booth 525


Tuesday October 28 from 2:30pm – 3:30pm


Or at the bookstore


Tuesday, October 28 from 4:00 – 5:00 pm.







A Captain’s Duty: Somali Pirates, Navy SEALs, and Dangerous Days at Sea


Meet author Captain Richard Phillips at the bookstore


Wednesday, October 29 from 9:45 – 10:45 am.



IBM Redbook: Architecting and Deploying DB2 with BLU Acceleration



Limited number of free copies available!

Meet authors Martin Schlegel, Jean Cristie Pacanaro, Alexander Zietlow, Marco Bonezzi and Polly Lau at the bookstore


Wednesday, October 29 from 3:00 – 4:00 pm.



The conference bookstore is located in the Mandalay Bay in the Bayside Foyer.  The hours are:

Sunday, October 26


12:00pm – 8:00pm

Monday, October 27


10:00am – 7:00pm

Tuesday, October 28


7:30am – 7:00pm

Wednesday, October 29


7:30am – 5:00pm

Thursday, October 30


7:30am – 2:00pm


DB2 Guys

Several Reasons for DB2 pureScale Users To Be Excited About IBM Insight

By Kelly Schlamb Executive IT Specialist, WW Information Management Technical Sales DB2 pureScale & PureData System for Transactions Specialist, Competitive Insight   When I tell my friends I’ll be going to Vegas for IBM Insight, there’s a bit of eye rolling along with a sarcastic “yeah, sounds like hard work… say hi to the blackjack […]

October 17, 2014

DB2Night Replays

The DB2Night Show #141: DB2 LUW V10.5 CANCUN Shadow Table Experiences

@iqbalgoralwalla Special Guest: Iqbal Goralwalla, Triton Consulting DB2 V10.5 FP4 "Cancun" Shadow Tables and pureScale "Lite" Early Hands-on Experiences 100% of our audience learned something! During today's show, Iqbal gave us an excellent presentation on his early user experiences with IBM BLU CANCUN (aka Shadow Tables and pureScale "Lite". You will see performance results and many excellent recommendations on DB2...

(Read more)

DB2 Guys

Mastering the DB2 10.1 Certification Exam – Part 1: Planning

Norberto Gasparotto Filho is a database specialist with more than 10 years of experience with database administration and is the author of the DB2 10.1 fundamentals certification exam 610 prep, Part 1: Planning. He was the winner of the first edition of “DB2’s Got Talent” contest in 2011. He also worked as programmer using a […]

Craig Mullins

Performance Tools That Operate on Databases and Database Objects

In our last blog post here, we covered DB2 system performance management tools - that is, tools that look at the performance at a  system or subsystem level. Today, we turn our attention to the database objects... Most DBMSs do not provide an intelligent database analysis capability. Instead, the DBA or performance analyst must use system catalog views and queries, or a system catalog tool,...

(Read more)

Susan Visser

Phil Simon at IBM Insights

The latest addition to our authors doing a book signing at IBM Insights this year is Phil Simon. He is author of many books, but I’ll focus on his two latest ones for this blog entry.


The Visual Organization: Data Visualization, Big Data, and the Quest for Better Decisions

In The Visual Organization, Phil Simon looks at how an increasingly number of organizations are embracing new dataviz tools and, more important, a new mind-set based upon data discovery and exploration. Simon adroitly shows how Amazon, Apple, Facebook, Google, Twitter, and other tech heavyweights use powerful data visualization tools to garner fascinating insights into their businesses. But make no mistake: these companies are hardly alone. Organizations of all types, industries, sizes are representing their data in new and amazing ways. As a result, they are asking better questions and making better business decisions. Rife with real-world examples and case studies, The Visual Organization is a full-color tour-de-force.

Too Big to Ignore: The Business Case for Big Data

Too Big to Ignore: The Business Case for Big Data is geared towards CIOs, CEOs, presidents, and IT professionals. At a high level, the book makes a compelling business case for that which we are calling Big Data. Simon provides commonsense advice for organizations looking to make sense out of the information streaming at us with unprecedented volume, velocity, and variety.


I haven’t read these books yet, but plan to pick them up at the conference.  Both books are highly rated on amazon, so they are assured to be good books.


At IBM Insights:

Phil will be signing copies of his books at the Conference Bookstore on Tuesday, October 28 from 12:30 – 1:30. 

About Phil:

Phil Simon (@philsimon) is a sought-after speaker and the award-winning author of six management books, most recently The Visual Organization: Data Visualization, Big Data, and the Quest for Better Decisions. A recognized technology expert, he advises organizations on matters related to strategy, data, and technology. His contributions have been featured on Harvard Business Review, CNN, Wired, NBC, CNBC, Inc, BusinessWeek, Huffington Post, Fast Company, The New York Times, and many other sites.

To find out more about Phil and his books, go to



Susan Visser

IBM Cognos Insight

I met Sanjeev last year at the IOD Conference.  We had tried to set up a booksigning, but the information came in late and there were issues.  So, we’re promoting this book this year. 

IBM Cognos Insight

By Sanjeev Datta

At IBM Insight:

Buy your copy of the book at the conference bookstore and have it signed by Sanjeev in his booth.  Sanjeev will be available for signing copies on Tuesday October 28 from 12:30pm – 3:30pm in the Solution EXPO - Booth 802.

About the book:

Based on in-memory technology with write-back capabilities for What-if scenario planning, Cognos Insight gives spreadsheets the rich visual appeal for better analysis and planning. Leverage the collaborative features to seamlessly publish the personal analysis workspaces to an enterprise-wide Cognos Business Intelligence solution.

"IBM Cognos Insight" is a fast paced, practical hands-on guide with step-by-step instructions to build Cognos Insight workspaces. Take advantage of the in-memory TM1 cubes as the underlying engine to answer business questions by analyzing data in the form of reports & dashboards. Share these insights with other Cognos services or mobile devices to empower users with real-time data.

This book introduces Cognos Insight as a personal yet powerful analytics application. It covers how decision making is applied in all domains of the business world and how data can be analyzed effectively in the form of fast in-memory cubes. Leverage the write-back functionality to build budgets, plans and forecasts.

"IBM Cognos Insight" will empower new and existing users to maximize the features of the application and analyze data by building visually rich reports and dashboards in minutes.


This book takes a practical tutorial approach to teaching users the features of Cognos Insight.

Who this book is for

New and existing users of Cognos Insight who are looking to gain more knowledge about the product and Business Analytics in general.

About the Author

Sanjeev Datta is a seasoned Consultant, passionate text and video blogger, and Business Analytics enthusiast. As Practice Director at PerformanceG2, Inc., he works extensively with executives and decision-makers across finance, manufacturing, retail, and pharmaceuticals as a trusted advisor in corporate performance management, building client relationships and managing Business Analytics implementations.

Sanjeev's work as a strong Project Manager, Pre-sales and Post-sales Consultant, trainer, and mentor has led to many successful implementations. While at Merador, LLC, Sanjeev worked as a Consultant/Architect building solutions for global organizations.

Previous to that, Sanjeev was a Cognos Developer/Consultant while at Softpath Systems, LLC and lead successful Cognos BI solutions and developed Cognos BI training material for numerous clients.

He is certified in numerous IBM products and is an IBM Technical Specialist and IBM Sales Mastery Professional.

Sanjeev has a degree in Computer Science from Mumbai University and a degree in Interdisciplinary Studies from The University of Texas.

Connect with Sanjeev on LinkedIn or Twitter: @1dsanjeev


Susan Visser

Hadoop for Dummies

This book was published earlier this year, so I was given a few free copies and had them at the IDUG conference in Phoenix.  I didn’t think people at the conference would be interested in this book, so I had put them aside.  But, when people started noticing the book, they wanted to know how they could get a copy.  On the spur of the moment, I decided that if people tweet the message “I want a copy of the Hadoop book from Susan”, I’d give it to them.  To my huge surprise, I gave out more than 20 copies of this book in this way.  Of course a data centric audience is interested in a book that teaches them how to modernize their data environment!

Hadoop for Dummies

by Dirk deRoos and Paul Zikopoulos

At IBM Insights:

The book signing is scheduled for Monday October 27 from 4:30pm - 5:00pm at the Conference Bookstore.  I’m pretty sure Dirk will be there… and I made sure it was on Paul’s calendar, but I’m sure Paul will be in huge demand the entire week, so it is possible that Paul will not be able to make it at this time.

About the book:

Big data has become big business, and companies and organizations of all sizes are struggling to find ways to retrieve valuable information from their massive data sets with becoming overwhelmed. Enter Hadoop and this easy-to-understand For Dummies guide. Hadoop For Dummies helps readers understand the value of big data, make a business case for using Hadoop, navigate the Hadoop ecosystem, and build and manage Hadoop applications and clusters.

  • Explains the origins of Hadoop, its economic benefits, and its functionality and practical applications
  • Helps you find your way around the Hadoop ecosystem, program MapReduce, utilize design patterns, and get your Hadoop cluster up and running quickly and easily
  • Details how to use Hadoop applications for data mining, web analytics and personalization, large-scale text processing, data science, and problem-solving
  • Shows you how to improve the value of your Hadoop cluster, maximize your investment in Hadoop, and avoid common pitfalls when building your Hadoop cluster

From programmers challenged with building and maintaining affordable, scaleable data systems to administrators who must deal with huge volumes of information effectively and efficiently, this how-to has something to help you with Hadoop.

Learn to:

  • Understand the value of big data and how Hadoop can help manage it
  • Navigate the Hadoop 2 ecosystem and create clusters
  • Use applications for data mining, problem-solving, analytics, and more

The easy-to-use, practical guide to using Hadoop for big data

With most of the world’s data created in only the past two years, Hadoop has emerged as the definitive computing paradigm to handle big data. This comprehensive guide from IBM big data experts provides a hands-on resource for those who want to dig into the details of HDFS and MapReduce to take data storage and processing to the next level.

  • Get started with Hadoop — discover the origins of Hadoop, the realities of worldwide data growth, and practical use cases for this revolutionary platform
  • Under the Hadoop hood — dig into Hadoop’s distributed framework, including HDFS and MapReduce and the best tools for working with data in Hadoop
  • Hadoop and structured data — modernize data warehouses with Hadoop and discover data utilities like HBase, Hive, and Sqoop
  • Hands on with Hadoop — get your hands dirty with details on configuring Hadoop clusters and an overview of day-to-day Hadoop administration
  • Take your Hadoop knowledge to the next level — use additional Hadoop resources to understand the technology at a deeper level

Open the book and find:

  • Coverage of the Hadoop 2 ecosystem and Yarn
  • Real-world use cases to help you get started
  • Details on Hadoop distributions and cluster setup
  • How to use Oozie for scheduling workflows
  • How to add structure with Hive and HBase
  • Details on running native SQL queries on Hive
  • On-premise and cloud deployment options for Hadoop
  • The challenges faced by administrators

About the Authors:

Dirk deRoos is the technical sales lead for IBM’s InfoSphere BigInsights. Paul C. Zikopoulos is the vice president of big data in the IBM Information Management division. Roman B. Melnyk, PhD is a senior member of the DB2 Information Development team. Bruce Brown and Rafael Coss work with big data with IBM.




October 16, 2014

Susan Visser

Analytics Across the Enterprise: How IBM Realizes Business Value from Big Data and Analytics

Another great book to look forward to is:

Analytics Across the Enterprise: How IBM Realizes Business Value from Big Data and Analytics

By Brenda L. Dietrich, Emily C. Plachy, Maureen F. Norton

I briefly had a copy of the book and read the first chapter.  I enjoyed it, but didn’t have a chance to finish it. 

About the book:

Analytics is not just a technology: It is a better way to do business. Using analytics, you can systematically inform human judgment with data-driven insight. This doesn’t just improve decision-making: It also enables greater innovation and creativity in support of strategy. Your transformation won’t happen overnight; however, it is absolutely achievable, and the rewards are immense.

This book demystifies your analytics journey by showing you how IBM has successfully leveraged analytics across the enterprise, worldwide. Three of IBM’s pioneering analytics practitioners share invaluable real-world perspectives on what does and doesn’t work and how you can start or accelerate your own transformation. This book provides an essential framework for becoming a smarter enterprise and shows through 31 case studies how IBM has derived value from analytics throughout its business.

Coverage includes:

  • Creating a smarter workforce through big data and analytics
  • More effectively optimizing supply chain processes
  • Systematically improving financial forecasting
  • Managing financial risk, increasing operational efficiency, and creating business value
  • Reaching more B2B or B2C customers and deepening their engagement
  • Optimizing manufacturing and product management processes
  • Deploying your sales organization to increase revenue and effectiveness
  • Achieving new levels of excellence in services delivery and reducing risk
  • Transforming IT to enable wider use of analytics
  •  “Measuring the immeasurable” and filling gaps in imperfect data

Whatever your industry or role, whether a current or future leader, analytics can make you smarter and more competitive. Analytics Across the Enterprise shows how IBM did it--and how you can, too.


At IBM Insight:

The authors will be signing copies of their book at the Conference Bookstore on Tuesday, October 28 from 12:30pm – 1:30pm AND Wednesday, October 29 from 12:30pm – 1:30pm.  The books will be available at the bookstore for you to purchase at a discount.

The authors have amazing credentials and I’m looking forward to meeting them. 

About the Authors:

Dr. Brenda L. Dietrich is an IBM Fellow and Vice President. She joined IBM in 1984 and has worked in the area now called analytics for her entire career. Her early work involved applying mathematical models to improve the performance of IBM manufacturing lines. During her career, she has worked with almost every IBM business unit and applied analytics to numerous IBM decision processes. For more than a decade, she led the Mathematical Sciences function in the IBM Research division, where she was responsible for both basic research on computational mathematics and for the development of novel applications of mathematics for both IBM and its clients. In addition to her work within IBM, she has been the president of INFORMS, the world’s largest professional society for operations research and management sciences, she is an INFORMS Fellow, and she has received multiple service awards from INFORMS. She has served on the board of trustees of SIAM and on several university advisory boards. She is a member of the National Academy of Engineering. She holds more than a dozen patents, has co-authored numerous publications, and frequently speaks on analytics at conferences. She holds a BS in mathematics from UNC and an MS and PhD in operations research/information engineering from Cornell. Her personal research includes manufacturing scheduling, services resource management, transportation logistics, integer programming, and combinatorial duality. She currently leads the emerging technologies team in the IBM Watson group.

Dr. Emily C. Plachy is a Distinguished Engineer in Business Analytics Transformation, responsible for leading an increased use of analytics across IBM. She has integrated data analysis into her work throughout her career. Since joining IBM in 1982, she has held a number of technical leadership roles including CTO, Process, Methods, and Tools in IBM Global Business Services (GBS), providing architecture and technology leadership and driving the adoption of consistent methods and tools in GBS, and CTO, Enterprise Integration, GBS, providing architecture and technology leadership. She has also held a variety of roles in IBM, including development, ad tech, research, emerging business opportunities, technical sales, and services. Her technology skills include data integration, enterprise integration, solution architecture, software development, and asset reuse. She has experience in multiple industries, including banking, consumer products, retail, telecommunications, healthcare, and petroleum. She has a BS degree in applied mathematics from Washington University, an MSc degree in computer science from the University of Waterloo, and a DSc degree in computer science from Washington University. In 1992, Emily was elected to the IBM Academy of Technology, a body of approximately 1,000 of IBM’s top technical leaders, and she served as its President from 2009 to 2011. She has been a long-term champion of women in technology. She is a member of Women in Technology International, the Society of Women Engineers, and INFORMS. Emily lives in New York with her husband, Tony. She is on Twitter @eplachy and on LinkedIn at

Maureen Fitzgerald Norton, MBA, JD, is a Distinguished Market Intelligence Professional and Executive Program Manager in Business Analytics Transformation, responsible for driving the widespread use of analytics across IBM. She pioneered the development of an outcome-focused communications strategy to drive the culture change needed for analytics adoption. Maureen created analytics case studies and innovative learning exercises for teaching analytics. She co-created an innovative analytics workshop and taught MBA students in Europe and the Middle East. In her previous role, Maureen led project teams applying analytics to IBM Smarter Planet initiatives in public safety, global social services, commerce, and merchandising, specializing in cost/benefit analysis and return on investment of analytic projects. Maureen became the first woman in IBM to earn the designation of Distinguished Market Intelligence Professional for developing innovative approaches to solving business issues and knowledge gaps through analysis. She has held a number of analytic and management roles in IBM. She earned BA and MBA degrees from the University of New Haven and a JD degree from the University of Connecticut School of Law. She is a licensed attorney and did her thesis on the legal implications of artificial intelligence. She lives in Connecticut with her husband, Dr. William Norton, and three children, Erin, Colleen, and William. She is a dual citizen of the United States and Ireland. In addition to Analytics Across the Enterprise, Maureen has published “The Benefits of Social Media Analytics 2013” with the IBM Academy of Technology and “Social Media Analytics: Measuring Value Across Enterprises and Industries” in the Journal of Management Systems. Maureen is on Twitter @mfnorton and on LinkedIn at



DB2 Guys

Webinar: Why IBM DB2 Database Software Leaves the Competition in the Dust

We all know that IBM DB2 database software is an industry leader when it comes to performance, scale, and reliability. But how does it compare to the competition, specifically Oracle and SAPHANA? IBM’s Chris Eaton joined IDUG’s DB2 Tech Talk to give an update on IBM DB2 and show how DB2 goes above and beyond […]

Dave Beulke

Four Ways to Drive Analytics into your Data Management

Data from personal health monitors, airplane/car mechanical sensors, location movement instrumentation, image processes, and voice prints audio analysis are exploding databases in all aspects of business. Examining your current environments and systems shows there are many ways to enhance your...

(Read more)

Triton Consulting

The Top Five Reasons for Choosing Remote Database Support – Proactive Vs Reactive

#3 Proactive Vs Reactive Expert DBA skills are often needed on different projects and so DBAs can find themselves spending more time on non-core functions. This means that the vital monitoring and management of the database can be sidelined.  Overworked … Continue reading →

(Read more)

October 15, 2014

Susan Visser

Engaging Customers Using Big Data: How Marketing Analytics is Transforming Business

This is the third book we’ve showcased at an IBM conference authored by Dr. Arvind Sathi!

Engaging Customers Using Big Data: How Marketing Analytics is Transforming Business

At IBM Insights:

If you are at IBM Insights later this month, you can pick up a free copy of this book and have it signed by Arvind on Tuesday October 28 from 2:30pm – 3:30pm in the Solution EXPO in Booth 525.  Arvind will also be at the Conference Bookstore on Tuesday October 28 from 4:00pm – 5:00pm.  These books are in limited supply, so be sure to schedule this event so you don’t miss it.

About the book:

Big Data is rapidly transforming a number of business functions across many industries. The biggest transformation is in how we market to our customers. This book shows marketers today how to seek small samples from their customers to observe their behavior, predict changes, and act using a series of unconnected business actions. Big Data has changed the game completely—we can connect with customers, record every click on the web, watch every step in the store, and listen to all public conversations. Unlike today's environment, where marketers broadcast across a set of customer segments, we can now personalize our communications to each customer based on their current predisposition to the products being sold.

The book makes three major propositions:

  1. Big Data brings all the data to the table leading to a lot more detailed analysis and discovery. We can get a lot more understanding about consumer behavior.
  2. Automation and Social Media drives a lot more influence on the decisions. We can converse with the customers as they make decisions and influence their decision-making using a series of sophisticated marketing tools.
  3. The market leaders will integrate their resources and investment to optimize across a number of instruments in ways we have never seen before.

These changes have tremendous impact on our marketing processes and capabilities. In the first half of the book, using a series of examples from big data pioneers, such as PF Chang's, Best Buy, Google, and IBM, Sathi describes how each marketing function is undergoing fundamental changes: how personalized advertising is delivered using online channels where the marketers identify the specific customer and tailor their messaging based on customer behavior, context, and intention; how customer behaviors are collected from a variety of sources across many industries and examined to identify micro segments; and how online and physical stores collaborate to provide a unified shopping experience and deliver product information. The second half of the book examines the tools and techniques for marketing science in support of these capabilities including statistical techniques, qualitative reasoning, and real-time pattern detection, to name a few. Based on these changes, the book prescribes the changes needed to update our skill and tools for Marketing Analytics.

You may have read one of Arvind’s previous books, including:


Big Data Analytics

This book discusses three perspectives on Big Data Analytics.  First, why is Big Data Analytics becoming so important and what can we do with it.  Second, it lists major components of Big Data Analytics - Unstructured Data Analytics, Massively Parallel Processing, Adaptive Real-time and Predictive Modeling, Data Privacy Management, Data Visualization, and Ontologies. Third, it provides a glimpse at implementation concerns and how they must be tackled.

e-Version: register here to download your copy.


Customer Experience Analytics: Fast, Intelligent and Action-Packed

Book information on blog

Electronic Version (6.98 MB)


About Arvind:

Dr. Arvind Sathi is the World Wide Communication Sector Architect for Big Data at IBM®. Dr. Sathi received his Ph.D. in Business Administration from Carnegie Mellon University and worked under Nobel Prize winner Dr. Herbert A. Simon. Dr. Sathi is a seasoned professional with more than 20 years of leadership in Information Management architecture and delivery. His primary focus has been in creating visions and roadmaps for Advanced Analytics at leading IBM clients in Telecommunications, Media & Entertainment, and Energy & Utilities organizations, worldwide. He has conducted a number of workshops on Big Data assessment and roadmap development.



Susan Visser

Patterns of Information Management

This book published last year, but is deserving of much more attention!

Patterns of Information Management

By Mandy Chessell, Harald Smith

Use Best Practice Patterns to Understand and Architect Manageable, Efficient Information Supply Chains That Help You Leverage All Your Data and Knowledge

In the era of “Big Data,” information pervades every aspect of the organization. Therefore, architecting and managing it is a multi-disciplinary task. Now, two pioneering IBM architects present proven architecture patterns that fully reflect this reality. Using their pattern language, you can accurately characterize the information issues associated with your own systems, and design solutions that succeed over both the short- and long-term.

Building on the analogy of a supply chain, Mandy Chessell and Harald C. Smith explain how information can be transformed, enriched, reconciled, redistributed, and utilized in even the most complex environments. Through a realistic, end-to-end case study, they help you blend overlapping information management, SOA, and BPM technologies that are often viewed as competitive.

Using this book’s patterns, you can integrate all levels of your architecture–from holistic, enterprise, system-level views down to low-level design elements. You can fully address key non-functional requirements such as the amount, quality, and pace of incoming data. Above all, you can create an IT landscape that is coherent, interconnected, efficient, effective, and manageable.


At IBM Insights:

If you are attending the IBM Insights conference, you can meet Mandy and Harald and have them sign your book for you.  They will be available on Tuesday October 28 from 2:45 to 3:45 pm at the conference bookstore.


Coverage Includes:

  • Understanding how a pattern language can help you address key information management challenges
  • Defining information strategy and governance for organizations and users
  • Creating orderly information flows you can reuse and synchronize as needed
  • Managing information structure, meaning, and lifecycles
  • Providing for efficient information access and storage when deploying new IT capabilities
  • Moving information efficiently and reliably to support your processes
  • Determining how information should be processed and maintained
  • Improving quality and accessibility, and supporting higher-value analytics
  • Protecting information via validation, transformation, enrichment, correction, security, and monitoring
  • Planning new information management projects in the context of your existing IT resources

 Watch a video of Mandy discussing the value of her book.

 About the authors:

 Mandy Chessell


 Mandy has worked for IBM since 1987. She is an IBM Distinguished Engineer, IBM Master Inventor, and member of the IBM Academy of Technology Leadership Team. As the chief architect for InfoSphere® Solutions in IBM’s Software Group, Mandy designs common information integration patterns for different industries and solutions.

In earlier roles, Mandy’s work has focused on transaction processing, event management, business process management, information management, and model-driven development. This breadth is reflected in her invention portfolio, which to date stands at over 50 issued patents worldwide.

Outside of IBM, Mandy is a fellow of the Royal Academy of Engineering and a visiting professor at the University of Sheffield, UK. In 2001, she was the first woman to be awarded a Silver Medal by the Royal Academy of Engineering, and in 2000, she was one of the “TR100” young innovators identified by MIT’s Technology Review magazine. In 2006, she won a British Female Innovators and Inventors Network (BFIIN) “Building Capability” award for her work developing innovative people and the BlackBerry “2006 Best Woman in Technology - Corporate Sector” award. More recently, she was granted an honorary fellowship of the Institution for Engineering Designers (IED) and she won the “2012 everywoman Innovator of the Year.” For more information on Mandy’s publications, see


Harald Smith

Harald has worked for IBM since 2005. Harald is a software architect in IBM’s Software Group specializing in information quality, integration, and governance products, and is IBM certified in delivering IBM Information Management solutions. In this role, he develops best practices, methodology, and accelerators for common information integration use cases.

Harald has 30 years of experience working with data quality products and solutions; product and project management; application development and delivery; system auditing; technical services; and business processes across the software, financial services, healthcare, and education sectors. Harald was the product manager at Ascential® Software and IBM responsible for designing and bringing the IBM InfoSphere Information Analyzer product to market as a key component in IBM’s information quality portfolio. He has been issued three patents in the field of information quality and rule discovery and was recently recognized as an IBM developer- Works Contributing Author.

His publications include the IBM developerWorks articles “The information perspective of SOA design” [parts 6, 7, and 8], “Use IBM WebSphere® AuditStage in a federated database environment,” “Using pre-built rule definitions with IBM InfoSphere Information Analyzer,” “Designing an integration landscape with IBM InfoSphere Foundation Tools and Information Server” [part 1], and “Best practices for IBM InfoSphere Blueprint Director” [parts 1 and 2]. For the IBM InfoSphere Information Server documentation, Harald contributed to the “IBM InfoSphere Information Analyzer Methodology and Best Practices Guide” and “IBM InfoSphere Information Server Integration Scenario Guide”; he has also contributed to three IBM Redbooks®.




October 14, 2014


DB2utor Has Moved, Please Update Your Bookmarks

DB2utor has moved to Please update your bookmark. It’s the same great content but in a new location.

Susan Visser

DB2 Fundamentals Certification Guide

The long awaited latest book from Roger Sanders has now been published! 

DB2 10.1 Fundamentals:  Certification Study Guide

If you are attending the IBM Insights Conference, you can purchase this book and have Roger sign your copy.  He will be available for signing on Monday, October 27 from 9:45 – 10:45 am. 

I’m sure many of the people reading this blog have met Roger in person.  He attends or teaches at many conferences and is very friendly.    One sad thing to say is that this may be Roger’s last book.  We’ll miss him very much but are thankful for all the great content he has provided to the DB2 community over the years.

About this latest book:

In DB2 10.1 Fundamentals: Certification Study Guide, Roger E. Sanders--one of the world's leading DB2 authors and an active participant in the development of 21 DB2 certification exams--covers everything you need to know to take and pass IBM's DB2 10.1 Fundamentals certification exam (Exam 610).

This comprehensive study guide takes you through each of the topics covered on the exam: planning; security; working with databases and database objects; working with data using SQL and XQuery; working with DB2 tables, views, and indexes; and data concurrency--just to name a few.

For some time, technical certification has been an important trend in the IT industry. Possessing certification credentials is an excellent way to show you have a solid understanding of a technology or software product. Consequently, taking and passing the DB2 10.1 Fundamentals exam provides validation that you have mastered the basics of DB2 Version 10.1. It also earns you IBM Certified Database Associate certification.

In addition to easy-to-understand explanations of every topic on the test, this book contains 150 practice questions that closely model the actual 610 exam--along with an answer key that explains why each chosen answer is correct (and why the other answers are wrong).

No other resource gives you this much help in preparing for the DB2 10.1 Fundamentals exam!

Whatever DB2 10.1 certification path you plan to pursue, taking--and, more importantly, passing--the DB2 10.1 Fundamentals exam is the first step. And this book is the best place to find the information you need to know to get started.

Upon completion of this book, you will be able to:

  • Meet the objectives outlined for the DB2 10.1 Fundamentals certification exam
  • Describe new features and functionality introduced with DB2 10.1
  • Assess your ability to pass the DB2 10.1 Fundamentals certification exam
  • Navigate and use the DB2 10.1 Fundamentals exam testing software
  • Obtain IBM Certified Database Associate for DB2 10.1 certification

Beginning with an explanation of the certification process and working through fundamental exam objectives, this guide gives test-takers all they need to know to pass IBM's DB2 10.1 Fundamentals certification exam (Exam 610). All the subjects covered on the exam are included: planning, security, data concurrency, working with databases and database objects, working with data using SQL and XQuery, working with DB2 tables, views, and indexes—and more. The book concludes with an extensive set of 150 practice questions that mirror the questions found on the exam and detailed answers that explain why the chosen answer is correct and why the others are wrong. Written by a DB2 authority who has helped IBM develop 21 DB2 certification exams, this is the ultimate resource for those who plan to earn their IBM Certified Database Associate certification.

About Roger:

Roger E. Sanders is the President of Roger Sanders Enterprises, Inc. and a Principal Solutions Architect (Director) with EMC Corporation. He has been working with DB2 for Linux, UNIX, and Windows since it was first introduced on the IBM PC (as part of OS/2 1.3 Extended Edition) and is the author of twenty-two books on relational database technology (twenty-one books are on DB2 and one book is on ODBC). For the past nine years, Roger has authored the Distributed DBA column in IBM Data Management Magazine (formerly DB2 Magazine) and, over a fourteen year period, he has written numerous tutorials and articles for IBM's developerWorks website as well as for publications like Certification Magazine and IDUG Solutions Journal (the official magazine of the International DB2 User's Group). In 2008, 2009, 2010, 2011 and 2012, Roger was recognized as an IBM Champion for his contributions to the IBM Data Management community; in 2010 he was recognized as an IBM developerWorks Contributing Author, in 2011 he was recognized as an IBM developerWorks Professional Author, and in 2012 he was recognized as an IBM developerWorks Master Author, Level 2 (for h contributions to IBM's developerWorks web site). He lives in Fuquay-Varina, North Carolina (population 39,042).

Other content you’ll want to read or bookmark:


Exam 610 is a pre-requisite for many certifications, including:



Ember Crooks

Querying Tables for an Activity Event Monitor

I’ve been working with a developer to profile some SQL from a process he’s running. He has no insight into the SQL that the tool is using, primarily to insert data. I thought I’d...


ChannelDB2 Videos

DB2 Tips n Tricks Part 46 - How to Find Fenced User ID for an Instance


How to Find Fenced User ID for an Instance Solution: User ID running the db2fmp Process is Fenced User ps -eaf|grep -i -e db2fmp -e db2sysc cat DB2HOME/sqlli...

Subscribe by email



planetDB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.