Category: Uncategorized

4

IDUG NA Tech Conference wrap-up

Well, I managed to have my first week since December with no post last week. I was litterally doing something at the conference from 8 AM to 10 PM every day, and trying to fit regular work in the gaps. Ah, but what a conference it was. So much great information, ideas, and new connections. On a personal level, I...

0

Parameter Wednesday – DB CFG – HADR_TIMEOUT

DB2 Version This Was Written For 9.7 Parameter Name HADR_TIMEOUT Where This Parameter Lives Database Configuration How To Check Value > db2 get db cfg for sample |grep HADR_TIMEOUT  HADR timeout value                       (HADR_TIMEOUT) = 120 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...

5

Parameter Wednesday – DB CFG – HADR_SYNCMODE

DB2 Version This Was Written For 9.7 Parameter Name HADR_SYNCMODE Where This Parameter Lives Database Configuration How To Check Value > db2 get db cfg for sample |grep HADR_SYNCMODE HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC 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=’hadr_syncmode’ with ur” NAME VALUE VALUE_FLAGS DEFERRED_VALUE...

3

Adding Custom Staging Triggers

This post is focused on WebSphere Commerce, but may have some tidbits for those new to triggers too. Starting Point In WebSphere Commerce, it is not unusual for you to have to add custom staging triggers. It’s not that difficult, and there’s a good example in the Info Center, but I was doing it, so I thought I’d write a...

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

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

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

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