Category: Commerce Data Model

1

Example of A Clustering Low-Cardinality Index Helping Query Performance

The request from the developers was something along the lines of “Help, Ember, this query needs to perform better”. Sometimes the query I’m working on is not one that shows up as a problem from the database administrator’s perspective, but one that is especially important in some part of application functioning. In this case, this query is related to the...

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

STGMENBR and Stagingprop Failure

This post is specific to WebSphere Commerce. I ran into a new stagingprop failure today(which doesn’t happen all that often anymore), and it taught me something about custom staging triggers, too. What this Error Looks Like Stagingprop fails, and a message such as this this in the stagingprop log. (Tue Oct 02 09:51:44 EDT 2012) The sequence of the following...

2

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. So I noticed within the last 6 months the following statements in the...