My favorite performance items in DB2 LUW v9.7 - #5: monreport.dbsummary
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!...

My favorite performance items in DB2 LUW v9.7 - #4: statement concentrator
DB2 LUW v9.7 provides a very easy way to reduce the overhead of 'trivially different' SQL statements...

My favorite performance items in DB2 LUW v9.7 - #3: Currently Committed
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......

My favorite performance items in DB2 LUW v9.7 - #2: section actuals
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....

My favorite performance items in DB2 LUW v9.7 - #1: MON_GET_PKG_CACHE_STMT
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...