Category: High Availability

1

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

5

IDUG NA 2013 Brain Dump

Wait, don’t avoid reading this because you didn’t go to the conference. There is still valuable stuff here. In fact, it is even more valuable for those who did not go. Last year, I posted my brain dump by basically re-writing all of my paper notes. This year, I’m going to try to make it a bit more organized. It...

0

TSA/db2haicu error and resolution

Especially with TSA and db2haicu, sometimes you see an error, and you have a bag of tricks that you try, even though you don’t understand exactly why they work. In this case, I had a brand-spanking-new server, with DB2 installed the very same day, and no matter what I did, db2haicu would fail on creating the domain with this error...

0

Guest Bloggers Next Week!

The week of December 17th, I’ll be welcoming guest bloggers once again. Mike Krafick, who did a couple of guest blogs for me earlier in the year (10 Minute Triage: Assessing Problems Quickly (Part 1) and 10 Minute Triage: Assessing Problems Quickly (Part 2)) is teaming up with a great SA to bring us great details on using DB2 with...

0

Three HADR Failures

When you move DB2 servers from one hosting provider to another, you have to re-do hadr. Along with another DBA, I had 6 production databases across 3 instances to move last Saturday night, along with the HADR databases. The entire change had been tested ahead of time at least once, and probably more like 3 times, with no hiccups. But...

10

How to Disable ASLR and Why you Should do it

Update: Oct 28, 2013 – the below applies only to DB2 before DB2 10.1 Fixpack 3. IBM says that ASLR can safely be used with DB2 on 10.1 Fixpack 3 and later. See the technote at http://www-01.ibm.com/support/docview.wss?uid=swg21365583. FixPack 3 was released on September 27th. Also, please see comment from a reader at the bottom about the security implications of disabling...