For many customers, string data dominates storage cost. Frequency-based compression is not effective for high cardinality datasets. So percentage...
Read PostTechnical Content
Curated Db2 Content
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 PostNewly introduced in Db2 11.5.8, Logical Schema Backup and Restore utilities for columnar tables specialize in flexibility, usability, and fine grain...
Read PostBased on our experience speaking with CTOs and IT leaders in large enterprises, we have identified the most common misconceptions about cloud data...
Read PostModern enterprise is global, and data comes in new unstructured and semi-structured formats that can augment machine-learning-based insights. Given...
Read PostIf 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 PostDSNACICS is a useful IBM supplied procedure for Db2. What does DSNACICS do? It allows one to invoke a CICS server program.
Read PostSolve Sudoku using SQL!!! This festive season, impress your friends and colleague with your quick Sudoku skills and some clever SQL! How? Using...
Read PostNew, 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 PostSeveral case studies on what to do when indexes are only be effective to a limited extent
Read PostOne of the oldest problems in Db2 performance was the efficient processing of pagination – when an online application needs to process an...
Read PostMany 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