Db2 Blog Posts

Migrating a Db2 DPF Instance from rsh to ssh

Db2's Database Partitioning Feature (DPF) allows a single Db2 instance to span multiple physical servers — allowing a single Db2 database to scale out to sizes well beyond what is possible on a single physical server. To manage a DPF environment, Db2 needs to be able...

read more

Validating VIP Usage

Recently, I was working on a database using HADR with failover handled by TSAMP. The database was configured to use a virtual IP (VIP) address. However, when I tested the failover with the application team, some of the applications were getting SQL1776N errors from...

read more

Writing SQL with SQL

The Db2 RDBMS offers many great tools for getting things done. There are, however, times when tools are unavailable. This isn’t a problem when you’re performing a simple and discrete task. When the task has many iterations then like dropping triggers or granting...

read more

Setting Up HADR with Two Auxiliary Standbys

In my previous blog, I presented some of the issues you can run into when setting up one auxiliary HADR standby and a potential solution. This blog discusses setting up two auxiliary standby databases in detail. Let's start with all the information we need to set the...

read more

Speak with an Expert DBA now!

Call: (888) 685-3101 ext. 2 or fill out the form below