So many times it appears that a database expert is not engaged with the Commerce Architecture. This generally means that your Commerce database is on the root filesystem (eek!) and using circular logging. There’s more than that you should change…
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…
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…
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…
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…
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,…
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…
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…
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…
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…
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…
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…