Ian Bjorhovde

Lead Db2 DBA and Delivery Manager

Ian Bjorhovde is the Lead Db2 DBA and Delivery Manager for XTIVIA, and is based in Phoenix, Arizona. He has spent over 20 years as a consultant developing and supporting large and small Db2 databases for clients in many different industries.Ian is an IBM Gold Consultant and IBM Champion. He volunteers for the International DB2 Users Group and holds numerous DB2 certifications. He hosts the Create Database podcast, co-hosts The Whole Package Cache Podcast, and has presented at many RUG, IDUG and IBM conferences around the world.

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

Terminating Db2 Backups to a Vendor Media Server

Sometimes, while running a database backup or restore, you may encounter a situation where you need to terminate the backup or restore operation. If the backup is writing to disk, this is quite easy: You can generally type Ctrl-C, and the Db2 Command Line Processor... read more