Skip to content

DataGeek.blog

Db2 Experts on a Data Science Quest

Search
  • Home
  • About
  • Bloggers
  • Privacy Policy
  • Ask Ember A Question
  • Donate
  • English
  • Español

Tag: Db2

March 4, 2011 Uncategorized

The role of the DBA in supporting WebSphere Commerce

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 »
March 2, 2011 Uncategorized

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 »
March 1, 2011 Uncategorized

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 »
February 28, 2011 Uncategorized

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 »
February 25, 2011 Uncategorized

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 »
February 17, 2011 Uncategorized

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 »
July 16, 2010 Uncategorized

I tried Data Studio, I really did.

The attempt to like a GUI falls flat again. Continue reading »
July 14, 2010 Uncategorized

Popping the Stored Procedure Cherry

A first experience with creating stored proceedures. Continue reading »
June 16, 2010 Uncategorized

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 »
June 15, 2010 Uncategorized

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 »
June 7, 2010 Uncategorized

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 »
June 4, 2010 Uncategorized

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 »

Posts navigation

«Previous Posts 1 … 40 41 42 43 Next Posts»

Search

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy