On December 12th, I presented on the DB2 Night Show on HADR and TSAMP Advanced Topics. See the replay here: http://www.dbisoftware.com/blog/db2nightshow.php?id=531

Troubleshooting Table with Failed Load (SQL0668N)

I recently had a client with a table in an inconsistent state. Apparently a load failed, which is common enough, but they then tried to do a reorg, thinking that would solve it, so I first had to identify and force off connections causing a lock chain before solving the root problem. There were a [...]

HADR Tools: HADR Calculator

The HADR Calculator 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/ IBM provides three major HADR tools on a devloperWorks wiki site. The HADR Simulator is [...]

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/ IBM provides three major HADR tools on a devloperWorks wiki site. The HADR Simulator [...]

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. Label Based Access Control essentially adds a column to a table that labels each row (think confidential, secret, top secret), and then grants [...]

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 [...]

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 [...]

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 [...]