Category: High Availability

4

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

10

10 Minute Triage: Assessing Problems Quickly (Part 2)

(For Part 1 of this series, please click 10 Minute Triage: Assessing Problems Quickly, Part 1). One of my favorite commercials is from a motor oil company. The scene begins with a man who is sleeping soundly. His slumber ends abruptly when he is physically grabbed by the collar, shoved on a treadmill  and forced to run in an all...

16

10 Minute Triage: Assessing Problems Quickly (Part 1)

To eliminate any confusion – I am not Ember. Ember is a little shorter, with a big smile, and glasses. I was lucky enough to meet her through a mutual friend at the IDUG 2012 Conference in Denver just a few weeks ago. After enough networking events and sessions, we found we had similar technical backgrounds and began swapping stories....

1

Parameter Wednesday – DB CFG – HADR_PEER_WINDOW

Edited 9/6 to correct syntax and Grammar. DB2 Version This Was Written For 9.7 Parameter Name HADR_PEER_WINDOW Where This Parameter Lives Database Configuration How To Check Value > db2 get db cfg for sample |grep HADR_PEER_WINDOW  HADR peer window duration (seconds)  (HADR_PEER_WINDOW) = 0 OR > db2 “select name, substr(value,1,16) value, value_flags, substr(deferred_value,1,16) deferred_value, deferred_value_flags, substr(datatype,1,16) datatype from SYSIBMADM.DBCFG where...

0

What is an e-commerce database?

So believe it or not, when I was a newbie dba doing the very basics on internal databases at my first job, I didn’t even know what some of the databases I supported did. I learned over time, but sometimes it was months before I knew or understood. That wouldn’t happen with my current level of experience, but that’s how...

66

HADR

What is HADR? HADR is DB2’s implementation of log shipping. Which means it’s a shared-nothing kind of product. But it is log shipping at the Log Buffer level instead of the Log File level, so it can be extremely up to date. It even has a Synchronous mode that would guarantee that committed transactions on one server would also be...