Are you responsible for upgrading to DB2 10, the newest version for LUW? Looking for details about what will and will not change when you upgrade? Attend this IDUG webinar on June 22 to learn about often overlooked, but very important, tips and tricks you should understand before upgrading to DB2 10
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
I've been meaning to start a blog on DB2 LUW performance for a while, and, well, now seems like a pretty good time. Why would I want to blog? Never mind that - much more importantly, why would anyone be interested in what I have to say? Good question! I've been part of the DB2 LUW development