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
Fun with SQL: Solve Sudoku with recursive SQL
Posted In: Technical Content,
Date posted Dec 7

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
Prove your changes; NEW, FINAL and OLD tables, Mark Gillis, Triton
Posted In: Technical Content,
Date posted Oct 31

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
When Indexes Are Only Partially Effective
Posted In: Technical Content,
Date posted Oct 4

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

Read Post
SQL Pagination – Data-Dependent (New Syntax) and Numeric-Based
Posted In: Technical Content,
Date posted Oct 3

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

Read Post
Db2 for z/OS SQL and Application New Features v8-v12
Posted In: Technical Content,
Date posted Sep 28

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
Db2 Index Overview
Posted In: Technical Content,
Date posted Sep 7

Indexes perform a critical role in any relational database and Db2 is no exception. Let’s take a look at the way indexes work in a Db2 environment.

Read Post
Are you Packaged and Bound for Db2 13?
Posted In: Technical Content,
Date posted Aug 18

From Emil Kotrc and Julia Carter | Package rebinds can sometimes be a real challenge for DBAs when it comes to Db2 upgrades. But when it comes to...

Read Post
Db2 V13 - what is new and exciting from a user perspective
Posted In: Technical Content,
Date posted Aug 3

Db2 Version 13 is upon us! After V12, IBM was a bit vague about when a new version number for Db2 would be created. Why? IBM was using Db2...

Read Post
Introducing Db2 Click to Containerize
Posted In: Technical Content,
Date posted Jul 8

From George Baklarz and Phil Downey | Many customers are looking at modernizing their databases by moving them into a containerized environment such...

Read Post
Modernizing Db2 Containerization Footprint with Db2U
Posted In: Technical Content,
Date posted Jul 4

Containerization takes Db2 to the world of Cloud Paks, Red Hat OpenShift, Public Cloud Kubernetes platforms (AWS, Azure, Google Cloud and IBM...

Read Post
Cool factor of z16
Posted In: Technical Content,
Date posted Jun 7

Recently, I have been visiting a technical university with a short speech at a seminar and my topic was IBM mainframes. Fortunately, this was after...

Read Post
Db2 catalog tables - Statistics
Posted In: Technical Content,
Date posted May 24

From the IBM Data Management Console Development Group Jun Liu , Guo Bin Zhao, Yinmei Chen | Db2 maintains a set of catalog tables that describes...

Read Post