So this is a good page in the Commerce info center. It sets forth naming standards for custom objects in WebSphere Commerce databases. I know for a fact that other naming standards work in daily operation. I wonder if using these naming standards makes upgrades go more smoothly (or like some Commerce features that is an intended future use of these).… Read the rest
Continue reading »Tag: WebSphere Commerce
The WebSphere Commerce Data Model
So I have several posts already on this topic. It’s a big topic, and I imagine I’ll write many more posts on it. But I thought something kind of general would be good.
I’ve talked about 10 Commerce Tables You Should Be Familiar With, and about making alterations to Commerce objects, and about general observations about Commerce databases.… Read the rest
Continue reading »Websphere commerce database design observations
When you’ve worked with commerce databases for a while there are some design aspects that become obvious.
First, nearly every table has a generated key. Often, but not always, that key is used as the primary key. Most frequently, the column name is the table name with _ID appended.… Read the rest
Continue reading »10 Commerce Tables you should be familiar with
UPDATE: An updated version of this post is available – Updated: 10 WebSphere Commerce Tables You Should Be Familiar With
So there are 800+ tables in the typical Commerce database – you’re never going to know them all. And getting a start on understanding the data model – even in the more limited way needed when you’re playing primarily the system dba role can be daunting.… Read the rest
Continue reading »IBM’s Introduction to the WebSphere Commerce Database for DB2 Administrators
So I thought I’d share the best thing I’ve seen out of IBM on Commerce DB2 information on the Commerce database. There are obviously things that aren’t in this presentation, but it’s decent for the time allotted and I learned stuff from it back when I listened to it live in August 2010.… Read the rest
Continue reading »WebSphere Commerce – Oracle or DB2
So I’m obviously biased on this. I’ve been a DB2 DBA for 10 years and believe in DB2 very strongly. Some of my biases against Oracle may be completely unfounded. I’m actually learning Oracle so I can support clients who insist upon using it.… Read the rest
Continue reading »The role of the DBA in supporting WebSphere Commerce
I have generally been a bit disappointed on the information coming out of IBM on supporting Commerce databases. I also meet clients who don’t believe they need a dba or that they can hire someone out of college or with minimal database experience to fill such a role.… Read the rest
Continue reading »Instance Creation in WebSphere Commerce 7 (DB2 9.5)
SQL30082N Security processing failed with reason "42" ("ROOT CAPABILITY REQUIRED"). SQLSTATE=08001
Continue reading »