Category: Random

7

Why won’t you just die?! (Cleaning DB2 Process in Memory)

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 into a bad state and...

0

Twitter Debates

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 role never die because of...

9

A New Version of DB2 Announced!

IBM announced on April 3rd a new version of DB2. I tend to be stuck a few versions back due to what WebSphere Commerce certifies with, but I’m constantly learning about and drooling over new versions. I think many DBAs end up stuck a version or two back for longer than they would like. I haven’t actually gotten to work...

8

The Basics of Code Pages in DB2

You’ve got your database code page set as UTF-8, what more do you need to know, right? DB2 automatically handles all that conversion stuff for you, right? I’ve been dealing with significant amounts of data using UTF-8 characters that differ from the unix/linux standard code page(in the US) of 819 for the first time in a couple of years, and...

2

A Bit of Friday Fun – a Map of RDBMS Geneology

Are you ever, like me, shocked at the smorgasbord of RDBMSes that some projects seem to want to use these days? Sometimes it seems like database management systems that someone on the project’s sister’s cousin’s aunt heard of are used. A colleague of mine shared with me that a project he’s working on is using MongoDB, S3, DynamoDB, and MySQL....

3

Technical Conference – It’s a skill builder, not a trip to Vegas.

What is the first thing you think of when someone says “technical conference”? Those who have attended a few technical conferences think of hours of session material, hands on labs, networking events, and coveted swag from the vendor Expo. Those who have not attended a conference may not know what to expect. Managers, who may have been out of the...

0

Comment Spam Fail

For the first 6 months or so that I was blogging on my hosted solution, I watched the spam comments closely, looking for comments that would be falsely marked as spam. Not seeing a single one in that entire period, I stopped watching closely. Well, today, I discovered 5 comments over the last two weeks that were marked as spam...