I spend every day of my life since 1990 as a Db2 DBA both on Db2 for z/OS and Db2 for LUW. During that time, I’ve collected a lot of knowledge that makes my job easier and gets easier and gets the answers to the developer’s questions in a timely fashion.
You can create profiles to selectively control groups of distributed (DBAT) threads and connections, set thresholds for query acceleration (not covered in this article) or provide override properties to model your test subsystem to reflect the computing power of your production environment.
The last post of the XML series. This time we discuss the Db2 12 that introduced a couple of interesting enhancements to the SQL/XML functions.
En la Parte 1 de este artículo, presentamos la primera de dos mejoras de SQL altamente solicitadas por muchos clientes en Db2 12 – “DELETE por parte”. En esta Parte 2, veremos las mejoras en “MERGE”.
In the early days of DB2 for z/OS, pretty much every change to a table would result in an unload-drop-recreate-load of the table. This article will talk about how the ALTER table in DB2 12 for z/OS has evolved from DB2 11 for z/OS and what you need to know from a practical point of view.
In DB2 11