On December 12th, I’ll be presenting on the DB2 Night Show on HADR and TSAMP Advanced Topics. Sign up here: http://www.dbisoftware.com/db2nightshow/

Giving Thanks in the DB2 Community

It's Thanksgiving in the US. This is a time to stop and reflect on what I'm thankful for in my life, and a big part of that is the DB2 community for me. Here's who and what I'm thankful for in the DB2 community this year: My new employer, Xtivia. I have a wealth of [...]

Using LISTAGG to Turn Rows of Data into a Comma Separated List

This is a topic I have to look up from time to time, and I always go straight to Serge Rielau's blog. He has a number of good articles on LISTAGG, the similar XML specific functions, and much more. While he's already covered the topic in great detail, I thought I'd add my own way [...]

DB2 Fine-Grained and Row Access Control (FGAC/RCAC)

DB2 10.1 introduced a new feature commonly called RCAC (Row and Column Access Control) or FGAC(Fine-Grained Access Control). This is a bit less labor intensive to support than LBAC (Label Based Access Control), and solves some of the problems with LBAC. It allows a finer level of access control than the standard DB2 permissions scheme. [...]

DB2 Explain Output in Another Format

I'm always keeping an eye on Twitter to catch interesting bits of news, and that includes watching cross platform information. I find it fascinating to compare DB2 to other RDMBSes, and saw a great article from Use the Index, Luke (fabulous name!) - Seven Surprising Findings About DB2. I'd recommend reading it. One of the [...]

DB2 Internals: Simple Query Processing

Edited 11/13/2014 to be more specific about coordinator agents. This is the first in a series of blog entries talking about DB2 internals. I have no intimate knowledge from IBM of how DB2 works internally, just years of watching presentations about the internals and doing my best to understand what DB2 is doing to inform [...]

Mike’s IDUG Prague Technical Conference Preview

For me, it’s 1:00am. But for those who hustle and bustle around the airport in Amsterdam it’s 7:00am and time to start the day. It’s an exciting experience for me, traveling internationally for only the second time in my life, as the winner of the DB2 Night Show’s “DB2’s Got Talent” competition. But I am [...]

IBM Insight 2014 – Brain Dump

Whew, what a week. I'm coming out of the conference with at least 20 ideas for new blogs, including a new "Internals" series that I want to work on. I call this post my Brain Dump as I share out random things I learned and ideas. For me, the conference started on Saturday. As an [...]

DB2 Basics: Backups of Data and Configuration

Backups are so ingrained into DBAs. They should really be the first and the last thing we think of and ensure we do properly. We do regular backups so we can get data back in case of some failure, be it human, software, or hardware. We do ad-hoc backups before and after upgrades or fixpacks, [...]

Options to Encrypt Data at Rest in DB2

I thought it would be relatively easy to investigate encryption for our environment. I was wrong, was just plain confusing. This was not because encryption is complicated per se, but that a DBA really needs to have a good understanding of business needs. If you don’t have this understanding, you can get lost in an [...]

Looking Forward to IBM Insight

IBM's Insight conference (the conference formerly known as IOD or Information On Demand) is next week in Las Vegas. It's a large conference that covers more than just DB2, but it is still DB2 geek heaven. I'll be there - stop me to chat if you see me, I love to talk tech with anyone. [...]