Midwest Database User Group

MWDUG – Quarterly Meeting
IBM TEC, Hyatt Building, 71 South Wacker
March 10th, 2016
Chicago, IL, USA

SEGUS & SOFTWARE ENGINEERING sponsor this event & present

Compliance with compliments! Viable DB2 z/OS workload tracking

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.


Audience experience Level

Beginner, Intermediate, Advanced



 Objective 1 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.
 Objective 2 Solution overview and their Pros/Cons
Get an overview about the existing solutions and understand how they work.
 Objective 3 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.
 Objective 4 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.


Speaker biography

Ulf Heinrich is the Director of Solutions Delivery at SEGUS. 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.