We know how difficult managing a database can be. Luckily, we’re here to share our experiences troubleshooting, building, improving, and operating them. Browse blogs below, and feel free to comment!
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...
In this tutorial, I will go over the steps to clone your MySQL instance on the same server. This tutorial will only cover the steps to accomplish a clone on a Linux server. To ensure you do not cause corruption to the existing MySQL instance you will need to ensure...
Normalization is not that complicated. In fact, the beauty of these rules is that you may not know you're already applying them in your database design. To demonstrate, over the course of this multi-part series, we'll be covering the three generally accepted levels of...
The most satisfying meal is the one you make yourself, and database backup jobs are no different. Many DBAs use maintenance plans as a "one-stop-shop" for maintaining their SQL Server databases. After all, they do backups, integrity checks, index maintenance... What...
There are many reasons to install Windows Guest Additions for Oracle VM VirtualBox: mouse pointer integration, enable shared folders and clipboard, optimal video support, as well as generic host/guest communications. The most notable feature is the ability to resize...
This checklist outlines the steps I took to migrate SQL Server Always On 2017 Enterprise to 2019 Enterprise edition. Having mixed versions of AG's is a temporary solution meant for upgrading or migration purposes only and is not intended for long term use. Preparing...
July 13th, 2021 is quickly approaching. This is the date Microsoft has announced as the end of Mainstream Support for SQL Server 2016. What does this mean for the large number of Servers and applications using SQL Server 2016? You feel like you just completed your...
Starting from Oracle19c cloning your oracle home is a bit different, whether you use this method for out of place patching or rolling out patches to multiple servers we no longer use clone.pl, instead oracle recommends using the software-only install option, available...
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...
People choose to get certified for a variety of reasons. Many IT Professionals get certified to update their skills and give their resume the automatic boost that comes with certification. Other technology users may choose to get certified to become more well-rounded...