0

HADR Tools: the DB2 Log Scanner

The DB2 Log Scanner is one of three HADR tools provided by IBM on developerWorks. For more details on the other(s), see: HADR Tools: the HADR Simulator For the full technical specifications and details on using the HADR tools, see: https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/DB2HADR/ What are the HADR Tools? IBM provides three major HADR tools on a devloperWorks wiki site. The HADR Simulator...

0

LBAC – Label Based Access Control

To go with my recent article on RCAC/FGAC, I thought I would do some similar work using LBAC and see what I could learn about it and the differences between the two. What is LBAC Label Based Access Control essentially adds a column to a table that labels each row (think confidential, secret, top secret), and then grants uses of...

3

Customizing MONREPORT … or not

If you’re not familiar with MONREPORT, see my DB2 Basics entry on MONREPORT first. Most of the references I’ve seen to customizing the MONREPORT module basically say “get the code out of the database, modify it, and deploy it”. (see IBM DB2 Knowledge Center Entry on Customizing the MONREPORT module reports) I have found this rather frustrating when I’ve run...

1

DB2 Basics: MONREPORT

If you’re mourning the loss of “RESET MONITOR ALL”, there are a number of ways you can address that. Ideally, you’d use this approach: http://www.ibm.com/developerworks/data/library/techarticle/dm-1009db2monitoring1/, but there are some arguments for using MONREPORT over that in some ways. One argument is that MONREPORT is built-in and you don’t have to add objects to make it work. The disadvantages are a...

0

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 inspiration for the blog based...

2

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. RCAC consists of two major...

1

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 things that stood out most...

15

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 my actions and decisions as...

0

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 not alone, I travel in...