Want to get easy access to the latest DB2 v9.7 monitor information in an easy 'snapshot-like' way? MONREPORT.DBSUMMARY is definitely worth a look!
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.