Tri-State Db2 Technology Exchange
Db2 Users Group
| 09:00 – 10:20 | George Baklarz, IBM A RESTful Approach to Using Db2 |
| 10:20 – 10:30 | Break |
| 10:30 – 11:40 | Mike Springgay, IBM Db2’s External Tables: A Deep Dive |
| 11:40 – 11:50 | Break |
| 11:50 – 1:00 | Christopher Drexelius, IBM Monitoring and Optimizing Db2 Prefetching and I/O |
Download PDF
Watch recording (logged in Tridex members only)
Session title: A RESTful Approach to Using Db2
Session abstract:
Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content. Continue reading “A RESTful Approach to Using Db2”
Download PDF
Watch recording (logged in Tridex members only)
Session title: Db2’s External Tables: A Deep Dive
Session abstract: Take a deep dive into the world of external tables. This talk will introduce the concept of an external table within Db2. How they contrast to existing table types and when to leverage external tables.
Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content. Continue reading “Db2’s External Tables: A Deep Dive”
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”
Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content. Continue reading “Monitoring and Optimizing Db2 Prefetching and I/O”
| 10:00 – 10:15 | Celia Gahagan, Executive Director, Morgan Stanley, President Tridex Opening Remarks |
| 10:15 – 11:15 | John Hornibrook, STSM, IBM Toronto Lab Db2 Turbo Statistics – How to Accelerate Your Query Performance |
| 11:15 – 11:30 | Break |
| 11:30 – 12:00 | Dan Snoddy, Software Development Manager, IBM Toronto Lab What is Db2 Graph |
| 12:00 – 1:00 | Walter Alvey, Senior Software Engineer, IBM Silicon Valley Laboratory Unboxing Db2 v11.5 |
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”
Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content.
Continue reading “Db2 Turbo Statistics – How to Accelerate Your Query Performance – recording”