Our blog isn’t just a record. It’s a resource.

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!

Cloning 19c Oracle Home on RAC

Cloning 19c Oracle Home on RAC

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...

read more
How and When to Run the db2chgpath Utility

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...

read more
SQL DBA Certification

SQL DBA Certification

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...

read more
Migrating a Db2 DPF Instance from rsh to ssh

Migrating a Db2 DPF Instance from rsh to ssh

Db2's Database Partitioning Feature (DPF) allows a single Db2 instance to span multiple physical servers — allowing a single Db2 database to scale out to sizes well beyond what is possible on a single physical server. To manage a DPF environment, Db2 needs to be able...

read more
Query Store in SQL Server 2016

Query Store in SQL Server 2016

Every environment is configured differently; however, we have all experienced alerts being triggered due to unfavorable performance. Oftentimes, before our root cause analysis begins, the issue has resolved itself and/or someone may have rebooted. Although current...

read more

Speak with an Expert DBA now!

Call: (888) 685-3101 or fill out the form