In this article, we learn from a war story on how some misconceptions around Real Memory in z/OS and Db2 Buffer Pools can severely affect your environment, and how a few checks and simple calculations can give us a better picture.
The 2018 IDUG Db2 Tech Conference took place in St. Julians, Malta, November 4 – 8, where History & Present are combined. The conference offered 5 days of Db2 education and training, including new and emerging technologies.
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.
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
Fast INSERT performance speeds the way to getting new data into DB2, for ETL, bulk ingest jobs, and even just day-to-day transactions. In this new blog entry, we look at several helpful tips for making INSERT run as quickly as possible.