Author: Ember Crooks

0

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...

1

DB2’s Got Talent 2014

One of the highlights of 2013 for me was winning third place in the DB2’s Got Talent competition. If you’re a long time reader, you may remember me begging for votes the last two years in March. But this contest is for those who are newer to presenting about DB2 topics in the larger DB2 community, so I’m done –...

2

2013 Year in Review

My Year I first want to share a few things that stood out this year. In March, I won third place and a free iPad in the DB2’s Got Talent show. I highly recommend participating – great way to hone your presentation skills and to get your name out there in the DB2 community. The 2014 show is looking for...

0

Care and Feeding of Statistical Views

The whole point of statistical views is to improve the performance of SQL that joins tables. Or to help you collect statistics on expressions – though if you’ve got 10.5, consider expression-based indexes for that instead. Giving the DB2 Optimizer more data is generally a good thing for query performance. If you don’t keep runstats current on your statistical views,...

0

DB2 Night Show EggNog Party on Friday!

Come listen to the Third Annual DB2 Night Show EggNog Party at 10 AM CT on December 20th(tomorrow!). I’ll be one of the guests! This is a fun annual tradition. It’s near Scott’s birthday, and he occasionally gives out birthday presents to his live audience! It is also fun to hear DB2 folks you’ve heard of share their views of...

5

Using a Statistical View to Improve Query Performance

Sometimes just using the index advisor and a bit of common sense, you can address SQL performance issues. But other times, you have to dig a bit deeper. I recently found the following query and 300 of its closest cousins (differing only in the length of the second in-list) were eating 30% of the CPU time used by queries on...

4

SQL5005C and Ulimit Issues

I’m spoiled. While we build a fair number of environments each year, we also have basic starting standards. Because of this, I sometimes miss the basics when a problem shows up. Or at least it takes me longer to get there. In this case, we had a couple of alerts over the high-volume weekend (Black Friday 2013). They were alerts...

12

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...