V08 - Don’t Let ICIs Put Your DB2 Applications in the ICU!

Session Number: 3503
Track: DB2 for LUW - I
Session Type: Podium Presentation
Primary Presenter: Craig Mullins [Mullins Consulting, Inc.]
Co-Presenter 1: Roy Boxwell [Software Engineering GmbH]
Time: May 25, 2016 (10:30 AM - 11:30 AM)
Room: San Marcos

Speaker Bio: 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. (346)

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. (342)
Audience experience level: Select a Value
Presentation Category: Select a Value
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Select a Value
Technical areas this presentation will apply to: Select a Value

Abstract:  1- Craig Mullins
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.

2- Roy Boxwell
Hands on product : Now that we all know everything about ICI’s, let us have a look at how the separately 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”.