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
When working on the revisions for my presentation for IDUG Europe, I noticed there was no equivalent to the mysql_real_escape_string in the DB2 CLI. A quick searching through the mysql source code I was able to find the function and a couple of modifications later I was able to make it generic ...
I figured I would post some small applications along with way that people might find them useful and can modify them for their own needs. This first small application makes use of libpcap to be able to capture all the statements coming in to the DB2 server over DRDA and prints them to the screen.
The video content presented here can be downloaded and played with your favorite web browser, as long as a recent version of the Macromedia Flash Player plug-in is activated.