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

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

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

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

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

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

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

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