A hub for sharing relational database knowledge and experimentation
This is part of a series focusing on the details of each item that needs to be pruned in a Commerce database.
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
Continue reading »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.
By Default, Commerce databases use Circular logging.… Read the rest
Continue reading »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
Continue reading »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 »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 »
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
Continue reading »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
Continue reading »This is part of a series focusing on the details of each item that needs to be pruned in a Commerce database.
STAGLOG
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
Continue reading »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 »So the easy thing to do on Commerce build is to use your DB2 instance owner for everything related to the database. But that’s not really the best choice. It’s almost always the choice I see when a DBA was not involved with the architecture or build of a Commerce system.… Read the rest
Continue reading »Ok, so there are several good reasons for Backing up your Commerce DB2 database
Schedule DB2 backups starting immediately after instance creation – the most common time that restores are needed is during the build process. Of course the most common cause for needing a restore is human error, but that’s something that is important to protect against during build.… Read the rest
Continue reading »