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 out sprint from a cold start to prove a point about the abuse we give our cars in the morning.… Read the rest

Continue reading »

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
Read the rest Continue reading »

Using TSA/db2haicu to automate failover – Part 2: How it looks if it goes smoothly

This is my second post in my TSA/db2haicu series. The first porst, Using TSA/db2haicu to automate failover – Part 1: The Preparation, is a must-read before trying anything lined out in this post.

What You Should Have Ready After Part 1 of the Series

If you’ve done the preparation properly, you have the following already defined/done:

  1. HADR is set up and running, using hostnames(either fully qualified or short names)
  2. Properly configured Hosts file
  3. preprpnode run on both servers
  4. Public IP addresses for both servers
  5. Fully qualified host names for both servers
  6. IP Address of the Quorum Device
  7. (Optional) Virtual IP address and Subnet mask of that VIP
  8. (Optional) Private IP addresses if they’re being used

In our example, I’ll be using:

  • Fully qualified host names for both servers:
174.13.101.192  
Read the rest Continue reading »

Holiday Preparation

What do you do to prepare for the holidays? We’re starting to think about Black Friday for our retail clients in September or maybe even August. Each business has its Black Friday equivalent – the few days each year that account for 5%(or more) of your online revenue for the year – even if they aren’t anywhere near November.… Read the rest

Continue reading »

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.… Read the rest

Continue reading »