(Brian Laube) Db2 for zOS V12 introduces a new UNLOAD authority permission for tables. This is “beside” the good-old-fashioned classic table authority permissions for SELECTAUTH, INSERTAUTH, DELETEAUTH, UPDATEAUTH, etc. etc.

(Dino Quintero, Daniel Casali, Ricardo Dobelin Barros, Luis Ferreira, Alain Fisher, Federico Fros, Luis Daniel Gonzalez, Miguel Gomez Gonzalez, Mahesh Gurugunti, Nicolas Joly, Boris Litichevsky, Gabriel Padilla, Sudipto Pal, Rogelio Rivera Gutierrez, Bogdan Savu, Ismael Solis Moreno, Richard Wale) T

(Ted Holt) At the RPG & DB2 Summit last October, I chanced to overhear Rob Bestgen of IBM telling Paul Tuohy of System i Developer about a practice that he and others in IBM Lab Services had seen, a practice which they found horrifying. “Oh, no!” I thought. “I’ve written about that for itjungle.com!

(Robert Catterall) At this time, many Db2 for z/OS-using organizations have already completed their migration to Db2 12. Others are still in the process of accomplishing that migration, or are finalizing migration plans.

(Rafael Victória-Pereira) PSM stands for Persistent Storage Module. In short, it’s the language used to write “SQL programs.” I’ll delve into PSM with much greater detail later in this series, but for now, let’s just focus on what forms these SQL programs, or SQL routines as they are more commonly c

(Eddy Coppens) In most traditional migrations towards a new environment, one will most probably come up with the most current ideas to get the job done, but what about migrating a multi-terabyte sized database with a minimal down time?

(Martin) 100% of our studio audience learned something!Dale covered several resiliency models that customers have deployed along with the alternatives available.

(Paul Tuohy) In September 2019, Ted Holt published an article that demonstrated how an identity column can be used to generate a unique key in a table. In this article, I want to expand on that theme and examine another use of an identity column — replacing complex keys.

(Chad Reiber) I have the great opportunity to work with several Db2 z/OS users across the US. Certainly, I hear and see Db2 databases getting larger and the availability requirements longer; however, the size of the DBA group is shrinking.

(John Ghrist) Artificial Intelligence (AI) has had a somewhat dark reputation over the past few decades. It doesn’t help that it’s traditionally gotten a bad rap from Western culture.