Don’t let ICIs put your DB2 application in the ICU!

Recording from April 28th, 2016
Duration: 40 minutes in 4 parts

How to discover incompatible changes


Webinar presentation

Craig Mullins

The what and why of ICIs (15 min.)

If you’ve been paying close attention, you will have noticed that over the course of the past couple releases of DB2 for z/OS, IBM has been making changes that can modify the behavior of your DB2 application programs. The number of incompatible changes being introduced by IBM started off slowly in DB2 9 but has grown to a significant number today. So much so that there are ways to trace incompatible changes (using IFCIDs and ICIs, or Incompatible Change Indicators), as well as methods to repress the changes, even if only for a period of time.

Ways to deal with incompatibilities (15 min.)

This session will discuss the incompatible changes, their potential impact on your applications, as well as provide guidance on how to tackle the whole experience. And you’ll also see how SEG’s Workload Expert technology makes it easier to manage and control these incompatible changes. With all of this information at your disposal, you can make sure that your DB2 applications do not wind up in the ICU (intensive care unit)!

Roy Boxwell 

Customer experiences (9 min.)

Now that we all know everything about ICI’s, let us have a look at how the separatly licensable BIF/ICI Use Case of  WorkloadExpert can help you find where the “bad guys” are and how to continuously check that everything is ok. This presentation will show how you can find out ICI Details for static and dynamic SQL, and then we will show real customer results from a “BiF hunt”.

 Questions & answers to Craig Mullins & Roy Boxwell  (4 min.)

1. You talked a lot about built-in functions and how they are changing causing incompatibilities, but can you give us another example?
2.  What best practices would you recommend for dealing with incompatible DB2 changes as we move forward?
3. I know the version twelve is around (DB2 12), Are there new ICIs in it?
4.  Is BIF/ICI Detection free trial, really difficult to install and to start using it?


Craig S. Mullins

is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc. and has been named by IBM as a Gold Consultant and an IBM Champion for Information Management. He was also named one of the Top 200 Thought Leaders in Big Data & Analytics by AnalyticsWeek magazine ( Craig has over three decades of experience in all facets of database systems development and has worked with DB2 since V1. You may know Craig from his popular books:


Roy Boxwell

is a Senior Software Architect for DB2 product development at SEGUS Inc. and SOFTWARE ENGINEERING in Germany. He has been working for more than 30 years in the mainframe world, with 26 of these years strictly focused on the development of DB2 solutions in the realm of installation, migration, performance monitoring, and tuning. He is an active contributor to DB2-Listserv, a regular speaker at IDUGs and RUGs, and writes a monthly newsletter about all things DB2. Currently, he is leading the development team responsible for the WorkloadExpert solution.


The what and why of ICIs

Ways to deal with incompatibilities

Customer experiences with SQL WorkloadExpert

Questions & answers to Craig Mullins & Roy Boxwell