Author: Ember Crooks

0

DB2′s Got Talent – March 16 – db2caem: The Untold Story

This post ties in directly to my Friday presentation on the DB2Night Show’s DB2’s Got Talent Competition. Listen to the replay here: http://www.dbisoftware.com/blog/db2nightshow.php?id=341. My presentation is at the 52 minute mark.. Most importantly, please vote for me at https://www.surveymonkey.com/s/DB2TALENT16MAR I have just recently reached the point where 50% of my work is on db2 9.7. Due to WebSphere Commerce still providing...

2

Parameter Wednsday – DBM CFG: DIAGLEVEL

Continuing my trend of attacking some of the simpler parameters first, I’m going to cover DIAGLEVEL this week. DB2 Version This Was Written For 9.7 Parameter Name DIAGLEVEL Where This Parameter Lives Database Manager Configuration How To Check Value > db2 get dbm cfg |grep DIAGLEVEL Diagnostic error capture level (DIAGLEVEL) = 3 OR > db2 “select name, substr(value,1,16) value,...

0

What DBAs can do to Reduce Deadlocks

Deadlocking is an application problem. There are only a few things that DBAs can do to reduce deadlocking, and they all require buy-in from the application. Let me repeat that another way. Don’t set the parameters mentioned here without understanding the impact on your application. Currently Committed This is new behavior in DB2 9.7. It has a similar effect to...

0

WebSphere Commerce Stagingprop Doesn’t Copy OPTCOUNTER

This post is specific to WebSphere Commerce. If you’ve always assumed that stagingprop copied the whole row and every change, I’ve found an execption. Stagingprop does not copy the OPTCOUNTER column. What is OPTCOUNTER? OPTCOUNTER is a column used in optimistic locking. Basically, Commerce notes the value of OPTCOUNTER at the start of the transaction. Then when it is ready...

0

Introducing Parameter Wednesday – DBM CFG: NUMDB

This is a new blog post format I’m introducing. I’m declaring Wednesday Parameter Day. That means each Wednesday, I’ll pick a parameter and cover it in excruciating detail. Some of the details will come straight out of the info center, but I’ll add my own experiences and insight geared towards e-commerce databases and throw in specifics for WebSphere Commerce from...

0

Influential People and Moments in My Career

Sorry for the earlier 404. I think this should work. With my 15 minutes of fame as a contestant on the DB2Night Show’s DB2’s Got Talent competition, I’ve been thinking about the turning points and formative forces in my career. I started out as an accounting clerk, and wanted to be an accountant. That was after I got my first...

14

Runstats – What and Why

On looking over my previous posts, I found no fewer than 25 of them that mentioned runstats. But I wanted to cover runstats in a different level of detail. With this post, I aim to answer 2 questions – What is runstats? and Why should you run runstats? What Runstats is a utility. That’s why we say “run runstats”. You...

2

Fun With 9.7 Locktimeout Analysis

I first addressed the new 9.7 methodology for deadlock and locktimeout analysis in my post Analyzing Deadlocks – The New Way. I’ve been playing with it a bit, and wanted to share what I’ve found. First of all, so far, I like it. I can’t speak to overhead yet, but it integrates lock timeout analysis more tightly than it previously...