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.… Read the rest
Continue reading »Tag: Db2
Stagingprop – SQL0803 – a rarer cause
I went through the most common cause of SQL0803 back in a previous post. There’s a rarer cause that can look very similar, and I thought I’d detail it.
What this problem looks like:
The following appears in the stagingprop log.… Read the rest
Continue reading »I tried Data Studio, I really did.
The attempt to like a GUI falls flat again.
Continue reading »
Popping the Stored Procedure Cherry
A first experience with creating stored proceedures.
Continue reading »
Stagingprop – SQL0803 “oops, you inserted data directly on production”
So I plan to go through some of the stagingprop problems I've seen - especially the more common ones. This is probably the most common of all, especially if the java developers you're working with have not used Commerce and particularly stagingprop before.
Continue reading »
Stagingprop – the high-level explanation
So every client I support has issues with stagingprop at some point. The vast majority of them are due to mistakes made in the development process. Many developers do not fully understand what stagingprop does, so here's a general description that might help.
Continue reading »
Registry Variables and DB2_WORKLOAD=WC
I was happy to see the new workload registry variable in Commerce 7/DB2 9. Mostly out of laziness – it requires fewer variables to be set manually, but it also ensures that nothing major is missed (I imagine they may come up with more that won’t be added to the workload registry variable in real time).… Read the rest
Continue reading »I’m just this guy, you know?
I'm just this guy, you know? Ok, so I'm female, but I don't work for IBM and I'm not trying to sell you anything.
Continue reading »
Sticky, gluey, GUIs
DB2 GUIs Suck for a variety of reasons - use the command line.
Continue reading »
Fun with IN-lists and GENROW
IN-lists are poor performers. Here's what they look like in explain plans and why they perform poorly.
Continue reading »
5 things that made me a better DBA
Several times I've figured things out in my career and thought "how did I ever call myself a DBA without knowing that?"
Continue reading »
Instance Creation in WebSphere Commerce 7 (DB2 9.5)
SQL30082N Security processing failed with reason "42" ("ROOT CAPABILITY REQUIRED"). SQLSTATE=08001
Continue reading »