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 [...]
{ 0 comments }
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: [...]
{ 2 comments }
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, [...]
{ 2 comments }
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) [...]
{ 0 comments }
We bandy about the term “online” reorg. But you’d be surprised how often there are issues with that. IBM officially calls it an “INPLACE” reorg. Read on to understand exactly when it is fully online and when it is not. Truncation When we first got our hands on online reorgs, it seemed like the “INPLACE” [...]
{ 3 comments }
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 [...]
{ 4 comments }
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. [...]
{ 0 comments }
[This article is based off the "Attack of the Blob" DB2 Night Show webcast held on Friday April 26, 2013 at 11am EST.] I would love to say that the biggest technical challenge of my career was some massive data warehouse or an OLTP database with an insane number of transactions per second. Heck, I’ve even [...]
{ 0 comments }
It happens. We joke that it doesn’t. Make sure not tell our Oracle or SQL Server counterparts but occasionally DB2 becomes … How do I put this eloquently? Hosed. Snarled. Non-functional. Zombied (think the “Walking Dead” TV show). Dorked. Sometimes there is a memory leak, instance level crash, trap, or OS issue. DB2 just goes [...]
{ 2 comments }
Twitter debates. I’ve never been in one, nor have I actually heard of them until yesterday. But when @DB2Geek hosted a debate on Tuesday, I decided to pop on and see what it was all about. (Search for hashtag #db2debate). It was fascinating. Did automation steal the role of DBA or minimize it? Will our [...]
{ 0 comments }
