IDUG Content Committee

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 Book of Db2 Pacemaker – Chapter 1: Red pill or ...

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 not considered the implication or minor benefit. ...

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 clause. But the filtering predicates can be coded ...

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 more than 1 row or 1 value, an error occurs. ...

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 below: IDAA V7 Migration and Performance ...