Category: Commerce Data Model

2

Mass Cleanup of Guest Users

By special request, I’m going to share some details on how to do a one-time offline clean up of guest users. PLEASE NOTE: Following are suggestions only – it is critical to thoroughly test this before doing  this in production. This is one of the most tested and still most failed changes I do. First off, check out the entry on...

25

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...

0

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. I think you’ll have to login with...

3

Data Movement Options for Commerce Databases – Synchronizing Data Between Commerce Environments

So one of the most common questions I get is about moving data between homogenous Commerce databases. Our standard setup includes 4 environments – Dev, QA, Stage, and Prod. Dev/QA are a stagingprop pair, Stage/Prod are a stagingprop pair, and Prod usually has HADR. So with 4 environments, they can get out of sync. For the most part, business users are making...