Category: Build

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

6

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

2

Cloning a DB2 Database Server

I’ve built new servers in half a dozen different ways. One of the ways most favored these days, especially by the other Engineers on my team is cloning. Whether it’s an Amazon EC2 copy or VM Ware that you’re using, some method of taking an image of an existing server and turning it into a new server seems to be...

2

Using TSA/db2haicu to Automate Failover Part 3: Testing, Ways Setup can go Wrong and What to do.

Part 3 in this series is a bit overdue. Parts 1 and 2 were back in April. This is a complicated topic. Please use any procedures here with extreme care, and keep in mind that if you have anything other than the standard two-server HADR-only TSA implementation, these procedures probably aren’t the best idea, as they could break other things....

5

DB2 Commands: db2licm

Managing DB2 licenses isn’t exactly the glory work of DB2. It’s not fun, and the only scenario you might come out of messing with them with Kudos is if you’re dealing with an expired Try&Buy license – and then only if it’s someone else’s fault there was a Try&Buy in the first place. Licensing as a whole can be confusing,...

0

DBI1306N when trying to use db2set

This was a new one for me, so I thought I’d write up a quick blog entry on it. After creating a new instance and a new database, and even after executing one db2set command successfully, I got this: > db2set DB2_CAPTURE_LOCKTIMEOUT=YES DBI1306N The instance profile is not defined. Explanation: The instance is not defined in the target machine registry....

1

Installing DB2 Using a Response File

Some friends on Twitter were commenting that db2_install is not just deprecated in DB2 10, but is fully discontinued and not available. Melanie Stopfer mentioned this on her webcast on June 22. I do dozens of installs a year, and most of them are using a response file. The same response file, actually, since a standard starting point makes sense at...

0

db2val – Validating your Install

I’m constantly discovering new features. You’d think at this point that I’d know the contents of the /opt/IBM/db2/V9.7/bin directory by heart. Especially since I intentionally went through everything in there when deciding on one of the topics for the db2Night Show’s DB2’s Got Talent competition. But today when dealing with a borked database, I found a new one. What is db2val...

2

WebSphere Commerce Instance Creation Doesn’t Like DB2 9.7 FixPack 5

This post is specific to WebSphere Commerce. We spent a fair amount of time on this, both on a SUSE server and a Red Hat Server. The problem manifested in different ways. The main thing that became obvious to me is that Commerce was not creating the Commerce database as the dbaUser specified in createInstance.properties file, but was instead using the...