DB2 Databases – the Basics of Storage

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…

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…

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…

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,…

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…

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…

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…