Technical Content

IDUG News Technical Content

For many customers, string data dominates storage cost. Frequency-based compression is not effective for high cardinality datasets. So percentage...

Read Post

Since Db2 11.5.4 which itself laid a new foundation for how columnar inserts were handled by the columnar data engine (CDE), many new features for...

Read Post

Newly introduced in Db2 11.5.8, Logical Schema Backup and Restore utilities for columnar tables specialize in flexibility, usability, and fine grain...

Read Post

Based on our experience speaking with CTOs and IT leaders in large enterprises, we have identified the most common misconceptions about cloud data...

Read Post

Modern enterprise is global, and data comes in new unstructured and semi-structured formats that can augment machine-learning-based insights. Given...

Read Post

If you plan to prepare for Db2 13 migration and you are about to activate the very last function level of Db2 12 - V12R1M510, you need to make sure...

Read Post

DSNACICS is a useful IBM supplied procedure for Db2. What does DSNACICS do? It allows one to invoke a CICS server program.

Read Post

Solve Sudoku using SQL!!! This festive season, impress your friends and colleague with your quick Sudoku skills and some clever SQL! How? Using...

Read Post

New, Final and Old tables are features that have been around in Db2 for several versions, at least back to v9.7, but they don’t seem to get a lot...

Read Post

Several case studies on what to do when indexes are only be effective to a limited extent

Read Post

One of the oldest problems in Db2 performance was the efficient processing of pagination – when an online application needs to process an...

Read Post

Many new features of Db2 are being used quite frequently, while others not so much. This article is a reminder, and may not be a complete list....

Read Post