(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.
(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!
(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.
(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.
(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.
(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
(Martin) 100% of our studio audience learned something! Piotr showed how Db2 has evolved for AI and the cloud.
(Brian Laube) There are NEW (as of Db2 for z/OS V10) SQL “EXPLAIN” statement options to get the hidden details of the actual access path instructions from the actual package (which is actually used at run time) and stuff that impossible-to-read package instruction “explanation” into the friendly-to
(Craig S. Mullins) During the month of April 2020 I wrote a series of blog posts on the different types of Db2 for z/OS database change management and the things to remember and consider…
(Robert Catterall) On a number of occasions over the past several months, I have seen that there is some misunderstanding in the Db2 for z/OS community regarding support for certain types of database objects in a Db2 12 environment.