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!

Finding the Size of Individual Indexes

Finding the Size of Individual Indexes

Recently I had a client ask me if there was a way to calculate the size of individual indexes on a table and how to interpret what is reported by the table function sysproc.admin_get_index_info. The client asked whether the value is reported as a sum per table or per...

read more
How to use mysql_config_editor

How to use mysql_config_editor

Background When running a batch file on MySQL the login credentials must be taken from some file. The file choices are to use a clear-text options file or the more secure obfuscated login-file generated by the MySQL program mysql_config_editor (which comes installed...

read more
The Importance of /etc/hosts on Db2 Systems

The Importance of /etc/hosts on Db2 Systems

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: db2inst1@db2server $ time db2pd - Database Member 0 -- Active -- Up 0 days...

read more

Speak with an Expert DBA now!

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