Rebind Phase-In

Download PDF

Watch recording (logged in Tridex members only)

Session title: Rebind Phase-In

Session abstract: In a busy Db2 system, applications are continuously executed by several threads. In order for a DBA to rebind application packages to enable new features by changing bind options or make changes to access paths for the static SQL statements, the DBA must wait for a window in which the applications aren’t running, must take an application outage, or must use a cumbersome workaround. Continue reading “Rebind Phase-In”

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”