Ian Bjorhovde, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts

Introducing db2pdtop.pl

Ian Bjorhovde — Tue, 16 May 2023 22:36:14 +0000

When monitoring CPU utilization on a Db2 server, each Db2 instance generally has a single db2sysc process (per database partition) consuming CPU on the server. The db2sysc process is made up of many threads. While it’s possible to see CPU utilization of each thread within the db2sysc process using top -H, this view is limited […]

The post Introducing db2pdtop.pl appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

Validating Db2 Software Download Integrity

Ian Bjorhovde — Fri, 17 Dec 2021 17:04:28 +0000

With the release of Db2 11.5.7.0, IBM has finally started providing cryptographically signed installation image files. This is important because it provides a means to verify that the installation image has not been tampered with or corrupted during download. Unfortunately, IBM does not provide instructions to verify the image, but it’s quite simple. When you […]

The post Validating Db2 Software Download Integrity appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

Is it Safe to Drop a Tablespace?

Ian Bjorhovde — Wed, 24 Nov 2021 18:14:00 +0000

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 used in your database. When working to clean up a database and remove […]

The post Is it Safe to Drop a Tablespace? appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

The Importance of /etc/hosts on Db2 Systems

Ian Bjorhovde — Tue, 10 Aug 2021 19:46:45 +0000

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 21:53:44 -- Date 2021-07-22-11.29.15.283543 real 0m5.560s […]

The post The Importance of /etc/hosts on Db2 Systems appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

Migrating a Db2 DPF Instance from rsh to ssh

Ian Bjorhovde — Thu, 11 Mar 2021 22:53:34 +0000

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 to execute commands (such as db2start) on all servers […]

The post Migrating a Db2 DPF Instance from rsh to ssh appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

Validating VIP Usage

Ian Bjorhovde — Thu, 14 May 2020 20:23:18 +0000

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 the database. We quickly recognized that the applications were trying (and […]

The post Validating VIP Usage appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

Terminating Db2 Backups to a Vendor Media Server

Ian Bjorhovde — Thu, 09 Jan 2020 15:45:00 +0000

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 will stop the backup. However, if your backup (or restore) […]

The post Terminating Db2 Backups to a Vendor Media Server appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.