I have generally been a bit disappointed on the information coming out of IBM on supporting Commerce databases. I also meet clients who don’t believe they need a dba or that they can hire someone out of college or with minimal database experience to fill such a role.… Read the rest
Continue reading »Tag: Db2
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.… Read the rest
Continue reading »Never do runstats on volatile tables
Ok, so everyone will tell you that it doesn’t matter if you do runstats on volatile tables. The volatile flag is supposed to tell DB2 that the statistics are absolutely not correct, and heavily bias db2 to use indexes over table scans.… Read the rest
Continue reading »DB2 and Transparent LDAP
Ok, so I know I’m in the middle of a multi-part post on Data Movement between Commerce databases (and I will get back to that), but I found this and had to share it because I’m so excited DB2 has finally added support for it.… Read the rest
Continue reading »Data Movement Options for Commerce Databases – Creation of staging database during build
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 »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 »