(Paul Tuohy) In this article, I want to share with you an SQL scalar function that I happen to have been using quite a bit recently. At times, when using an SQL select statement, you may want to format a number or date.
(Martin) 100% of our studio audience learned something!Michael gave a deep dive into the latest log improvements in Db2 11.5.
(Craig S. Mullins) What better way to start off the New Year than with a quick blog post to remind everybody that the end of service deadline is looming for Db2 11 for z/OS… and that means it is time for you to move to Db2 12 for z/OS this year!
(Rafael Victoria-Pereira ) The first question crossing your mind is probably “Why do this?” I’m sure that, after reading the last few TechTips of this series, you’ve realized how useful SQL in your RPG code can be, but it’s probably not so obvious why the opposite can be equally beneficial.
(Craig S. Mullins) The first part of any Db2 performance management strategy should be to provide a comprehensive approach to the monitoring of the Db2 subsystems operating at your shop. This approach involves monitoring not only the threads accessing Db2 and the SQL they issue, but also the DB2 add
(Craig S. Mullins) In general, creating indexes to support your most frequent and important Db2 SQL queries is a good idea. But the size of the table will be a factor in decided whether to index at all and/or how many indexes to create.
(James Cockayne) DevOps engineer – job adverts for these positions abound, demanding years of experience in ten or fifteen skills and languages.
(Martin) 100% of our studio audience learned something!Tony gave the developer highlights from the past 4 versions of Db2. This is a great tutorial and refresher.
(Rafael Victoria-Pereira) Normalization, explained in the first TechTip of this series, is more than just a theoretical concept. It’s time to put it to work in your database.
(Henrik Loeser) In the past, I have blogged about how to access a Db2 database on IBM Cloud from your local machine. I cataloged the cloud host and its database. Then, connected to it using the command line processor (CLP) by passing a username and password.