Category: Just for Fun

RFE_Subscribe_Roland 2

IBM’s DB2 RFE Program

RFE stands for “Request for Enhancement”. IBM has this program for a number of products, but until late 2016, the RFEs for DB2 on LUW were not publicly available to vote on. Now they are, and we’re seeing action on them. The Problem It can be frustrating to have an issue that IBM describes as “working as designed”. Sometimes these...

DSC03515 0

Funny SQL I Have Seen Lately

I’ve run across a few strange SQL statements lately, and while the mistakes they make are not the most impactful, I thought I’d share how I think they could be better written. Unnecessary use of a Common Table Expression This query isn’t really wrong, it just doesn’t make much sense. Here it is as I discovered it: with sortsnap as...

3

Happy 6th Blogiversary to db2commerce.com!

It has been 6 years since I started to blog, and about four and a half years of weekly blogging! Over that time, I have published over 460,000 words in more than 410 posts! That’s 4-8 books worth of content! I’m a whole reference shelf! Nearly 50,000 of those words were written by 6 guest bloggers: Mike Krafick Ian Bjorhovde...

file0002061413324 1

db2commerce.com Year in Review – 2015

Site Stats 2015 was again a record year for db2commerce.com. This year saw over 380,000 page views, which is more than 100,000 more than last year! I expect next year to not be such a drastic increase because my traffic has been fairly even through this year instead of the rapid series of upward steps I’ve seen in previous years....

3

Who/What I’m Thankful for in the DB2 Community

It is a busy time of year for DBAs. Many of us will put in a large number of hours between Friday and Monday keeping ecommerce databases running and our company’s profits rolling. But it’s also a time of year in the USA where we take a moment to be thankful for the things around us and make sure that...

_zlShuKV-36AkWovrKXscdxg3q6FmE8CDYOPVjs6AyQ 1

Insight 2015 Brain Dump

I call my post-conference blog posts brain dumps because that is largely what they are – information formatted in a way my brain understands but not necessarily as thoroughly organized and researched as you might be used to seeing from me. Conference Generalities Overall Themes I sure wish that DB2 was more highlighted overall, but I’m sure that’s largely a...

1

Looking Forward to IBM Insight 2015

IBM Insight starts in less than two weeks! You can still register and attend if you haven’t planned to already! General Tips Website If you haven’t registered already, check out the IBM Insight website for information. I’ll be linking to specific pages throughout this post. Attire This is the third year I’m going to IBM Insight (well the first year...

3

Happy 5th Blogiversary to db2commerce.com!

This week marks the 5th blogiversary of db2commerce.com! Wow, 5 years! A few statistics: Total posts published (including guest bloggers): 384 Years of averaging one or more posts per week: 3.5 (started in 2012) Total words published (including guest bloggers): 401,245 Longest post: 13,043 words (HADR Tools: HADR Calculator) Shortest post: 27 words (DB2 Haiku – Building Skills) Words published...