Db2 articles, whitepapers, and presentations, curated and reviewed by the International Db2 Users Group (IDUG).
View All Blogs
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...
DSNACICS is a useful IBM supplied procedure for Db2. What does DSNACICS do? It allows one to invoke a CICS server program. To be clear. you don’t invoke a CICS transaction. You invoke a CICS program! read more...
Solve Sudoku using SQL!!! This festive season, impress your friends and colleague with your quick Sudoku skills and some clever SQL! How? Using recursive SQL, one can “solve” Sudoku. Just one read more...
Written By: Mark Gillis . Posted By: Tony Andrews 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 more...
Case Study #1: The Query: SELECT FROM T1 JOIN T2 ON T1.C1 = T2.C1 AND T1.C2 = T2.C2 WHERE T1.C4 = ‘Something’ AND T1.C6 > 27 The Environment: The only available interesting index on read more...
Written By: Joe Geller Posted By: Tony Andrews SQL Pagination – New Syntax Problem Statement One of the oldest problems in Db2 performance was the efficient processing of pagination. Pagination read more...