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
Why is Db2 Warehouse faster with Cloud Object Storage
Posted In: Technical Content,
Date posted Dec 18

As you know, the cost of data warehouses is significantly dependent on the cost of storing significant amounts of data, and implementing COS support...

Read Post
The Book of Pacemaker - Chapter 4: Quorumania
Posted In: Technical Content,
Date posted Dec 14

I've got the Db2 instance up and running now, am I production ready?

Read Post
How to make and use your own IBM Db2 inside IBM Cloud using free "lite" plan
Posted In: Technical Content,
Date posted Dec 8

IBM provides a cloud-based version of Db2 LUW.  It is a full version of Db2 LUW Version 11.5.  The Db2 in the cloud can be very powerful and highly...

Read Post
Searching for gaps within consecutive numbers using SQL
Posted In: Technical Content,
Date posted Nov 13

If you would have asked me one month ago to come up with a query that coughs up missing numbers, I would have told you that there is no such a need...

Read Post
The Db2 Instrumentation Facility
Posted In: Technical Content,
Date posted Nov 9

Our shop runs a number of non-mainframe applications that connect to Db2 through DDF. One of these applications is IBM Datapower Gateway...

Read Post
Db2 Attachment Facilities
Posted In: Technical Content,
Date posted Oct 28

You want to write a program that connects to Db2 for z/OS and runs queries, updates the tables, and all the stuff you would expect from a database...

Read Post
Db2 by the back door (part 1)
Posted In: Technical Content,
Date posted Oct 10

65 million years ago, or so it seems to many, COBOL-programming dinosaurs roamed the earth. They accessed their Db2 data with highly efficient...

Read Post
The Book of Db2 Pacemaker – Chapter 3:  Pacemaker Resource Model: Into the Pacemaker-Verse
Posted In: Technical Content,
Date posted Oct 9

Let me openly admit that my first treatment of this topic was a very thorough top-down, lecture style, technical approach … until Michael Keaton...

Read Post
The Book of Db2 Pacemaker – Chapter 2: Pacemaker Cluster … Assemble!
Posted In: Technical Content,
Date posted Sep 26

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
Modern SQL tips and why to use them
Posted In: Technical Content,
Date posted Sep 23

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
On Clause vs Where Clause Filtering Predicates in Joins
Posted In: Technical Content,
Date posted Sep 18

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
SQL Scalar Fullselects
Posted In: Technical Content,
Date posted Sep 13

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