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

First off, I strongly recommend readers to review Chapter 1 of this series - The Book of Db2 Pacemaker – Chapter 1: Red pill or Blue pill? It...

Read Post

The following is a collection of SQL tips and reminders about modern SQL that some people may have forgotten.  These SQL tips are ...

Read Post

When coding SQL joins, is there any difference in where you code your filtering predicates?  We know that when you code SQL using the ANSI-92...

Read Post

This term relates to any SELECT that returns a single value (one column, one row).  It can be used as an expression in the SELECT, WHERE, or HAVING...

Read Post

As a follow up to our previous article on IDAA we also wanted to bring attention to several years worth of content on IDAA that might still be...

Read Post

Why is it sometimes we see SQL queries that list a table more than once in the same query? There are a number of reasons where this self-joining is...

Read Post

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

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

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 use “package” access path information to solve a real-life application issue! Get access path from the “package”!

Read Post

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

Read Post

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

Read Post