Db2 articles, whitepapers, and presentations, curated and reviewed by the International Db2 Users Group (IDUG).
View All Blogs
Introduction: What is a Temporary Table A temporary table (in most RDMS) is a place to keep data for the duration of some application process. The data is basically private and only available to the read more...
How to use “package” access path information to solve a real-life application issue! Get access path from the “package”! The new SQL EXPLAIN statement options! There are NEW (as of Db2 for z/OS read more...
Db2 Z V12 introduced interesting new functionality to the “RECOVERY” utility. This new functionality is called ‘redirected recovery’ and it has great potential! Ø This blog is one of a read more...
Db2 Columnar Database Next Generation Insertion - Improvements on Trickle Insertion and Data Loading Written by Ron Liu Next Generation INsertion (NGIN) was designed to enhance insertion performance read more...
A Series of Short Blog Posts on Db2 LUW Performance – Part 1 Written by Raghavendra Chiyodu 1. Why Runstats is very useful for the Db2 optimizer? (Db2 LUW optimizer) read more...
Db2 Columnar Database Page-Based String Comp ression Written by Ron Liu For many customers, string data dominates storage cost. Frequency-based compression read more...
COLUMNAR DATA ENGINE (CDE) STORAGE New Feature Written by Ron Liu Since Db2 11.5.4 which itself laid a new foundation f or how columnar inserts were handled by the columnar data engine read more...
Logical Schema Backup and Restore for Columnar Tables Written by Aleks Santars Part 1 – Introduction (Part 2 to follow next week) Newly introduced in Db2 11.5.8, Logical Schema read more...
5 Misconceptions About Cloud Data Warehouses Written By Ashley Bassman In today’s world, data warehouses are a critical component of any organization’s technology ecosystem. They read more...
Explore the third generation of IBM Db2 Warehouse—fully managed on AWS Written By Ashley Bassman Data warehouses are mission-critical assets for your business to make quick, real-time decisions; read more...
Consistency of zParms in Db2 Data Sharing Groups Written by: Emil Kotrc, Broadcom I really never paid too much attention to the consistency of zParms in a data sharing group until recently. If you plan read more...