
Tag: WebSphere Commerce


Reducing Contention: Changing Default Isolation Level for Websphere Commerce (WCS)
The Problem
I often lean on analogies when I speak to non-technical people about technical topics. For example, I would explain database locking as “two kids fighting for the same candy bar”. If you introduce isolation levels into the conversation, I would expand the analogy to include “one sibling holding on to a candy bar they care nothing about just because they don’t want the other sibling getting to it”.… Read the rest
Continue reading »Improving Performance of DBCLEAN Deletes
While this post is specific to WebSphere Commerce, it covers concepts that may apply to tuning other delete statements as well.
Using Functions in the Best Place
The CLEANCONF table stores the delete statements that are used by DBCLEAN. Most of them use syntax like this for the date component:
(days(CURRENT TIMESTAMP) - days(prevlastsession)) = ?… Read the rest Continue reading »
Quick Hit Tips – CPUSPEED, RESTRICTIVE, and DB2_WORKLOAD
Today we are going to talk about some random DB2 features that can’t stand in a blog of their own, but are worth discussing nonetheless. These are tidbits I had discovered during “DB2’s Got Talent” presentations, IDUG conferences, or “Hey, look what I discovered” moments.… Read the rest
Redesigning Tablespaces in an Existing Database
Like many applications, WebSphere Commerce puts all tables in USERSPACE1
unless they need larger page sizes. This actually works just fine for smaller and midrange implementations, but we have about one build a year that requires something else – either because of standards that client DBAs adhere to or because they actually are busy enough for I/O and separate buffer pools to matter.… Read the rest
New WCS Troubleshooting Webcast from IBM
This post is specific to WebSphere Commerce.
I’m usually pretty critical of the IBM webcasts about WebSphere Commerce. There have been some pretty bad or incomplete ones in relation to WebSphere Commerce databases(“run dbclean” is the most frustrating, general advice ever).… Read the rest
Continue reading »WebSphere Commerce Instance Creation Creates Database as Wrong User
This post is specific to WebSphere Commerce.
We’ve reported this issue to IBM, but since we’ve run into it several times across more than a year, and in multiple different Fix Packs of Commerce, I thought I’d share it in case someone else runs into it.… Read the rest
Continue reading »Updated: The 10 WebSphere Commerce Tables You Should Be Familiar With
One of my most popular posts that’s specific to WebSphere Commerce is The 10 Commerce Tables You Should Be Familiar With. This is an updated version of that post, since the preferred method of dealing with attributes has changed. As a result, this post is only applicable to WebSphere Commerce 7 and above, and some of the content is identical between the two posts.… Read the rest
Continue reading »Moving WebSphere Commerce Users From One Database to Another Across Versions
This post is specific to WebSphere Commerce. In my experience, usually when Clients upgrade from one WebSphere Commerce version to another (with 6 to 7 being the current focus), they also upgrade or change DB2, the OS, the Hardware – basically everything.… Read the rest
Continue reading »NEVER drop a WebSphere Commerce base index
This post is specific to WebSphere Commerce. NEVER drop a WebSphere Commerce base index. I believe I’ve stated this in at least one previous blog entry.
But I’m always growing and learning and trying new things, and that policy was something we started back on Commerce 5.6.… Read the rest
Continue reading »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.… Read the rest
Continue reading »WebSphere Commerce Instance Creation Doesn’t Like DB2 9.7 FixPack 5
This post is specific to WebSphere Commerce. We spent a fair amount of time on this, both on a SUSE server and a Red Hat Server. The problem manifested in different ways. The main thing that became obvious to me is that Commerce was not creating the Commerce database as the dbaUser specified in createInstance.properties… Read the rest
Continue reading »