by XTIVIA | Nov 9, 2021 | Blog, Db2
IBM Passport Advantage is the offering that can be used by customers as a one-stop-shop to view their IBM licensing entitlements, purchase orders and a plethora of other information. Oftentimes, when you need to download the latest binaries for a product that you need...
by XTIVIA | Nov 2, 2021 | Blog, Db2
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...
by XTIVIA | Oct 6, 2021 | Blog, MySQL
What is a deadlock and what exactly does it mean in regards to databases? In order to fully define what a deadlock is, it’s important to note that a ‘lock’ itself occurs when multiple processes are simultaneously trying to access the same resource. A...
by XTIVIA | Aug 20, 2021 | Blog, MySQL
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...
by XTIVIA | Jun 24, 2021 | Blog, SQL Server
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....
by XTIVIA | May 7, 2021 | Blog, Db2
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...
