by Phil Trbovic | Apr 6, 2023 | Blog, Db2
We, as DBAs, have all encountered a situation where a bad query just kept running and sucked up the database resources while holding onto logs. It’s always a “simple select” that seems to run over 12 hours. Db2 used to have the governor. This nifty...
by XTIVIA | Feb 14, 2023 | Blog, Db2
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...
by Marc Petros | May 4, 2022 | Blog, 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...
by Phil Trbovic | Mar 18, 2022 | Blog, Db2
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...
by Ian Bjorhovde | Dec 17, 2021 | Blog, Db2
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....
by Ian Bjorhovde | Nov 24, 2021 | Blog, Db2
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...