(Robert Catterall) Not too long ago, I received a note from the leader of a Db2 for z/OS database administration team, asking for my take on a Db2 12 buffer pool configuration set-up that his team had devised.
Tag: IBM
Experiences with SQL PL for redesigning a GUI application
(Peter Vanroose) For our course administration we use (already for several decades now) an application which was developed in-house, combined with a 45-table database on Db2 for z/OS.
The DB2Night Show #226: The Data Pioneer
(Martin) Martin discussed the issues for the DBA in a brand new environment, including integration with DevOps.
New performance and security feature in Db2: Authentication cache
(Henrik Loeser) The recent release of Db2 11.5.3 (Db2 V11.5 Mod Pack 3) includes a small gem that impacts both performance and security. It is a cache for User ID and Password-based authentication.
Db2 11 for z/OS End of Service Date Extended!
(Craig S. Mullins) In an earlier blog post I wrote about Db2 11 for z/OS End of Support Coming This Year (2020)… but that was before the global COVID-19 pandemic swooped in and changed everything!
Complex SQL tuning in Db2 for z/OS
(Pawel Hryb) So many words have been said about SQL tuning. But I would not like to repeat basic questions like how to find appropriate index or how to denormalize your data to make an SQL more efficient.
What’s New With Db2 Web Query?
(Alex Woodie) Db2 Web Query, which is IBM’s strategic business intelligence tool for IBM i, doesn’t follow the same release cycle as the operating system itself.
IBM Watson Studio: Download pandas DataFrame as CSV or Excel file
(Henrik Loeser) Right now, I am working with IBM Watson Studio on some analytics side project. It is nice to work with Jupyter Notebooks, Python and pandas and data again. Even Db2 is involved.
Big Blue Makes Moves To Mainstream Db2 Mirror
(Timothy Prickett Morgan) When IBM brought out its active-active Db2 for i database clustering extensions, called Db2 Mirror appropriately enough, almost exactly a year ago to improve the resiliency of databases and therefore the applications that run atop them on the IBM i platform, we had a few as
The DB2Night Show #225: The new face of Db2: Cloud-Native and AI ready
(Martin) 100% of our studio audience learned something! Piotr showed how Db2 has evolved for AI and the cloud.