by Phil Trbovic | May 25, 2023 | Blog, Db2
The NORETRIEVE parameter of a Db2 ROLLFORWARD command is a powerful tool that can be used to recover data from a database during a disaster or other data loss event. When the NORETRIEVE parameter is specified, Db2 will roll forward the database to a defined point in...
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 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...
