DB2 LUW v9.7 provides a very easy way to reduce the overhead of 'trivially different' SQL statements
The International DB2 Users Group (IDUG) is pleased to partner with ITGAIN to deliver a free Webcast by long-term IDUG member and former user speaker Norbert Munkel. Sydney-Oct 13 - 0900 to 1000; Chicago-Oct 12 - 1700 to 1800.
The most common scenario where Currently Committed comes into play is where one connection running in the default cursor stability (CS) isolation attempts to read a row which is locked for update by another connection. Normally, the reader would be blocked until either the max...
As well as something that gives you a static SQL snapshot (MON_GET_PKG_CACHE_STMT - see the previous post in this series), DB2 9.7 also introduces - ta da! - section actuals.
DB2 LUW 9.7 is a pretty impressive release. It's been out for a while now, and we've seen a huge number of customers moving there to take advantage of the slate of great features like Oracle compatibility and index / temp / LOB compression, to name a few. No raindrops on roses or whiskers on kit