(Henrik Loeser) A popular PaaS (Platform as a service) technology is Cloud Foundry. On IBM Cloud, it is available both as public Cloud Foundry instances in multiple regions as well as Cloud Foundry Enterprise Environment (CFEE).
(Kate Wheat and Koshy John) When the RUNSTATS utility gathers statistics, the utility can either do row sampling after all the rows for the table are read or page sampling wherein all the rows from select pages in the table space are read.
(Kevin Oliver) Db2 recently simplified its editions structure to make the path from prototype to production deployment easier.
(Peter Hartmann) One of the major challenges for RUNSTATS is the sampling of the data rows e.g. for calculation of the COLCARD value in SYSIBM.SYSCOLSTATS and SYSIBM.SYSCOLUMNS.
(Gayathiri Chandran) There is a demand for a way to change the ownership of Db2 objects from one user to another.
(Klaas Brant) Db2 Developer edition is the free edition of the Db2 for Linux / Unix / Windows database. Unlike Microsoft and Oracle express offerings, DB2 Developer edition does allow for a large size (100GB) database and can use up to 16GB of memory.
(Henrik Loeser) If you have followed some of my work, you know that I use IBM Cloud Functions, i.e., a serverless approach, for many projects.
Here is Keri Romanufa with a presentation covering the architecture of Db2, including what is new with Db2 11.5
(Mike Larsen) It’s always a good idea to purge files that aren’t needed any longer. Chances are that you already have procedures in place to purge data from Db2 files and tables, but what about files that reside in the IFS?
(Florence Dubois and Paul McWilliams) The Db2 for z/OS development SWAT team recommends using FlashCopy as a best practice for non-disruptive consistency checks with the Db2 CHECK INDEX, CHECK DATA, CHECK LOB SHRLVL CHANGE utilities.