Category: High Availability

2

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/ What are the HADR Tools? IBM provides three major HADR tools on a devloperWorks wiki site. The HADR Simulator is...

0

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/ What are the HADR Tools? IBM provides three major HADR tools on a devloperWorks wiki site. The HADR Simulator...

1

HADR Tools: the HADR Simulator

I have not made extensive use of the HADR Tools that IBM offers in the past. Most of my HADR setups to date have either been same-data-center using NEARSYNC or have used ASYNC to copy data between data centers. I haven’t had much cause to tweak my network settings or change my SYNCMODE settings based on hardware/networking. However, I have...

0

Another TSA State Issue

One of the features I would most like IBM to add into DB2 is the managing of TSA States through DB2 commands. I’m not a TSA expert, but I would like to find a class or opportunity to study it further. There are plenty of scenarios where I have to go in as root and run various commands to get...

2

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

0

High Level Overview of Reads On Standby

With DB2 9.7 Fixpack 1, IBM started supporting reads on the HADR standby. This was a bit of an exciting feature for some of us. But in practice there are enough restrictions that it ends up not being an option that many clients choose. Reporting Server The main thing my clients want from this feature is to be able to...