(Craig S. Mullins) Early in March 2019, IBM announced the latest and greatest new function level, 504 (FL504), for Db2 12 for z/OS. For those of you not paying attention, starting with Version 12, IBM has moved to a continuous delivery model and has been releasing new functionality regularly.
(Kalpana Shyam) Insert algorithm 2 (IAG2) was introduced in Db2 12 to increase throughput of INSERT statements and to reduce logging in specific conditions.
(Ember Crooks) While I’ve covered this topic in detail, and blogged about a specific backup performance problem, I’ve never talked about this at the basics level.
(Brian Laube) A temporary table (in most RDMS) is a place to keep data for the duration of some application process. The data is basically private and only available to the application user.
(Kevin Oliver) If your business hasn’t already embraced a multiple-cloud strategy, it’s likely that one is in your near future. Recent research shows that 85 percent of companies already operate in multicloud environments, and 98 percent of companies plan to be multicloud by 2021.
(Ted Holt) Hey, Ted: I am stuck on trying to create a function in RPG to use in SQL. I based it on your FMTDATE function, which I successfully installed and is working great! I have been trying to get this function working for five hours and I am at my wits’ end. Hopefully, you will notice someth
(Kellyn Pot’Vin-Gorman) Yep, still doing a lot of database migrations. Just too many people wanting to migrate their other database platforms over to Azure…
(Henrik Loeser) Last week I wanted to start testing some new Db2 features without going through the steps of installing that Db2 version.
(Paul Tuohy) One of the questions I have been asked a lot at conferences is “How do you figure out x in SQL?” In this article, I will discuss four things I use a lot when playing with SQL in Run SQL Scripts: VALUES, SYSIBM.SYSDUMMY1, global variables, and the system catalog.
(Marie Sumabat and Jennie Chang) With the activation of function level 504, Db2 12 for z/OS introduces support for the following 16 built-in functions, which can be invoked when using IBM Db2 Analytics Accelerator (Accelerator):