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
5 Misconceptions About Cloud Data Warehouses
Posted In: Technical Content,
Date posted Mar 6

Based on our experience speaking with CTOs and IT leaders in large enterprises, we have identified the most common misconceptions about cloud data...

Read Post
Explore the third generation of IBM Db2 Warehouse — fully managed on AWS
Posted In: Technical Content,
Date posted Feb 28

Modern enterprise is global, and data comes in new unstructured and semi-structured formats that can augment machine-learning-based insights. Given...

Read Post
Consistency of zParms in Db2 Data Sharing Groups
Posted In: Technical Content,
Date posted Jan 16

If 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 Post
DSNACICS. Why use DSNACICS? calling DSNACICS through REST API – A user experience
Posted In: Technical Content,
Date posted Jan 6

DSNACICS is a useful IBM supplied procedure for Db2. What does DSNACICS do? It allows one to invoke a CICS server program.

Read Post
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