HADR_TIMEOUT vs. HADR_PEER_WINDOW

It has taken me a while to fully understand the difference between HADR_TIMEOUT and HADR_PEER_WINDOW. I think there is some confusion here, so I’d like to address what each means and some considerations when setting them. In general, you’ll only need HADR_TIMEOUT when using HADR and only need HADR_PEER_WINDOW when using TSA(db2haicu) or some other automated failover tool.… Read the rest

Continue reading »

When is a Reorg Really Online?

We bandy about the term “online” reorg. But you’d be surprised how often there are issues with that. IBM officially calls it an “INPLACE” reorg. Read on to understand exactly when it is fully online and when it is not.

Truncation

When we first got our hands on online reorgs, it seemed like the “INPLACE” keyword was all we needed, and we had availability during reorg – that any they required less disk space at one time.… Read the rest

Continue reading »

IDUG NA 2013 Brain Dump

Wait, don’t avoid reading this because you didn’t go to the conference. There is still valuable stuff here. In fact, it is even more valuable for those who did not go. Last year, I posted my brain dump by basically re-writing all of my paper notes.… Read the rest

Continue reading »

TSA/db2haicu error and resolution

Especially with TSA and db2haicu, sometimes you see an error, and you have a bag of tricks that you try, even though you don’t understand exactly why they work. In this case, I had a brand-spanking-new server, with DB2 installed the very same day, and no matter what I did, db2haicu would fail on creating the domain with this error message in the diag.log:… Read the rest

Continue reading »

Using TSA/db2haicu to automate failover Part 4: Dealing with Problems After Setup

Updated March 2019 with the command to get the first output

Most of what you’ll need to set up and test TSA using db2haicu is in my first few posts on the topic:
Using TSA/db2haicu to automate failover – Part 1: The Preparation
Using TSA/db2haicu to automate failover – Part 2: How it looks if it goes smoothly
Using TSA/db2haicu to Automate Failover Part 3: Testing, Ways Setup can go Wrong and What to do.Read the rest

Continue reading »

Three HADR Failures

When you move DB2 servers from one hosting provider to another, you have to re-do hadr. Along with another DBA, I had 6 production databases across 3 instances to move last Saturday night, along with the HADR databases. The entire change had been tested ahead of time at least once, and probably more like 3 times, with no hiccups.… Read the rest

Continue reading »

Using TSA/db2haicu to Automate Failover Part 3: Testing, Ways Setup can go Wrong and What to do.

Part 3 in this series is a bit overdue. Parts 1 and 2 were back in April. This is a complicated topic. Please use any procedures here with extreme care, and keep in mind that if you have anything other than the standard two-server HADR-only TSA implementation, these procedures probably aren’t the best idea, as they could break other things.… Read the rest

Continue reading »