Monitoring and Optimizing Db2 Prefetching and I/O

Download PDF
Watch recording (logged in Tridex members only)

Session title: Monitoring and Optimizing Db2 Prefetching and I/O

Session abstract: I/O is a fundamental characteristic of Db2 performance. It is not only important to understand I/O access patterns via monitoring, but also to be able to tune Db2 prefetching and I/O. Optimizing Db2 I/O is critical both for row- and column-organized table performance.

Attend this session to peek behind the curtain at Db2 prefetching and I/O both from a functional and monitoring perspective and learn tips and tricks for tuning Db2 to maximize I/O throughput.

Speaker biography: Chris is a Senior Software Engineer who is product owner for storage and compression for Db2 with BLU Acceleration. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS) and Db2 Big SQL.