In February 2016 the DB2 12 Editorial Committee was formed, comprised of volunteers from IDUG’s worldwide community of DB2 users and consultants. This White Paper contains their findings, including practical experiences and independent evaluations of the new features.
In this article we are going to examine some tuning options that a DBA has available to help improve dynamic SQL performance on DB2 LUW.
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.
A singleton SELECT - is this always the best solution for readability and performance? The article discusses a simple scenario, that shows that a singleton SELECT can result in surprising application behavior if not used properly.
DevOps is a very popular term, that describes the process of automating the processes involved in the delivery of applications. Including database changes in this can be difficult, but it's possible bring DevOps to your developers using Data Studio using the methods described in this article.