Tag: High Availability
Determining Which IP Address Db2 Connections are Connecting To
Database servers these days sometimes have a profusion of IP Addresses. IP V4, V6, management networks, and Virtual IP addresses all add to the ways applications connect in to a database server. I ran into an issue recently where I really needed to know what IP address was being used by an application, and thought I would share what I learned.… Read the restContinue reading »
RSCT APAR Affecting TSAMP
Some of my clients, instead of engaging me for day-to-day support, engage me for expert assistance only when it all really hits the fan. This issue occurred for one of those clients, who had other support performing the HADR failovers while the Linux kernel was upgraded.… Read the restContinue reading »
High Availability Options for Db2 LUW
Why Should a Database be Highly Available?
It is significantly easier to implement high availability at other levels than it is at the database level. Often the database server is one of the more powerful servers in an environment, and without some fancy footwork there can be only one live copy of data.… Read the restContinue reading »
Avoiding Inoperative Tables on the HADR Standby
HADR does an awesome job of replicating all logged operations to 1-3 standby databases. It is remarkably simple to use and pretty resilient. More than once I’ve started talking to a client about PureScale only to discover their actual high availability and/or disaster recovery needs can easily be met by a 4-server HADR implementation.… Read the restContinue reading »
Ember’s Take on Monitoring DB2 LUW
I have some very specific perspectives on monitoring DB2. In addition to regular consulting in my day job, we also provide full-service virtual DBA services, including monitoring. The monitoring we choose to do is very much under my control, and I’m constantly working on enhancements.… Read the restContinue reading »
Troubleshooting with Mickey Mouse, Snow White, and Cinderella
It’s that magical time of year again.
DBAs excitedly pack their bags for a week-long trip. On-call rotation is hurriedly passed to the next poor soul on the rotation list. Ember dons her trademark pigtails. Melanie Stopfer crams another 20 slides into and already packed presentation.… Read the restContinue reading »
Finding the Subnet Mask on AIX
This is something DB2 DBAs may need to do as a part of setting up TSAMP. Nearly every server I’ve done before has had a subnet mask of 255.255.255.0, but I ran into a server recently that wasn’t, and thought I would share how I figured out what it should be (alone, in the middle of the night, during an upgrade).… Read the restContinue reading »
Adding an Auxilliary HADR Standby to an Existing Two-Server Cluster
Mike guest blogged for me about three and four server HADR clusters before, but I want to blog about it from the perspective of adding a third server into an existing two-server cluster. Please go visit Mike’s article for a more general view of multi-standby HADR.… Read the restContinue reading »
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.
DB2 delivers many things through fixpacks, including:
- Security Fixes
- Bug Fixes
- New Functionality – though IBM goes back and forth on this
IBM delivered Native Encryption in Fix Pack 5 of DB2 10.5.… Read the restContinue reading »
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.… Read the restContinue reading »
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 earth and they need high availability.… Read the restContinue reading »