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. Continue reading “Monitoring and Optimizing Db2 Prefetching and I/O”

Tridex Db2 LUW – October 8th 2020 agenda

10:00 – 10:15Celia Gahagan, Executive Director, Morgan Stanley, President Tridex
Opening Remarks
10:15 – 11:15John Hornibrook, STSM, IBM Toronto Lab
Db2 Turbo Statistics – How to Accelerate Your Query Performance
11:15 – 11:30Break
11:30 – 12:00Dan Snoddy,  Software Development Manager, IBM Toronto Lab
What is Db2 Graph
12:00 – 1:00Walter Alvey, Senior Software Engineer, IBM Silicon Valley Laboratory
Unboxing Db2 v11.5

 

Db2 Turbo Statistics – How to Accelerate Your Query Performance

Download PDF

Watch recording (logged in Tridex members only)

Session title: Db2 Turbo Statistics – How to Accelerate Your Query Performance

Session abstract: Catalog statistics are what fuel the Db2 optimizer, and its tank is always full because of automatic statistics collection. However there are some extra buttons on the dashboard that you can use to enable even better statistics to really boost your query performance.

Continue reading “Db2 Turbo Statistics – How to Accelerate Your Query Performance”

Tridex Db2 LUW – June 2nd 2020 agenda

10:00 –
11:00
Les King, IBM
DB2 V11.5.4 Product Overview
11:00 – 12:00Michael Roecken, IBM
Db2 Advanced Log Space Management – Trying to Make Life Simple