Author: Ember Crooks

5

Check Out the New db2commerce.com Site Design!

You may have noticed that I have updated the site design for db2commerce.com. Check it out and let me know if you find any problems or have any suggestions. Web design is not my first line of work, but I’m pleased with how it came out. I went live with the new design late last week after some helpful input...

2

SQL Tip: COALESCE

I haven’t generally been known for my SQL tips. I can find my way around SQL decently enough, but for years, I didn’t do much of it. I’ve used it more and more as the years have gone by as I have moved out of a stictly physical/system DBA role and into a more mixed role where I interact and...

2

WebSphere Commerce Instance Creation Creates Database as Wrong User

This post is specific to WebSphere Commerce. We’ve reported this issue to IBM, but since we’ve run into it several times across more than a year, and in multiple different Fix Packs of Commerce, I thought I’d share it in case someone else runs into it. The main way it manifests initially is like this: /configureWorkspaces.xml:245: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:...

3

What to do with a Character you Cannot Query

This post comes out of one of the more challenging technical problems I have encountered recently. Problem Description An international client went live recently. We did the work of building their new WebSphere Commerce 7 website, and go-live involved loading some data from their old site. I’m not sure exactly how that load was done, but I suspect massload (a...

0

IDUG NA 2013 Pictures

Ok, this is the last post focused on IDUG NA 2013. I posted something deeply technical yesterday, didn’t I? I wanted to share some pictures from the conference. I snaged these from various Twitter and Facebook posts, so thanks everyone who took pictures. Scott Hayes, Dan Luksetich, Kurt Struyf, and Me (taken by Kelly Fitzgerald) Me with JB, Rebecca Bond,...

5

IDUG NA 2013 Brain Dump

Wait, don’t avoid reading this because you didn’t go to the conference. There is still valuable stuff here. In fact, it is even more valuable for those who did not go. Last year, I posted my brain dump by basically re-writing all of my paper notes. This year, I’m going to try to make it a bit more organized. It...

0

IDUG Orlando (yet another post)

I know that every DB2 blogger out there is writting their posts about IDUG and what excites them about it and what their plans are. But I’m going to write my own post anyway to let my readers know what I’m excited about and where I’ll be. First off, I love to meet my readers. It totally makes my day...