Db2 articles, whitepapers, and presentations, curated and reviewed by the International Db2 Users Group (IDUG).
View All Blogs
Written by Eddy Coppens Posted By Tony Andrews 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 read more...
Earlier this year, I attended the GSE BeLux Conference in Brussels. Jan Cannaerts of Solidaris gave a really enjoyable presentation on his use of the Db2 instrumentation facility. Here is his presentation read more...
Db2 Attachment Facilities Intro 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 application. Let's read more...
Db2 by the back door (part 1) Introduction 65 million years ago, or so it seems to many, COBOL-programming dinosaurs roamed the earth. They accessed their Db2 data with highly efficient static read more...
The Book of Db2 Pacemaker – Chapter 3: Pacemaker Resource Model: Into the Pacemaker-Verse Written by Alan Lee Let me openly admit that my first treatment of this topic was a very thorough read more...
The Book of Db2 Pacemaker – Chapter 2: Pacemaker Cluster … Assemble! Written by Gerry Sommerville First off, I strongly recommend readers to review Chapter 1 of this series - The read more...
The following is a collection of SQL tips and reminders about modern SQL that some people may have forgotten. These SQL tips are reminders that are not magic but some people may have forgotten or read more...
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 syntax, the join predicate must be coded as part of the ON read more...
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 parts of an SQL query. If the scalar fullselect returns read more...
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 relevant: Check out the links to previous articles and presentations read more...
SQL: Self Joins Why is it sometimes we see SQL queries that list a table more than once in the same query. And this isn’t where you see a table in both the outer query, and also in a subquery. read more...
The following article was provided by Cuneyt Goksu from IBM: The Db2 Analytics Accelerator for z/OS (Accelerator) has improved the performance and reduced the resource consumption of hundreds of Db2 read more...