- This event has passed.
IDUG 2016 DB2 European Tech Conference
13. November 2016 - 18. November 2016
SEGUS & SOFTWARE ENGINEERING present
- Pdf presentation: Access Path Recovery for DB2 11 & 12 using RUNSTATS Rescue.
- Pdf presentation: Compliance with compliments! Viable DB2 z/OS workload tracking.
“Access Path Recovery for DB2 11 & 12 using RUNSTATS Rescue”
November 15th, 2016
What is the number one reason for bad access paths? Bad statistics!
Why do you have bad statistics? Bad timing is the number one reason, followed by manually updated stats and then forgotten about.
RUNSTATS Rescue for DB2 z/OS saves you when these events happen. The basis is a complete copy of all productive required statistical data in the DB2 catalog. This should be regularly executed and the data saved away. The best way to do this is to use a Generation Gengroup which automatically stores “copies” of the data. RUNSTATS Rescue then provides a front end where you can use a variety of inputs to get back you good access paths.
- Dynamic SQL, Static SQL completely covered
- Why PLAN Stability doesn’t save you when you need it
- What’s new in DB2 12 for Dynamic SQL that still will not save you
Audience experience Level
Beginner, Intermediate, Advanced
Speaker Biography
Roy Boxwell has more than 30 years of experience in MVS, OS/390, and z/OS environments – 26 of those in DB2. He specializes in installation, migration, and performance monitoring and tuning. Roy leads the SEG development team responsible for the real time database maintenance solutions. He is also an active participant, speaker and contributor on the IDUG DB2 Listserv and sends out a monthly DB2 z/OS Newsletter.
“Compliance with compliments! Viable DB2 z/OS workload tracking”.
November 16th, 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.
Audience experience Level
Beginner, Intermediate, Advanced
Objectives
| 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 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.