IDUG News & Blogs

Check back here frequently for our curated content – technical articles, IDUG news, and thoughts from our leadership, all posted here, and featured monthly in the IDUG eBulletin. Interested in contributing an article for consideration? Contact our Content Committee! 

IDUG News Technical Content
A Db2 Analytics Assessment can help you get more from Db2 for z/OS
Posted In: Technical Content,
Date posted Aug 8

Db2 for z/OS Data Gate (Db2 Data Gate) provides synchronized Db2 data to cloud-based applications reducing read-only operational processing and the...

Read Post
The Book of Db2 Pacemaker – Chapter 1: Red pill or Blue pill?
Posted In: Technical Content,
Date posted Aug 7

You might be struggling with this question – When is the right time to push my organization to take the red pill to have the new Pacemaker...

Read Post
Temporary Tables in Db2 (along with a painful lesson)
Posted In: Technical Content,
Date posted Apr 23

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...

Read Post
How to find Missing Db2 for z/OS static SQL access path information from PLAN_TABLE?
Posted In: Technical Content,
Date posted Apr 23

How to use “package” access path information to solve a real-life application issue! Get access path from the “package”!

Read Post
Db2Z and Redirected Recovery - user experience – Part 3 – Automatic Schema Comparison
Posted In: Technical Content,
Date posted Apr 21

Db2 Z V12 introduced interesting new functionality to the “RECOVERY” utility. This new functionality is called ‘redirected recovery’ and it has...

Read Post
Db2Z and Redirected Recovery - user experience – Part 2 – Details and Cavaets
Posted In: Technical Content,
Date posted Apr 19

Db2 Z V12 introduced interesting new functionality to the “RECOVERY” utility. This new functionality is called ‘redirected recovery’ and it has...

Read Post
Db2Z and Redirected Recovery - user experience – Part 1 – What it is and WHY and How
Posted In: Technical Content,
Date posted Apr 18

Db2 Z V12 introduced interesting new functionality to the “RECOVERY” utility. This new functionality is called ‘redirected recovery’ and it has...

Read Post
Db2 Columnar Database Next Generation Insertion - Improvements on Trickle Insertion and Data Loading
Posted In: Technical Content,
Date posted Apr 4

Next Generation INsertion (NGIN) was designed to enhance insertion performance and reduce log space usage. The NGIN enhancements mainly covered...

Read Post
A Series of Short Blog Posts on Db2 LUW Performance – Part 1
Posted In: Technical Content,
Date posted Mar 31

A collection of various articles written by Raghavendra Chiyodu

Read Post
Db2 Columnar Database Page-Based String Compression
Posted In: Technical Content,
Date posted Mar 28

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

Read Post
Columnar Data Engine (CDE) Storage New Feature
Posted In: Technical Content,
Date posted Mar 21

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
Logical Schema Backup and Restore for Columnar Tables
Posted In: Technical Content,
Date posted Mar 14

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