DB2 11.1 for LUW introduced built-in SQL functions for regular expressions, a long-awaited enhancement that effectively supersedes a couple of popular workarounds for regex processing in DB2 SQL. This article describes the REGEXP functions and explains what makes them better than older workarounds.
I’ve spent the last 17 years teaching SQL Performance & Tuning on DB2 for z/OS. I’ve been trying to get SQL developers to think about the predicates they write from DB2’s perspective instead of what makes sense to humans.
My introduction to DB2 and SQL occurred over 30 years ago. It changed my life. Now big data tools have SQL as well.
There are numerous enhancements to SQL in DB2 12 for z/OS. There is also a significant amount of SQL performance enhancements in DB2 12 for z/OS which contribute to the “out of the box” savings realized when migrating from DB2 11 for z/OS. The IDUG team explored some of the most significant new SQL
Often times there can 4,5,6 different ways to write an SQL query and get the same results back. What makes one better than any of the others, and is there any ones that are always better, or always worse? Sometimes rewriting 1 predicate in an SQL statement can cause optimization to change. This pres