Category: High Availability

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

64

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