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…

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…

DB2 for Commerce IDs

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…

When to Backup your DB2 database

Ok, so there are several good reasons for Backing up your Commerce DB2 database After Commerce Instance Creation As required by your overall ongoing backup and recovery strategy Before a FixPack(DB2 or Commerce) or Feature Pack(Commerce) After a FixPack(DB2 or…

Build Tip – DB2 Backups

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…