Category: WebSphere Commerce Specific

ChocolateFace 0

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

0

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)) >= ? Every time I see...

13

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. CPUSPEED (Database Management Configuration) You blow past this setting every time you execute “db2 get...

9

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

0

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). So I went into the one I listened to on Tuesday with low expectations. When billable hours are on...