Category: High Availability

DSC04677 2

DB2 Basics: Patching DB2

Like any software, DB2 requires frequent patching. A database should be one of the most secure parts of any enterprise, and keeping it secure means keeping up with the fixes that are delivered in fix packs. Fix Packs DB2 delivers many things through fixpacks, including: Security Fixes Bug Fixes New Functionality – though IBM goes back and forth on this...

2

TSAMP Issue on Fixpack

As always, when I feel pain, I share the knowledge that pain gained me with my blog readers. Man, that was a painful fixpack. I was upgrading an AIX HADR pair from 10.5 fixpack 3 to 10.5 fixpack 5. My experience has generally been that TSA is painful when patching DB2. Problem Description In this case, I was not patching...

1

Going Beyond 2 Servers – HADR as a High Availability/Disaster Recovery option.

When the client considers high availability and disaster recovery, they often do not know what they are talking about. Many times the client may be dropping buzzwords like “five nines”. To them this is the definition of disaster recovery. In other cases, they are thinking of a worst-case scenario where a whole data center falls off the face of the...

Screenshot_091415_065147_PM 3

Ongoing Support of DB2’s HADR

There are some things to be aware of with ongoing support of a HADR system. I thought I’d group them together to provide a primer of do’s and don’ts for support of HADR. Monitoring HADR HADR does occasionally stop all by itself. Also, system events can cause it to not be active. For these reasons, it is critical that you...

Pavan 2

Automatic Bufferpools in DB2 HADR

In this blog post, I will share what I learned about DB2 automatic bufferpools when using HADR. Problem: In a DB2 10.5 (fp3a) HADR environment, during heightened database activity on the primary database, there was delayed log replay on principal standby database. The HADR_SYNCMODE was set to SYNC. Primary and Standby database servers were in the same data center. HADR_SYNCMODE...

6

Architecting High-Availability and Disaster Recovery Solutions with DB2

NOTE: Please do not attempt to architect a high-availability solution without a DB2 expert involved. There are many questions and answers needed beyond those here to make the best decision and ask all the tough questions. High Availability vs. Disaster Recovery High Availability and Disaster Recovery often have different goals and priorities. High Availability can be considered the ability to...

4

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