Db2 articles, whitepapers, and presentations, curated and reviewed by the International Db2 Users Group (IDUG).
View All Blogs
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...
The Book of Db2 Pacemaker – Chapter 1: Red pill or Blue pill ? Written by Alan Lee If you have heard about Db2 support of Pacemaker and have currently deployed Db2 in a highly available read more...
Introduction: What is a Temporary Table 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 available to the read more...
How to use “package” access path information to solve a real-life application issue! Get access path from the “package”! The new SQL EXPLAIN statement options! There are NEW (as of Db2 for z/OS read more...
Db2 Z V12 introduced interesting new functionality to the “RECOVERY” utility. This new functionality is called ‘redirected recovery’ and it has great potential! Ø This blog is one of a read more...
Db2 Columnar Database Next Generation Insertion - Improvements on Trickle Insertion and Data Loading Written by Ron Liu Next Generation INsertion (NGIN) was designed to enhance insertion performance read more...
A Series of Short Blog Posts on Db2 LUW Performance – Part 1 Written by Raghavendra Chiyodu 1. Why Runstats is very useful for the Db2 optimizer? (Db2 LUW optimizer) read more...