Stream: Db2
Time: 11:00 - 11:45
High volume concurrent insert workloads are the most challenging from a performance perspective. This double session will provide a technical deep dive on designing for high performance concurrent insert processing. This session will introduce and discuss the following topics: key physical design questions, typical performance bottlenecks, insert free space search steps, relevant Db2 features which can help, The session will conclude with a war story to illustrate key learning points.
Part 2 will be this afternoon.
There is currently no attachment for Design for High Performance Concurrent Insert Processing - Part 1
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!