IDUG is a hugely popular Db2 conference that Db2 enthusiasts look forward to attending every year. They have several of these around the world. This year, we have IDUG events in NA, EMEA, Australasia and India. Professionals from the US and Canada often attend the...
Db2 Blog Posts
Investigating Locking in Db2
The purpose of this article is to provide guidance on the various ways available for getting basic information about locking events in a Db2 database. Where possible the information gathered allows for targeting a specific table. The information provided by these...
Resolving SQLCODE -551 on View Creation
I recently faced an interesting challenge. I was working to replace (rebuild) a view with updated DDL, but when executing the CREATE OR REPLACE VIEW statement, Db2 returned error code SQL0551N. This error means that the user ID doesn't have authority to perform the...
Validating Db2 Software Download Integrity
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....
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...
How to Navigate IBM Passport Advantage to Download Software and Licenses
IBM Passport Advantage is the offering that can be used by customers as a one-stop-shop to view their IBM licensing entitlements, purchase orders and a plethora of other information. Oftentimes, when you need to download the latest binaries for a product that you need...
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...
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: [email protected] $ time db2pd - Database Member 0 -- Active -- Up 0 days...
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...
SSMA Db2toSQL Migration Fails without Error
The SQL Server Migration Assistant (SSMA) is a tool for transitioning from other platforms like Db2 to Microsoft SQL Server. A reference guide for the SSMA can be found in Microsoft's SQL Docs. This article addresses the issue of failed migrations without warnings or...