There are circumstances that some columns of a very large table need to be updated for various reasons. If this requirement is triggered by Application Developers and Business Users, generally and unfortunately, an SQL UPDATE program is written. Hopefully it COMMITS well frequently, it might create
The third and final of three presentations donated to IDUG by Sheryl Larsen is now available for download in the IDUG content file library. This presentation is from her DB2 10 & 11 SQL Optimization Enhancements IDUG presentation.
This is the first of three presentations donated to IDUG by Sheryl Larsen. This presentation is from her Advanced SQL Coding seminar, and contains information about advanced SQL programming and performance.
As with any new release of DB2 for z/OS there comes a host of SQL performance improvements. In this article, Dan Luksetich outlines a few interesting SQL enhancements coming our way in DB2 11 for z/OS.