(Joe Geller, Dave Simpson and Tony Andrews) As we all know, for each statement, Db2 determines the access path to use to find the data. It chooses the cheapest access path using the table statistics.

(Adeline SE Chun, Aiden Gallagher, Amar A Shah, Callum Jackson, Claudio Tagliabue, Iliya Dimitrov, James Blackburn, Joel Gomez, Kim Clark, Lee Gavin, Maria Menendez, Martin Evans, Mohammed Alreedi, Murali Sitaraman, Nick Glowacki, Shishir Narain, Timothy Quigly, Tony Curcio, Ulas Cubuk and Vasfi Guc

(Susan Gantner) RDi V9.6 seems to be the gift that keeps on giving. I started this series about this release of RDi almost two years ago. You may have thought my last (fifth) tip in the series was the last on this subject, but it turns out there’s still more!

(Sebastian Zok) Years ago when I was a consultant I helped a customer move their DB2 system from one data centre to another data centre located in a different country.

(David Shirey) Once you have IBM Watson Studio, are you all set?

(David Morris) An Agile software development principle is continuous delivery and integration of working software. Jenkins software automates this process.

(Martin) 100% of our studio audience learned something!Craig gave a good overview of his new book on Db2 application performance.

(Gareth Copplestone-Jones) As we saw in the previous article, (DB2 for z/OS Locking for Application Developers Part 1) the ACID properties of database transactions (atomicity, consistency, isolation and durability) are intended to guarantee data integrity.

(Ted Holt) We all know that the SQL SELECT statement only retrieves data, right? If you want to modify data, you have to use INSERT, UPDATE, DELETE, or MERGE, correct? Well, to quote the great George Gershwin, It Ain’t Necessarily So. You can modify data from a SELECT statement, and maybe sometimes

(Joe Pluta) In my previous article, I explained how to use extension files to encapsulate a legacy database. This allows you to add new data points to the database without the impact of changing an existing master file.