Stream: Db2
Time: 10:00 - 10:45
Distributed applications, both read and update, accessing Db2 is by the fast growing area of new business pplication transaction processing. High Performance DBATs (HP-DBATs) is a significant and valuable performance feature for distributed applications introduced in Db2 10. Use of this feature can also be dangerous if not implemented in an intelligent way. The main objective of this session is to help users implement HP-DBATs in a safe controlled way and to maximise the performance benefit. This session will cover the following topics: overview of preexisting support for thread pooling and inactive connection support; what are HP-DBATs and operational characteristics, where are the performance benefits coming from, which application workloads are best suited to HP-DBATs and how to identify them; what are the risks; how to get into a safe starting position, WLM considerations and setup; war stories based on real world customer experiences
There is currently no attachment for Hard Lessons Learned using High Performance DBATs
John’s career began at Rolls Royce Aero Division in 1974. He then moved to IBM, taking on pivotal technical roles, including Lead for UK Technical Support for Db2 for z/OS. In 1994, he went on assignment to the IBM Silicon Valley Lab in San Jose as a senior performance analyst/engineer for Db2 Versions 3 and 4, with specific lead responsibility for Db2 Data Sharing. In 1998, he permanently joined Db2 for z/OS Development and in 2003 he was appointed as an IBM Distinguished Engineer. He has received multiple IBM Corporate Technical Recognition Awards and is an IDUG Hall of Fame Speaker. In August 2022, after over 40 years at IBM John retired from his role as an IBM Distinguished Engineer. In Jan 2024 John joined the Triton team as a Senior Consultant.
Click here to give some Feedback so we can make it even better next year!