Caching Db2 SQL Select Results Improves Workload Performance

Craig Mullins discusses in-memory data access optimization techniques

for accelerating Db2 z/OS workload performance

In this overview of in-memory data access optimization strategies for Db2 z/OS, Craig Mullins, an IBM Db2 Gold Champion, delves into two approaches and their relative advantages: buffer pool caching and result set caching. Craig highlights how the novel approach of result set caching can significantly enhance the performance of Db2 workloads and the overall efficiency of the Db2 application environment.

"*" indicates required fields

First Name*
Last Name*

North America

15 Constitution Dr, Suite 100 Bedford, NH 03110

Hours

Mo-Fr: 8:30am - 5pm (ET)

Call Us

(603) 458-5300

Israel

Hahilazon 3
Ramat Gan 5252267
Israel

Hours

Su-Th: 8:30am - 5pm (GMT+3)

Call Us

+972-3-5763100

North America

15 Constitution Dr, Suite 100 Bedford, NH 03110

Hours

Mo-Fr: 8:30am - 5pm (ET)

Call Us

(603) 458-5508 

Israel

Hahilazon 3
Ramat Gan 5252267
Israel

Hours

Su-Th: 8:30am - 5pm (GMT+3)

Call Us

+972-3-5763100