Over the years as Db2 has traded real storage exploitation for CPU and zIIP MIPS reductions, customers have become more aggressive at utilizing these techniques. Db2 buffer pool expansion, EDM and authorization cache pools, as well as persisting threads through the use of KEEPDYNAMIC and RELEASE...
Written by: Mateja Jankovič, IDUG EMEA 2018 Conference Chair The 2018 IDUG Db2 Tech Conference took place in St. Julians, Malta, November 4 – 8, where History & Present are combined . Malta is at the edge of Europe but it was often in the center of the history what reflects on...
I spend every day of my life since 1990 as a Db2 DBA both on Db2 for z/OS and Db2 for LUW. Most of this time has been in support of various application teams as they build systems that use Db2 as their data store. During that time, I’ve collected a lot of knowledge that makes my job easier and...
1 Comment - no search term matches found in comments.
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...
It has always been very important to understand when any changes in your database's configuration are made. Change control processes have been a central part of most production environments (and many development and QA environments, too) for a long time. However, as companies have outsourced...