April 11, 2011 Uncategorized

DBClean Performance

This is a really complicated topic, largely because dbclean is such a varied tool, and because the data distribution in Commerce databases varries heavily based on how you use it. If you haven’t already, check out my blog entry on dbclean basics.… Read the rest

April 8, 2011 Uncategorized

db2ckbkp

So I generally write my posts a day ahead and schedule them to be posted mid-morning when I think people would be around to see the tweets or other indications there’s a new post. But I was sick yesterday. So it probably looked to my employer like I was posting on my blog when I was too sick to work, but whatever – I actually schedule multiple days ahead when I get a writing bug.… Read the rest

April 7, 2011 Uncategorized

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

April 6, 2011 Uncategorized

DBClean – Guest Users

This is part of a series focusing on the details of each item that needs to be pruned in a Commerce database.

Guest Users

What is it?

Guest Users are created by Commerce in the database. Technically they are only needed for when you allow a customer to add items to their cart before logging in or registering, or for a few other actions.… Read the rest

April 5, 2011 Uncategorized

How to determine your backup/recovery strategy

Determining your backup strategy for a Commerce DB2 database is much like determining your backup strategy for any other db2 database. There really aren’t any special considerations for Commerce that you wouldn’t have for another database.

Logging Method

By Default, Commerce databases use Circular logging.… Read the rest

April 4, 2011 Uncategorized

HADR

What is HADR?

HADR is DB2’s implementation of log shipping. Which means it’s a shared-nothing kind of product. But it is log shipping at the Log Buffer level instead of the Log File level, so it can be extremely up to date.… Read the rest

April 1, 2011 Uncategorized

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

March 31, 2011 Uncategorized

SQL0569 on Feature Pack – or any other time, really

Ok, so this is an issue I ran into recently. The Commerce guys were trying to install a Feature Pack, and got this:

SQL0569N  Authorization ID "<authorization-name>" does not uniquely
identify a user, a group or a role in the system.

… Read the rest Continue reading »

March 30, 2011 Uncategorized

The Least you can do for DB2 Performance

I suspect there are some sites out there where a “set-it-and-forget-it” approach is taken for DB2 related performance. Many clients we go into don’t even realize the need for having a DBA. Depending on site size, that may work for a while.… Read the rest

March 29, 2011 Uncategorized

Stagingprop – the basics

I realized today that I haven’t done a post on the basics of stagingprop. All the pieces are there somewhere in the info center, and I love the info center once you’ve got the basics down, but I remember how confusing stagingprop was when I first started out, even though I had a major expert on the topic to ask questions of.… Read the rest

March 28, 2011 Uncategorized

DBClean – staglog

This is part of a series focusing on the details of each item that needs to be pruned in a Commerce database.

STAGLOG

What is it?

Staglog is a table in the staging database that records changes in data. Staging triggers on all stagingprop tables write to it when there is a change to any of those tables.… Read the rest

March 25, 2011 Uncategorized

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

DataGeek.blog

Comparing Db2 and MySQL: Explain

Comparing Db2 and MySQL: NULL in Indexes

Comparing MySQL and Db2: Table and Index Structure

The Most Shocking Differences I’ve Seen Between Db2 and MySQL (so far)

DBA Perspective: Open Source vs. Proprietary RDBMS

My Early Experience Learning MySQL as a Db2 DBA

A New Turn in Ember’s Career

The DBA is Dead? No, the DBA as Gatekeeper is Dead!

DBClean Performance

db2ckbkp

10 Commerce Tables you should be familiar with

DBClean – Guest Users

Guest Users

What is it?

How to determine your backup/recovery strategy

Logging Method

HADR

What is HADR?

IBM’s Introduction to the WebSphere Commerce Database for DB2 Administrators

SQL0569 on Feature Pack – or any other time, really

The Least you can do for DB2 Performance

Stagingprop – the basics

DBClean – staglog

What is it?

WebSphere Commerce – Oracle or DB2