Are you happy or are you still deprecated?

Download PDF

Watch recording (logged in Tridex members only)

Session title: Are you happy or are you still deprecated?

Session abstract: Db2 has grown a lot over the years and, partly due to this, it carries around a ton of old baggage. It is definitely the right time to start crawling through the Db2 catalog and review any and all of the “deprecated” objects that are hanging around still nailed to their perches! Continue reading “Are you happy or are you still deprecated?”

Huffman Compression Usability

Download PDF

Watch recording (logged in Tridex members only)

Session title: Huffman Compression Usability

Session abstract: Db2 12 for z/OS delivered the Huffman compression feature as an additional compression option. The Huffman compression feature exploits the Z hardware-based Huffman entropy encoding compression within the IBM z14 Compression Coprocessor (CMPSC). Continue reading “Huffman Compression Usability”

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”

Starter Guide to Data Sharing Monitoring and Tuning

Download PDF

Watch recording (logged in Tridex members only)

Session title: Starter Guide to Data Sharing Monitoring and Tuning

Session abstract: This session will introduce and discuss: Firstly,  global locking and the Db2 LOCK1 structure, and global lock contention monitoring and tuning; Secondly, group buffer pools, GBP reads, GBP writes, GBP castout, and GBP monitoring and tuning. Continue reading “Starter Guide to Data Sharing Monitoring and Tuning”