Db2 Blog Posts

Is it Safe to Drop a Tablespace?

When IBM switched from old-school DMS and SMS tablespaces to Automatic Storage tablespaces, it became significantly easier for DBAs to create and manage tablespaces. This can lead to a proliferation of tablespaces; over time, some of these tablespaces may no longer be...

read more

Finding the Size of Individual Indexes

Recently I had a client ask me if there was a way to calculate the size of individual indexes on a table and how to interpret what is reported by the table function sysproc.admin_get_index_info. The client asked whether the value is reported as a sum per table or per...

read more

The Importance of /etc/hosts on Db2 Systems

Recently, I was working on a system and noticed some odd behavior – running a simple db2pd command was taking what felt like a "long" time. I used the time utility to validate my impression: db2inst1@db2server $ time db2pd - Database Member 0 -- Active -- Up 0 days...

read more

How and When to Run the db2chgpath Utility

Recently while applying a fixpack, I encountered this error: ERROR: An error occurred while setting DB2 runtime path. Contact a technical service representative. Setting DB2 library path :.......Failure DB2 Fix Pack Update log file finished at: Sat Aug 1 18:23:29 2020...

read more

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

Speak with an Expert DBA now!

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