Tridex Db2 LUW – December 15th 2020 agenda

09:00 – 10:20George Baklarz, IBM
A RESTful Approach to Using Db2
10:20 – 10:30Break
10:30 – 11:40Mike Springgay, IBM
Db2’s External Tables: A Deep Dive
11:40 – 11:50Break
11:50 – 1:00Christopher Drexelius, IBM
Monitoring and Optimizing Db2 Prefetching and I/O

 

A RESTful Approach to Using Db2

Download PDF
Watch recording (logged in Tridex members only)

Session title: A RESTful Approach to Using Db2

Session abstract:

Modern application development paradigms need to be able to connect from a variety of devices to back-end databases. The use of native database drivers or frameworks are not always practical on mobile devices especially when there is a requirement to install drivers locally on the device.

Continue reading “A RESTful Approach to Using Db2”

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”