(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.

(Robert Catterall) In a Db2 for z/OS context, RACF (the IBM security management subsystem for z/OS systems) can serve two important purposes, providing security for a Db2 environment in an external and an internal sense.

(Morgan Patou) In the scope of an upgrade project, with some colleagues, we have been deploying some D2-REST applications on Kubernetes pods using WebLogic Server.

(Jack Vamvas) Question: I need to report on the sum of disk allocated for Linux directories dedicated to DB2 LUW directories

(Joe Pluta) As business programmers, we spend most of our time working with the database, one way or another. Unless we’re lucky enough to be in on the ground floor of a new installation of a modern package, chances are that database will require modifications to support changing business requiremen