Phil Trbovic, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts Remote Database Administration Sat, 27 May 2023 01:08:23 +0000 en-US hourly 1 https://wordpress.org/?v=6.9.4 https://virtual-dba.com/wp-content/uploads/cropped-VirtualDBA-favicon-32x32.png Phil Trbovic, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts 32 32 NORETRIEVE Option for Db2 ROLLFORWARD in Data Loss Event https://virtual-dba.com/blog/noretrieve-option-for-db2-rollforward-in-data-loss-event/ https://virtual-dba.com/blog/noretrieve-option-for-db2-rollforward-in-data-loss-event/#respond Thu, 25 May 2023 21:55:21 +0000 https://virtual-dba.com/?p=241533 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 time without actually retrieving any archived log files […]

The post NORETRIEVE Option for Db2 ROLLFORWARD in Data Loss Event appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/noretrieve-option-for-db2-rollforward-in-data-loss-event/feed/ 0 Using Workload Manager (WLM) to End Long-Running Queries https://virtual-dba.com/blog/using-wlm-to-end-long-running-queries/ https://virtual-dba.com/blog/using-wlm-to-end-long-running-queries/#respond Thu, 06 Apr 2023 21:33:45 +0000 https://virtual-dba.com/?p=241402 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 little tool was used to perform this task, but it […]

The post Using Workload Manager (WLM) to End Long-Running Queries appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/using-wlm-to-end-long-running-queries/feed/ 0 Resolving SQLCODE -551 on View Creation https://virtual-dba.com/blog/resolving-sqlcode-551-on-view-creation/ https://virtual-dba.com/blog/resolving-sqlcode-551-on-view-creation/#respond Fri, 18 Mar 2022 16:08:00 +0000 https://virtual-dba.com/?p=240542 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 operation. How could this happen? I was connected as the instance […]

The post Resolving SQLCODE -551 on View Creation appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/resolving-sqlcode-551-on-view-creation/feed/ 0