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!

Investigating Locking in Db2

Investigating Locking in 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...

read more
Prepping for MySQL 5.7 Upgrade

Prepping for MySQL 5.7 Upgrade

MySQL 5.6 reached its end-of-life (EOL) in February 2021. If you haven't upgraded to MySQL 5.7, you are not the only one. It can be an intimidating endeavor. There are configuration, system table, server, Innodb and SQL changes to consider. And, documentation is not...

read more
Resolving SQLCODE -551 on View Creation

Resolving SQLCODE -551 on View Creation

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

read more
Percona XtraBackup Example

Percona XtraBackup Example

For this example, the following software versions were in use: Ubuntu v20.04.3MySQL server v5.7.35Percona XtraBackup v2.4.24 It is important to note that Percona XtraBackup 8.0 is not compatible with MySQL version 5.7 and was introduced for use with MySQL version 8.0....

read more
Encrypted Replication for MySQL

Encrypted Replication for MySQL

Encrypted connections for MySQL replication are the default as of 8.0. The following simple example shows a basic setup for encrypted replication using Ubuntu 20.04 and MySQL Community 8.0.27. The steps may be similar for other Linux distributions. The necessary files...

read more
Validating Db2 Software Download Integrity

Validating Db2 Software Download Integrity

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

read more

Speak with an Expert DBA now!

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