(Craig Mullins) Are you making plans to migrate to a new version of DB2? Do you know what impact the access changes for dynamic SQL will have on performance? When migrating to a new DB2 version, access path changes for dynamic SQL are unpredictable – as is the impact those changes will have on appli

(Mike Liu and Tony Lau) Performance engineering is a discipline that entails determining and reporting the current performance of a software solution. It involves simulating a large number of concurrent users, collecting diagnostic data, plotting graphs, doing performance analysis, and engineering p

(Billy Sundarrajan) Application developers and database administrators often face challenges with differing access paths in Production and Test DB2 subsystems when performing an EXPLAIN for a given SQL. In most installations, tables in Test subsystems are a lot smaller than the ones in Production su

(Philip Nelson) I’ve been working away on a Ruby on Rails project, with DB2 (Linux) at the back end. I’ve learnt a lot as I’ve went along, especially as this is my first serious foray into the world of DB2’s pureXML (I am indebted to Matthias Nicola from the IBM Silicon Valley Lab for the help he ha

(Deepak Vohra) As mentioned in the previous tutorial on PHP/DB2, PHP is widely used in web applications and most web applications have a database component. The PHP extension for DB2 database provides access to one particular widely-used database from a PHP script.

(Werner Schuetz) IBM DB2, Version 9.5 for Linux, UNIX, and Windows provides enhanced optimistic locking support, a technique for SQL database applications that does not hold row locks between selecting and updating, or deleting rows. Gain an understanding of this enhancement, and learn how applicati

(Will Kraft) IBM announced last week that it would open up its Jazz.net development platform to developers. Jazz.net is an open commercial software development community that helps to create global collaboration solutions based on IBM Rational technology. Jazz was originally open only to IBM staff,

(Deepak Vohra) A PHP: Hypertext Processor (PHP) script may be embedded in an HTML page; or run as a .php script in a web server such as Apache web server. PHP statements are included in tags.

(Julian Stuhler) Like any other technology, DB2 has its own myths and commonly-repeated fallacies, and nowhere is this more apparent than with Java applications. In this brief article, I’ll examine (and hopefully go some way to disprove) five of the more common fallacies that I see.

(Peggy Zagelow) Also among the ‘recommended practices’ that I often present on DB2 for z/OS stored procedures is this one: Don’t call the metadata stored procedures