Category: Experiments


Backup Compression Consideration – DB2 COMPRESS vs. GZIP

We interrupt your regular programming for a quick announcement. If you have been reading for a while you know I am an occasional guest writer on this technical blog. I’ve worked this year on expanding my comfort zone with regular articles here, a developerWorks article to be posted next week, and I have entered as a competitor on the...


Activities vs. Requests

This started as a conversation with a couple of DBA friends when we were playing with MONREPORT.DBSUMMARY. That’s a pretty nifty way to get a quick look at a number of performance parameters, AND to limit the time period covered by the report. But the thing we noticed and were talking about is the difference between activities and requests. In...


Using an Event Monitor to Capture Statements with Values for Parameter Markers

Recently, I needed to do some SQL profiling – discovering exactly what SQL a web application was executing against the database. I learned a lot, and when I learn a lot, I try to share with my readers. I went into this exercise with two major misconceptions: A statement event monitor would collect parameter marker values Event monitor table output...