Optimizing Compression for Db2 Column-Organized Tables

Download PDF

Watch recording (logged in Tridex members only)

Session title: Optimizing Compression for Db2 Column-Organized Tables

Session abstract: Do you want to get better compression for your column-organized tables? This presentation will give you step-by-step instructions on how to correctly measure the current compression ratio and determine the effectiveness of the column dictionaries.

Continue reading “Optimizing Compression for Db2 Column-Organized Tables”

Db2 for all data: Open formats and Multi-engine Integration with IBM watsonx.data

Download PDF

Watch recording (logged in Tridex members only)

Session title: Db2 for all data: Open formats and Multi-engine Integration with IBM watsonx.data

Session abstract: The data analytics market has seen truly tectonic shifts over the last decade. Warehousing technologies from the 90s today struggle to address the critical demands of ever-growing data scale, data complexity and performance-sensitive workloads.

Continue reading “Db2 for all data: Open formats and Multi-engine Integration with IBM watsonx.data”

Do I really need to worry about my Commit Frequency? An introduction to Db2 Logging.

Download PDF

Watch recording (logged in Tridex members only)

Session title: Do I really need to worry about my Commit Frequency? An introduction to Db2 Logging.

Session abstract: Does it really matter how often my application commits its activity? Yes, yes it does. This session will explore what the Db2 log is, how Db2 writes to it, what a Unit of Work is, and the impact of canceling a Unit of Work with regards to Db2 logging.

Continue reading “Do I really need to worry about my Commit Frequency? An introduction to Db2 Logging.”