Monthly Archive: March 2012

3

What is DB2’s Got Talent, and Why Should You Care?

Well, I’m out. 5th place or lower overall, so no need for more votes. Thanks for your support, and I still recommend everyone listen to the shows – great information there. I have to admit that I didn’t listen to all of last year’s DB2’s Got Talent shows as they were occurring. I didn’t go back and listen until I was...

2

Parameter Wednesday – DB CFG – LOCKLIST

DB2 Version This Was Written For 9.7 Parameter Name LOCKLIST Where This Parameter Lives Database Configuration How To Check Value $ db2 get db cfg for wc005s01 |grep LOCKLIST Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC(4096) OR $ db2 “select name, substr(value,1,16) value, value_flags, substr(deferred_value,1,16) deferred_value, deferred_value_flags, substr(datatype,1,16) datatype from SYSIBMADM.DBCFG where name=’locklist’ with ur” NAME VALUE VALUE_FLAGS...

0

VARCHAR: Friend or Foe

I read an article from Craig Mullins on “Working with variable data“. The rest of this post is going to assume you’ve read it, so click through and then come back. I’ve seen performance issues caused by VARCHAR before, and Craig makes some interesting points. VARCHARs are actually one of the big reasons to Reorg frequently. His post is geared...

7

Parameter Wednesday: DBM CFG – INTRA_PARALLEL

DB2 Version This Was Written For 9.7 Parameter Name INTRA_PARALLEL Where This Parameter Lives Database Manager Configuration How To Check Value $ db2 get dbm cfg |grep INTRA_PARALLEL Enable intra-partition parallelism (INTRA_PARALLEL) = NO OR $ db2 “select name, substr(value,1,16) value, value_flags, substr(deferred_value,1,16) deferred_value, deferred_value_flags, substr(datatype,1,16) datatype from SYSIBMADM.DBMCFG where name=’intra_parallel’ with ur” NAME VALUE VALUE_FLAGS DEFERRED_VALUE DEFERRED_VALUE_FLAGS DATATYPE ——————————–...

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