IDUG 2016 DB2 North American Tech Conference


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

DB2 z/OS Audit – Viable workload tracking

Presenters: Craig Mullins & Ulf Heinrich

Tuesday, May 24th, 2016

Audit and Compliance is a need that many companies want and have to fulfill.

There’s different ways and tools that promise to be able to do it, but what can they really do and what are the associated costs? This presentation introduces DB2 10/11 technology exploitation that delivers any DML, DDL, DCL being executed in a DB2 environment along with identification details. Learn how you can run Audit analytics against a long‐term repository, pinpointing who executed a query, when and from where. Analyze your entire workload to understand access patterns and abnormalities.

Craig Mullins
Audit needs and musts
Take a journey to GLB HIPAA PCI‐DSS Basel III Sarbanes‐Oxley CA SB1386 Federal Information Security Management Act “ed Flag”Rules (FRCA)5.
Solution overview and their Pros/Cons
Get an overview about the existing solutions and understand how they work.
Ulf Heinrich
  The viable way – let DB2 do the magic!
Learn about DB2 enhancements in DB2 10/11 that deliver the DB2 workload being processed and understand why it’s so efficient.
Customer results from the banking industry
Receive some experience from a large banking company and how they successfully replaced their DB2 Audit feature based reporting by a modern SQL tracking and analytics process.

Audience experience Level: Beginner, Intermediate, Advanced

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

Wednesday, May 25th, 2016

Presenters: Craig Mullins & Roy Boxwell

How to discover incompatible changes

Craig Mullins   Don’t Let ICIs Put Your DB2 Applications in the ICU!
The what and why of ICIs
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
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 
  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”.


Speaker’s biography

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:

Ulf Heinrich

Ulf Heinrich is the Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH. He specializes in DB2 recovery issues and database maintenance, focusing on the growing requirement for
cost reduction and 24×7 operations. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the
pitfalls of recovery scenarios under real‐world recovery pressure. His activities cover EMEA, as well as North America through SE’ U.S. subsidiary, SEGUS Inc. He’ involved in the development of
SE’ maintenance andrecovery Solutions.

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. Roy spent eight years developing and coding the ACF2 SAM API as well as working on the RACF and TOP SECRET TOM´s for the SAM® security product.

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 leads the development team responsible for the WorkloadExpert solution.